public static string[] GetCompletionList(string prefixText, int count, string contextKey)
{
DMRequisitionCancellation Obj_RequisitionCafeteria = new DMRequisitionCancellation();
String[] SearchList = Obj_RequisitionCafeteria.GetSuggestedRecord(prefixText);
return(SearchList);
}
private void ReportGridItem()
{
try
{
DataSet DsGrd = new DataSet();
StrCondition = string.Empty;
int ReqId = Convert.ToInt32(ddlReqNo.SelectedValue.ToString());
DsGrd = obj_DMReqCancellation.GetRecordForItem("I", ReqId, out StrError);
if (DsGrd.Tables.Count > 0 && DsGrd.Tables[0].Rows.Count > 0)
{
GridDtlsItem.DataSource = DsGrd.Tables[0];
GridDtlsItem.DataBind();
GridDtlsItem.Visible = true;
}
else
{
GridDtlsItem.DataSource = null;
GridDtlsItem.DataBind();
}
obj_DMReqCancellation = null;
DsGrd = null;
}
catch (Exception ex) { throw new Exception(ex.Message); }
}
private void FillCombo()
{
try
{
DataSet DSRequisition = new DataSet();
string cond = string.Empty;
//if (Convert.ToBoolean(Session["IsCentral"].ToString()))
//{
// cond = string.Empty;
//}
//else
//{
// cond = " and RC.CafeteriaId="+Convert.ToInt32(Session["CafeteriaId"].ToString());
//}
DSRequisition = obj_DMReqCancellation.FillCombo(cond, out StrError);
if (DSRequisition.Tables.Count > 0)
{
if (DSRequisition.Tables[0].Rows.Count > 0)
{
ddlReqNo.DataSource = DSRequisition.Tables[0];
ddlReqNo.DataTextField = "RequisitionNo";
ddlReqNo.DataValueField = "RequisitionCafeId";
ddlReqNo.DataBind();
ddlReqNo.Focus();
}
}
else
{
DSRequisition = null;
obj_DMReqCancellation = null;
}
}
catch (Exception ex) { throw new Exception(ex.Message); }
}
private void ReportToGrid()
{
try
{
DataSet DsGrd = new DataSet();
StrCondition = string.Empty;
if (ChkFrmDate.Checked == true)
{
StrCondition = StrCondition + " AND (RequisitionDate between '" + Convert.ToDateTime(txtFromDate.Text).ToString("MM-dd-yyyy") + "' AND '" + Convert.ToDateTime(txtToDate.Text).ToString("MM-dd-yyyy") + "' )";
}
else
{
StrCondition = StrCondition + " AND (RequisitionDate between '01-01-1975' AND '" + DateTime.Now.ToString("MM-dd-yyyy") + "' )";
}
//if (!Convert.ToBoolean(Session["IsCentral"].ToString()))
//{
// //StrCondition = StrCondition + " AND RCF.CafeteriaId=" + Convert.ToInt32(Session["CafeteriaId"].ToString());
//}
DsGrd = obj_DMReqCancellation.GetRecordForRequisition("R", StrCondition, out StrError);
if (DsGrd.Tables.Count > 0 && DsGrd.Tables[0].Rows.Count > 0)
{
GridDetails.DataSource = DsGrd.Tables[0];
GridDetails.DataBind();
GridDetails.Visible = true;
}
else
{
GridDetails.DataSource = null;
GridDetails.DataBind();
}
obj_DMReqCancellation = null;
DsGrd = null;
}
catch (Exception ex) { throw new Exception(ex.Message); }
}
protected void BtnUpdate_Click(object sender, EventArgs e)
{
int InsertRow = 0, UpdateIsDelivr = 0, InsertRowDtls = 0;
try
{
//--------**Save Record RequisitionWise**-----------
if (RdoType.SelectedValue == "R")
{
Entity_ReqCancellation.RequisitionCancelId = Convert.ToInt32(ViewState["ID"]);
Entity_ReqCancellation.CancelledBy = lblEmployee.Text;
Entity_ReqCancellation.CancelledDate = (!string.IsNullOrEmpty(TxtCancelDate.Text)) ? Convert.ToDateTime(TxtCancelDate.Text) : Convert.ToDateTime("01/01/1753");
Entity_ReqCancellation.Reason = TxtCancelReason.Text;
Entity_ReqCancellation.UserId = Convert.ToInt32(Session["UserId"]);
Entity_ReqCancellation.LoginDate = DateTime.Now;
//--**Update Cancel Flag in RequisitionCageteria**--
for (int i = 0; i < GridDetails.Rows.Count; i++)
{
Label LblEntryId = (Label)GridDetails.Rows[i].Cells[i].FindControl("LblEntryId");
CheckBox GrdSelectAll1 = (CheckBox)GridDetails.Rows[i].Cells[i].FindControl("GrdSelectAll1");
Entity_ReqCancellation.RequisitionCafeId = Convert.ToInt32(LblEntryId.Text);
Entity_ReqCancellation.IsCancel = GrdSelectAll1.Checked.Equals(false) ? 0 : 1;
InsertRow = obj_DMReqCancellation.UpdateRequisitionWise(ref Entity_ReqCancellation, out StrError);
}
if (InsertRow > 0)
{
if (InsertRow > 0)
{
obj_Comman.ShowPopUpMsg("Record Saved Successfully", this.Page);
MakeEmptyForm();
Entity_ReqCancellation = null;
obj_DMReqCancellation = null;
}
}
}
//--------**Save Record ItemWise**-----------
else
{
int CountChecked = 0;
int CancelID = Convert.ToInt32(ViewState["ID"]);
Entity_ReqCancellation.RequisitionCancelId = Convert.ToInt32(ViewState["ID"]);
Entity_ReqCancellation.RequisitionCafeId = Convert.ToInt32(ddlReqNo.SelectedValue);
Entity_ReqCancellation.CancelledBy = lblEmployee.Text;
Entity_ReqCancellation.CancelledDate = (!string.IsNullOrEmpty(TxtCancelDate.Text)) ? Convert.ToDateTime(TxtCancelDate.Text) : Convert.ToDateTime("01/01/1753");
Entity_ReqCancellation.Reason = TxtCancelReason.Text;
Entity_ReqCancellation.UserId = Convert.ToInt32(Session["UserId"]);
Entity_ReqCancellation.LoginDate = DateTime.Now;
InsertRow = obj_DMReqCancellation.UpdateRequisitionItemWise(ref Entity_ReqCancellation, out StrError);
//--**Update Cancel Flag in RequisitionCafeDetails**--
for (int i = 0; i < GridDtlsItem.Rows.Count; i++)
{
Label LblEntryId = (Label)GridDtlsItem.Rows[i].Cells[1].FindControl("LblEntryId");
Entity_ReqCancellation.RequisitionCancelId = Convert.ToInt32(CancelID);
Entity_ReqCancellation.RequisitionCafeId = Convert.ToInt32(LblEntryId.Text);
Entity_ReqCancellation.OrdQty = Convert.ToDecimal(GridDtlsItem.Rows[i].Cells[7].Text.ToString());
Entity_ReqCancellation.ItemId = Convert.ToInt32(GridDtlsItem.Rows[i].Cells[10].Text.ToString());
if (((CheckBox)GridDtlsItem.Rows[i].Cells[i].FindControl("GrdSelectAll2")).Checked == true)
{
InsertRow = obj_DMReqCancellation.InsertReqCancelDtls(ref Entity_ReqCancellation, out StrError);
}
else
{
CountChecked = CountChecked + 1;
}
}
if (CountChecked == GridDtlsItem.Rows.Count)
{
}
if (InsertRow > 0)
{
if (InsertRow > 0)
{
obj_Comman.ShowPopUpMsg("Record Saved Successfully", this.Page);
MakeEmptyForm();
Entity_ReqCancellation = null;
obj_DMReqCancellation = null;
}
}
}
}
catch (Exception ex)
{
throw new Exception(ex.Message);
}
}
