protected void txtHolidayName_OnTextChanged(object sender, EventArgs e)
{
if (editid.Value == "")
{
DataTable dt = objHoliday.GetHolidayMasterByHolidayName(Session["CompId"].ToString().ToString(), txtHolidayName.Text.Trim());
if (dt.Rows.Count > 0)
{
txtHolidayName.Text = "";
DisplayMessage("Holiday Name Already Exists");
System.Web.UI.ScriptManager.GetCurrent(this).SetFocus(txtHolidayName);
return;
}
DataTable dt1 = objHoliday.GetHolidayMasterInactive(Session["CompId"].ToString().ToString());
dt1 = new DataView(dt1, "Holiday_Name='" + txtHolidayName.Text + "'", "", DataViewRowState.CurrentRows).ToTable();
if (dt1.Rows.Count > 0)
{
txtHolidayName.Text = "";
DisplayMessage("Holiday Name Already Exists - Go to Bin Tab");
System.Web.UI.ScriptManager.GetCurrent(this).SetFocus(txtHolidayName);
return;
}
txtHolidayNameL.Focus();
}
else
{
DataTable dtTemp = objHoliday.GetHolidayMasterById(Session["CompId"].ToString().ToString(), editid.Value);
if (dtTemp.Rows.Count > 0)
{
if (dtTemp.Rows[0]["Holiday_Name"].ToString() != txtHolidayName.Text)
{
DataTable dt = objHoliday.GetHolidayMaster(Session["CompId"].ToString().ToString());
dt = new DataView(dt, "Holiday_Name='" + txtHolidayName.Text + "'", "", DataViewRowState.CurrentRows).ToTable();
if (dt.Rows.Count > 0)
{
txtHolidayName.Text = "";
DisplayMessage("Holiday Name Already Exists");
System.Web.UI.ScriptManager.GetCurrent(this).SetFocus(txtHolidayName);
return;
}
DataTable dt1 = objHoliday.GetHolidayMaster(Session["CompId"].ToString().ToString());
dt1 = new DataView(dt1, "Holiday_Name='" + txtHolidayName.Text + "'", "", DataViewRowState.CurrentRows).ToTable();
if (dt1.Rows.Count > 0)
{
txtHolidayName.Text = "";
DisplayMessage("Holiday Name Already Exists - Go to Bin Tab");
System.Web.UI.ScriptManager.GetCurrent(this).SetFocus(txtHolidayName);
return;
}
}
}
txtHolidayNameL.Focus();
}
}
public static string[] GetCompletionListHolidayName(string prefixText, int count, string contextKey)
{
HolidayMaster objHolidayMaster = new HolidayMaster();
DataTable dt = new DataView(objHolidayMaster.GetHolidayMaster(HttpContext.Current.Session["CompId"].ToString()), "Holiday_Name like '" + prefixText.ToString() + "%'", "", DataViewRowState.CurrentRows).ToTable();
string[] txt = new string[dt.Rows.Count];
for (int i = 0; i < dt.Rows.Count; i++)
{
txt[i] = dt.Rows[i]["Holiday_Name"].ToString();
}
return(txt);
}
