////////////////////////////////////////////////////////
<script type="text/javascript">
function DepartmentsSelected(sender, e) {
var values = e.get_value().split(":");
var LeaveRecommendAuthirty = values[1];
var LeaveSanctionAuthority = values[2];
if (LeaveRecommendAuthirty != '') {
$('#dropleaverecommend').val(LeaveRecommendAuthirty);
}
else {
$('#dropleaverecommend').val('0');
}
if (LeaveSanctionAuthority != '') {
$('#dropsanctionauthority').val(LeaveSanctionAuthority);
}
else {
$('#dropsanctionauthority').val('0');
}
return false;
}
///////////////////////////////////////////////////
<td>Department Name
<br />
<asp:TextBox ID="txtdepartment" CssClass="text" runat="server" ClientIDMode="Static"></asp:TextBox>
<cc1:AutoCompleteExtender ID="txtdepartment_AutoCompleteExtender" runat="server" DelimiterCharacters="" Enabled="True"
MinimumPrefixLength="2" OnClientItemSelected="DepartmentsSelected"
ServiceMethod="DisplayDepartments" TargetControlID="txtdepartment" UseContextKey="True">
</cc1:AutoCompleteExtender>
</td>
//////////////////////////////////////////////////
[System.Web.Services.WebMethodAttribute(), System.Web.Script.Services.ScriptMethodAttribute()]
public static List<String> DisplayDepartments(string prefixText)
{
Department ob = new Department();
DataSet ds = ob.DisplayDepartments(prefixText);
List<String> Departments = new List<String>();
Int32 i = -1;
foreach (DataRow row in ds.Tables[0].Rows)
{
String item = AjaxControlToolkit.AutoCompleteExtender.CreateAutoCompleteItem(row["Name"].ToString(), row["ID"].ToString() + ":" + row["LeaveRecommendAuthirty"].ToString() + ":" + row["LeaveSanctionAuthority"].ToString());
Departments.Add(item);
}
return Departments;
}
///////////////////////////////////////////////////
ALTER PROC [dbo].[pDisplayDepartment]
@Department VARCHAR(50)
AS
BEGIN
SELECT Name,Id,ISNULL(LeaveRecommendAuthirty,'') AS LeaveRecommendAuthirty,ISNULL(LeaveSanctionAuthority,'') AS LeaveSanctionAuthority
FROM dbo.Department
WHERE Name LIKE '%' + @Department + '%' AND isActive=1
END
///////////////////////////////////////////////////
No comments:
Post a Comment