public int InsertRecord(ref RequisitionCancellation Entity_Call, out string StrError)
{
int iInsert = 0;
StrError = string.Empty;
try
{
SqlParameter pAction = new SqlParameter(RequisitionCancellation._Action, SqlDbType.BigInt);
// SqlParameter pRequisitionCancelNo = new SqlParameter(RequisitionCancellation._RequisitionCancelNo, SqlDbType.NVarChar);
SqlParameter pRequisitionCafeId = new SqlParameter(RequisitionCancellation._RequisitionCafeId, SqlDbType.BigInt);
SqlParameter pCancelledBy = new SqlParameter(RequisitionCancellation._CancelledBy, SqlDbType.NVarChar);
SqlParameter pCancelledDate = new SqlParameter(RequisitionCancellation._CancelledDate, SqlDbType.DateTime);
SqlParameter pReason = new SqlParameter(RequisitionCancellation._Reason, SqlDbType.NVarChar);
SqlParameter pCancelType = new SqlParameter(RequisitionCancellation._CancelType, SqlDbType.Bit);
SqlParameter pCreatedBy = new SqlParameter(RequisitionCancellation._UserId, SqlDbType.BigInt);
SqlParameter pCreatedDate = new SqlParameter(RequisitionCancellation._LoginDate, SqlDbType.DateTime);
pAction.Value = 1;
// pRequisitionCancelNo.Value = Entity_Call.RequisitionCancelNo;
pRequisitionCafeId.Value = Entity_Call.RequisitionCafeId;
pCancelledBy.Value = Entity_Call.CancelledBy;
pCancelledDate.Value = Entity_Call.CancelledDate;
pReason.Value = Entity_Call.Reason;
pCancelType.Value = Entity_Call.CancelType;
pCreatedBy.Value = Entity_Call.UserId;
pCreatedDate.Value = Entity_Call.LoginDate;
SqlParameter[] param = new SqlParameter[] { pAction, pRequisitionCafeId, pCancelledBy,
pCancelledDate, pReason, pCancelType, pCreatedBy, pCreatedDate };
Open(CONNECTION_STRING);
BeginTransaction();
iInsert = SQLHelper.ExecuteScalar(_Connection, _Transaction, CommandType.StoredProcedure, RequisitionCancellation.SP_RequisitionCancellation, param);
if (iInsert > 0)
{
CommitTransaction();
}
else
{
RollBackTransaction();
}
}
catch (Exception ex)
{
RollBackTransaction();
StrError = ex.Message;
}
finally
{
Close();
}
return(iInsert);
}
public int InsertReqCancelDtls(ref RequisitionCancellation Entity_Call, out string StrError)
{
int iInsert = 0;
StrError = string.Empty;
try
{
SqlParameter pAction = new SqlParameter(RequisitionCancellation._Action, SqlDbType.BigInt);
SqlParameter pRequisitionCancelId = new SqlParameter(RequisitionCancellation._RequisitionCancelId, SqlDbType.BigInt);
SqlParameter pRequisitionCafeId = new SqlParameter(RequisitionCancellation._RequisitionCafeId, SqlDbType.BigInt);
SqlParameter pItemsId = new SqlParameter(RequisitionCancellation._ItemId, SqlDbType.BigInt);
SqlParameter pQty = new SqlParameter(RequisitionCancellation._OrdQty, SqlDbType.Decimal);
pAction.Value = 10;
pRequisitionCancelId.Value = Entity_Call.RequisitionCancelId;
pRequisitionCafeId.Value = Entity_Call.RequisitionCafeId;
pItemsId.Value = Entity_Call.ItemId;
pQty.Value = Entity_Call.OrdQty;
SqlParameter[] param = new SqlParameter[] { pAction, pRequisitionCancelId, pRequisitionCafeId, pItemsId, pQty };
Open(CONNECTION_STRING);
BeginTransaction();
iInsert = SQLHelper.ExecuteNonQuery(_Connection, _Transaction, CommandType.StoredProcedure, RequisitionCancellation.SP_RequisitionCancellation, param);
if (iInsert > 0)
{
CommitTransaction();
}
else
{
RollBackTransaction();
}
}
catch (Exception ex)
{
RollBackTransaction();
StrError = ex.Message;
}
finally
{
Close();
}
return(iInsert);
}
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);
}
}
