protected void btnSave_Click(object sender, EventArgs e)
{
CustomerTypeWiseSPLimit oCTWiseSPLimit = new CustomerTypeWiseSPLimit();
CustomerTypeWiseSPLimitDAL oCTWiseSPLimitDAL = new CustomerTypeWiseSPLimitDAL();
oCTWiseSPLimit.SPType.SPTypeID = ddlSPType.SelectedItem.Value.Trim();
oCTWiseSPLimit.CustomerType.CustomerTypeID = ddlCustType.SelectedItem.Value.Trim();
oCTWiseSPLimit.MinimumLimit = Convert.ToInt32(txtMinLim.Text.Trim());
oCTWiseSPLimit.MaximumLimit = Convert.ToInt32(txtMaxLim.Text.Trim());
oCTWiseSPLimit.UserDetails = ucUserDet.UserDetail;
oCTWiseSPLimit.UserDetails.MakeDate = DateTime.Now;
ucUserDet.ResetData();
Result oResult = (Result)oCTWiseSPLimitDAL.Save(oCTWiseSPLimit);
if (oResult.Status)
{
ClearTextValue();
this.LoadList();
hdCustomerID.Value = "";
ucMessage.OpenMessage(Constants.MSG_SUCCESS_SAVE, Constants.MSG_TYPE_SUCCESS);
}
else
{
ucMessage.OpenMessage(Constants.MSG_ERROR_SAVE, Constants.MSG_TYPE_ERROR);
}
}
public void SetData(string sSpTypeID, string sCustomerType, string sMasterNo)
{
CustomerTypeWiseSPLimit oCTWiseSPLimit = new CustomerTypeWiseSPLimit(sCustomerType, sSpTypeID);
CustomerTypeWiseSPLimitDAL oCTWiseSPLimitDAL = new CustomerTypeWiseSPLimitDAL();
Result oResult = new Result();
oResult = oCTWiseSPLimitDAL.LoadByID(oCTWiseSPLimit);
if (oResult.Status)
{
oCTWiseSPLimit = (CustomerTypeWiseSPLimit)oResult.Return;
txtSPType.Text = sSpTypeID;
txtCustomerType.Text = sCustomerType;
txtMaximumLimit.Text = oCTWiseSPLimit.MinimumLimit.ToString();
txtMinimumLimit.Text = oCTWiseSPLimit.MaximumLimit.ToString();
}
// Load Grid Data
oResult = oCTWiseSPLimitDAL.CheckUserLimit(sSpTypeID, sMasterNo);
if (oResult.Status)
{
DataTable dtLimit = (DataTable)oResult.Return;
if (dtLimit != null)
{
if (dtLimit.Rows.Count > 0)
{
dtLimit.Rows[0]["Allowed Limit"] = (Util.GetDecimalNumber(dtLimit.Rows[0]["IssueAmount"].ToString()) - Util.GetDecimalNumber(txtMaximumLimit.Text)).ToString();
}
}
gvSearchList.DataSource = dtLimit;
gvSearchList.DataBind();
decimal tfsHours = (decimal)dtLimit.Compute("Sum(IssueAmount)", "");
txtTotalAmount.Text = tfsHours.ToString("N2");
}
}
private void LoadDataByID(string sCustomerID, string sSPTypeID)
{
CustomerTypeWiseSPLimit oCTWiseSPLimit = new CustomerTypeWiseSPLimit(sCustomerID, sSPTypeID);
CustomerTypeWiseSPLimitDAL oCTWiseSPLimitDAL = new CustomerTypeWiseSPLimitDAL();
Result oResult = new Result();
oResult = oCTWiseSPLimitDAL.LoadByID(oCTWiseSPLimit);
if (oResult.Status)
{
oCTWiseSPLimit = (CustomerTypeWiseSPLimit)oResult.Return;
DDListUtil.Assign(ddlSPType, oCTWiseSPLimit.SPType.SPTypeID.Trim());
DDListUtil.Assign(ddlCustType, oCTWiseSPLimit.CustomerType.CustomerTypeID.Trim());
ddlCustType.Enabled = false;
ddlSPType.Enabled = false;
txtMinLim.Text = oCTWiseSPLimit.MinimumLimit.ToString();
txtMaxLim.Text = oCTWiseSPLimit.MaximumLimit.ToString();
if (string.IsNullOrEmpty(hdDataType.Value))
{
//When Loading from Approver End
UserDetails userDetails = ucUserDet.UserDetail;
userDetails.MakerID = oCTWiseSPLimit.UserDetails.MakerID;
userDetails.MakeDate = oCTWiseSPLimit.UserDetails.MakeDate;
ucUserDet.UserDetail = userDetails;
}
else if (hdDataType.Value.Equals("T"))
{
//When loading from temp table
UserDetails userDetails = ucUserDet.UserDetail;
userDetails.CheckDate = oCTWiseSPLimit.UserDetails.CheckDate;
userDetails.CheckerID = oCTWiseSPLimit.UserDetails.CheckerID;
userDetails.CheckDate = oCTWiseSPLimit.UserDetails.CheckDate;
userDetails.CheckerComment = oCTWiseSPLimit.UserDetails.CheckerComment;
ucUserDet.UserDetail = userDetails;
}
hdCustomerID.Value = oCTWiseSPLimit.CustomerType.CustomerTypeID;
hdSPTypeID.Value = oCTWiseSPLimit.SPType.SPTypeID;
}
else
{
ucMessage.OpenMessage(Constants.MSG_ERROR_NOT_FOUND, Constants.MSG_TYPE_ERROR);
}
}
protected void btnApprove_Click(object sender, EventArgs e)
{
if (!string.IsNullOrEmpty(hdCustomerID.Value))
{
CustomerTypeWiseSPLimit oCTWiseSPLimit = new CustomerTypeWiseSPLimit(hdCustomerID.Value == "" ? "0" : hdCustomerID.Value, hdSPTypeID.Value == "" ? "0" : hdSPTypeID.Value);
CustomerTypeWiseSPLimitDAL oCTWiseSPLimitDAL = new CustomerTypeWiseSPLimitDAL();
oCTWiseSPLimit.UserDetails = ucUserDet.UserDetail;
Result oResult = (Result)oCTWiseSPLimitDAL.Approve(oCTWiseSPLimit);
if (oResult.Status)
{
ucMessage.OpenMessage(Constants.MSG_SUCCESS_APPROVE, Constants.MSG_TYPE_SUCCESS);
}
else
{
ucMessage.OpenMessage(Constants.MSG_ERROR_APPROVE, Constants.MSG_TYPE_ERROR);
}
}
else
{
ucMessage.OpenMessage(Constants.MSG_ERROR_REJECT, Constants.MSG_TYPE_ERROR);
}
}
public void LoadList()
{
Config oConfig = (Config)Session[Constants.SES_USER_CONFIG];
if (oConfig != null)
{
CustomerTypeWiseSPLimit oCTWiseSPLimit = new CustomerTypeWiseSPLimit();
CustomerTypeWiseSPLimitDAL oCTWiseSPLimitDAL = new CustomerTypeWiseSPLimitDAL();
Result oResult = oCTWiseSPLimitDAL.LoadUnapprovedList(oConfig.UserName, false);
if (oResult.Status)
{
DataTable dtTmpDataList = (DataTable)oResult.Return;
DataTable dtTmp = new DataTable();
dtTmp = dtTmpDataList.Copy();
if (dtTmpDataList.Rows.Count > 0)
{
dtTmpDataList.Columns.Remove("CustomerTypeID");
dtTmpDataList.Columns.Remove("MakerID");
gvList.DataSource = dtTmpDataList;
gvList.DataBind();
this.gvList.HeaderRow.Cells[1].Text = "Customer Type";
this.gvList.HeaderRow.Cells[2].Text = "SP Type";
this.gvList.HeaderRow.Cells[3].Text = "Minimum Limit";
this.gvList.HeaderRow.Cells[4].Text = "Maximum Limit";
this.gvList.HeaderRow.Cells[5].Text = "Make Date";
int iStart = gvList.PageIndex * gvList.PageSize;
int iEnd = iStart + gvList.PageSize;
if (iEnd >= gvList.Rows.Count)
{
iEnd = gvList.Rows.Count;
}
for (int i = iStart; i < iEnd; i++)
{
HiddenField oHdCust = ((HiddenField)gvList.Rows[i].FindControl("hdCustTypeID"));
if (oHdCust != null)
{
oHdCust.Value = dtTmp.Rows[i]["CustomerTypeID"].ToString();
}
}
Session[Constants.SES_CONFIG_UNAPPROVE_DATA] = dtTmp;
}
else
{
gvList.DataSource = null;
gvList.DataBind();
}
}
else
{
ucMessage.OpenMessage(Constants.MSG_ERROR_NOT_FOUND, Constants.MSG_TYPE_ERROR);
}
}
else
{
ucMessage.OpenMessage(Constants.MSG_ERROR_NOT_FOUND, Constants.MSG_TYPE_ERROR);
}
}
