/// <summary>
/// If disbursment detail already existed, increase the requested qty,
/// else add as a new disbursement detail
/// </summary>
/// <param name="item"></param>
public void Add(DisbursementDetail item)
{
if (Count > 0)
{
var isNew = true;
for (int i = 0; i < Count; i++)
{
if (item.ItemNum == DisbursementDetails.ElementAt(i).ItemNum)
{
DisbursementDetails.ElementAt(i).RequestedQty += item.RequestedQty;
//check if enough in stock again, if not set actual qty equal to available in stock
DisbursementDetails.ElementAt(i).ActualQty = item.Stationery.AvailableQty > DisbursementDetails.ElementAt(i).RequestedQty
? DisbursementDetails.ElementAt(i).RequestedQty
: item.Stationery.AvailableQty;
isNew = false;
break;
}
}
if (isNew)
{
DisbursementDetails.Add(item);
Count++;
}
}
else
{
this.DisbursementDetails = new HashSet <DisbursementDetail>();
DisbursementDetails.Add(item);
Count++;
}
}
protected void Page_Load(object sender, EventArgs e)
{
try
{
if (!IsPostBack)
{
if (Session[clsConstant.TOKEN] == null)
{
UrlParameterPasser urlWrapper = new UrlParameterPasser();
urlWrapper["pageaccesserr"] = "1";
urlWrapper.Url = "../Logout.aspx";
urlWrapper.PassParameters();
}
if (Utility.CheckAccess("DisbursementDetailsAddEdit") == false)
{
UrlParameterPasser urlWrapper = new UrlParameterPasser();
urlWrapper.Url = "../DocumentLogSystem/DashBoard.aspx";
urlWrapper.PassParameters();
urlWrapper["pageaccesserror"] = "1";
}
if (!Convert.ToBoolean(Session[clsConstant.SESS_VIEWTYPE]))
{
this.MakeReadOnly(this.Controls);
}
disbursementID = Request.QueryString[clsConstant.SESS_DISBURSEMENT_ID];
DisbursementDetails objDis = new DisbursementDetails();
dataset = new DataSet();
disbursementDetailsObj = new DisbursementDetails();
objCommon = new CommonFunction();
if (disbursementID != null && IsPostBack == false)
{
LoanBinding();
drpYear.DataSource = objCommon.getDropDownList(clsConstant.SP_GET_YEAR, null);
drpYear.DataTextField = "DisplayFieldText";
drpYear.DataValueField = "ValueFieldText";
drpYear.DataBind();
dataset = disbursementDetailsObj.GetDisbursement(Convert.ToInt32(disbursementID));
FillTextBoxes(dataset);
btnSubmit.Visible = false;
btnUpdate.Visible = true;
}
if (disbursementID == null && IsPostBack == false)
{
LoanBinding();
drpYear.DataSource = objCommon.getDropDownList(clsConstant.SP_GET_YEAR, null);
drpYear.DataTextField = "DisplayFieldText";
drpYear.DataValueField = "ValueFieldText";
drpYear.DataBind();
btnUpdate.Visible = false;
btnSubmit.Visible = true;
}
}
}
catch (Exception ex)
{
logger.Error(ex);
}
}
protected void btnSearch_Click(object sender, EventArgs e)
{
try
{
disbursementDetailsObj = new DisbursementDetails();
lblSelectionError.Text = string.Empty;
if (drpLoanNumber.SelectedIndex > 0 || drpAgency.SelectedIndex > 0 || drpState.SelectedIndex > 0 || drpYear.SelectedIndex > 0 || drpSector.SelectedIndex > 0)
{
ds = new DataSet();
loanID = Convert.ToInt32(drpLoanNumber.SelectedValue);
yearID = Convert.ToInt32(drpYear.SelectedValue);
agencyID = Convert.ToInt32(drpAgency.SelectedValue);
state = drpState.SelectedItem.Text;
sector = drpSector.SelectedItem.Text;
ds = disbursementDetailsObj.DisbursementFilterMonthwise(loanID, yearID, agencyID, state, sector);
grdDisbursement.DataSource = null;
grdDisbursement.DataSource = ds;
grdDisbursement.DataBind();
Session[clsConstant.SESS_TABLE] = ds.Tables[0];
}
else
{
lblSelectionError.Text = "Please select some criteria";
lblSelectionError.ForeColor = Color.Red;
}
}
catch (Exception ex)
{
logger.Error(ex);
}
}
protected void btnSubmit_Click(object sender, EventArgs e)
{
try
{
disbursementDetailsObj = new DisbursementDetails();
ut = new Utility();
if (IsValid)
{
CalculateTotal();
status = disbursementDetailsObj.AddDisbursementDetails(int.Parse(drpLoanNumber.SelectedValue), Convert.ToInt32(drpYear.SelectedValue),
totalTargetDisbursement,
totalActualDisbursement, target1,
target2, target3,
target4, actual1,
actual2, actual3,
actual4, ((UserDetails)Session[clsConstant.TOKEN]).UserID);
if (status != 0)
{
ut.ResetFormControl(reSetDiv);
lblPromptMessage.Text = "Data Submitted Sucessfully";
}
}
}
catch (Exception ex)
{
logger.Error(ex);
}
}
protected void btnSubmit_Click(object sender, EventArgs e)
{
try
{
disbursementDetailsObj = new DisbursementDetails();
ut = new Utility();
if (IsValid)
{
status = disbursementDetailsObj.AddDisbursementDetailsMonthWise(int.Parse(drpLoanNumber.SelectedValue), Convert.ToInt32(drpYear.SelectedValue),
txtQuarterTarget1.Text == string.Empty ? 0 : Convert.ToDecimal(txtQuarterTarget1.Text),
txtQuarterTarget2.Text == string.Empty ? 0 : Convert.ToDecimal(txtQuarterTarget2.Text),
txtQuarterTarget3.Text == string.Empty ? 0 : Convert.ToDecimal(txtQuarterTarget3.Text),
txtQuarterTarget4.Text == string.Empty ? 0 : Convert.ToDecimal(txtQuarterTarget4.Text),
txtTQuarter1Jan.Text == string.Empty ? 0 : Convert.ToDecimal(txtTQuarter1Jan.Text),
txtTQuarter1Feb.Text == string.Empty ? 0 : Convert.ToDecimal(txtTQuarter1Feb.Text),
txtTQuarter1Mar.Text == string.Empty ? 0 : Convert.ToDecimal(txtTQuarter1Mar.Text),
txtTQuarter2Apr.Text == string.Empty ? 0 : Convert.ToDecimal(txtTQuarter2Apr.Text),
txtTQuarter2May.Text == string.Empty ? 0 : Convert.ToDecimal(txtTQuarter2May.Text),
txtTQuarter2Jun.Text == string.Empty ? 0 : Convert.ToDecimal(txtTQuarter2Jun.Text),
txtTQuarter3Jul.Text == string.Empty ? 0 : Convert.ToDecimal(txtTQuarter3Jul.Text),
txtTQuarter3Aug.Text == string.Empty ? 0 : Convert.ToDecimal(txtTQuarter3Aug.Text),
txtTQuarter3Sep.Text == string.Empty ? 0 : Convert.ToDecimal(txtTQuarter3Sep.Text),
txtTQuarter4Oct.Text == string.Empty ? 0 : Convert.ToDecimal(txtTQuarter4Oct.Text),
txtTQuarter4Nov.Text == string.Empty ? 0 : Convert.ToDecimal(txtTQuarter4Nov.Text),
txtTQuarter4Dec.Text == string.Empty ? 0 : Convert.ToDecimal(txtTQuarter4Dec.Text),
txtAQuarter1Jan.Text == string.Empty ? 0 : Convert.ToDecimal(txtAQuarter1Jan.Text),
txtAQuarter1Feb.Text == string.Empty ? 0 : Convert.ToDecimal(txtAQuarter1Feb.Text),
txtAQuarter1Mar.Text == string.Empty ? 0 : Convert.ToDecimal(txtAQuarter1Mar.Text),
txtAQuarter2Apr.Text == string.Empty ? 0 : Convert.ToDecimal(txtAQuarter2Apr.Text),
txtAQuarter2May.Text == string.Empty ? 0 : Convert.ToDecimal(txtAQuarter2May.Text),
txtAQuarter2Jun.Text == string.Empty ? 0 : Convert.ToDecimal(txtAQuarter2Jun.Text),
txtAQuarter3Jul.Text == string.Empty ? 0 : Convert.ToDecimal(txtAQuarter3Jul.Text),
txtAQuarter3Aug.Text == string.Empty ? 0 : Convert.ToDecimal(txtAQuarter3Aug.Text),
txtAQuarter3Sep.Text == string.Empty ? 0 : Convert.ToDecimal(txtAQuarter3Sep.Text),
txtAQuarter4Oct.Text == string.Empty ? 0 : Convert.ToDecimal(txtAQuarter4Oct.Text),
txtAQuarter4Nov.Text == string.Empty ? 0 : Convert.ToDecimal(txtAQuarter4Nov.Text),
txtAQuarter4Dec.Text == string.Empty ? 0 : Convert.ToDecimal(txtAQuarter4Dec.Text),
((UserDetails)Session[clsConstant.TOKEN]).UserID);
if (status != 0)
{
ut.ResetFormControl(reSetDiv);
lblPromptMessage.Text = "Data Submitted Sucessfully";
ResetLabel();
}
}
}
catch (Exception ex)
{
logger.Error(ex);
}
}
public DisbursementDetails APImodelconvertoDisbursementDetailmodel(DisbursementDetailAPIModel apimodel)
{
DisbursementDetails dd = new DisbursementDetails()
{
Id = apimodel.Id,
QtyNeeded = apimodel.QtyNeeded,
QtyReceived = apimodel.QtyReceived,
InventoryItemId = apimodel.InventoryItemId,
DisbursementId = apimodel.DisbursementId
};
return(dd);
}
protected void GridViewBinding()
{
dt = new DataTable();
ds = new DataSet();
disbursementDetailsObj = new DisbursementDetails();
ds = disbursementDetailsObj.BindGridviewMonthwise();
dt = ds.Tables[0];
grdDisbursement.DataSource = dt;
grdDisbursement.DataBind();
Session[clsConstant.SESS_TABLE] = dt;
CallToPerformanceTrack(ds.Tables[1], "Disbursement By Month");
}
public void GenerateDisbursementDetails(int qtyNeeded, int qtyReceived, int disbursementId, string inventoryItemId)
{
InventoryItem inventoryItem = invsvc.GetItemById(inventoryItemId);
DisbursementDetails disbursementDetails = new DisbursementDetails()
{
QtyNeeded = qtyNeeded,
QtyReceived = 0,
DisbursementId = disbursementId,
InventoryItemId = inventoryItem.Id
};
dbcontext.Add(disbursementDetails);
dbcontext.SaveChanges();
return;
}
protected void GridViewBinding()
{
dt = new DataTable();
ds = new DataSet();
disbursementDetailsObj = new DisbursementDetails();
ds = disbursementDetailsObj.BindGridview();
dt = ds.Tables[0];
grdDisbursement.DataSource = dt;
grdDisbursement.DataBind();
Session[clsConstant.SESS_TABLE] = dt;
if (!IsPostBack)
{
info.AddMergedColumns(new int[] { 6, 7, 8, 9 }, "<b>Target</b>");
info.AddMergedColumns(new int[] { 10, 11, 12, 13 }, "<b>Actual</b>");
}
}
protected void CalculateTotal()
{
disbursementDetailsObj = new DisbursementDetails();
if (IsValid)
{
target1 = txtQuarterTarget1.Text == "" ? 0 : decimal.Parse(txtQuarterTarget1.Text.Trim());
target2 = txtQuarterTarget2.Text == "" ? 0 : decimal.Parse(txtQuarterTarget2.Text.Trim());
target3 = txtQuarterTarget3.Text == "" ? 0 : decimal.Parse(txtQuarterTarget3.Text.Trim());
target4 = txtQuarterTarget4.Text == "" ? 0 : decimal.Parse(txtQuarterTarget4.Text.Trim());
actual1 = txtQuarterActual1.Text == "" ? 0 : decimal.Parse(txtQuarterActual1.Text.Trim());
actual2 = txtQuarterActual2.Text == "" ? 0 : decimal.Parse(txtQuarterActual2.Text.Trim());
actual3 = txtQuarterActual3.Text == "" ? 0 : decimal.Parse(txtQuarterActual3.Text.Trim());
actual4 = txtQuarterActual4.Text == "" ? 0 : decimal.Parse(txtQuarterActual4.Text.Trim());
totalTargetDisbursement = Convert.ToDecimal(txtTotalTargetDisbursement.Text = disbursementDetailsObj.TotalDisbursement(target1, target2, target3, target4).ToString());
totalActualDisbursement = Convert.ToDecimal(txtTotalActualDisbursement.Text = disbursementDetailsObj.TotalDisbursement(actual1, actual2, actual3, actual4).ToString());
}
}
public void ChangeDisbursementStatustocollectbyDisbursementDetail(DisbursementDetails dd)
{
Disbursement d = dbcontext.Disbursements.Where(x => x.Id == dd.DisbursementId).FirstOrDefault();
if (d.DisbursementStatus != Enums.DisbursementStatus.COLLECTED)
{
d.DisbursementStatus = Enums.DisbursementStatus.COLLECTED;
}
// update associated request status to completed
List <Request> requests = dbcontext.Requests.Where(x => x.DisbursementId == d.Id).ToList();
foreach (Request r in requests)
{
r.Status = Enums.Status.Completed;
dbcontext.Update(r);
ems.sendCompletedRequestToEmployeeEmail(r);
}
dbcontext.Update(d);
dbcontext.SaveChanges();
}
protected void GridViewBinding()
{
dt = new DataTable();
ds = new DataSet();
disbursementDetailsObj = new DisbursementDetails();
ds = disbursementDetailsObj.NewBindGridview();
dt = ds.Tables[0];
grdDisbursement.DataSource = dt;
grdDisbursement.DataBind();
Session[clsConstant.SESS_TABLE] = dt;
CallToPerformanceTrack(ds.Tables[1], "Disbursement Details");
if (!IsPostBack)
{
info.AddMergedColumns(new int[] { 6, 7 }, "<b>Jan-Mar</b>", Importance.calender);
info.AddMergedColumns(new int[] { 8, 9 }, "<b>Apr-Jun</b>", Importance.calender);
info.AddMergedColumns(new int[] { 10, 11 }, "<b>July-Sep</b>", Importance.calender);
info.AddMergedColumns(new int[] { 12, 13 }, "<b>Oct-Dec</b>", Importance.calender);
info.AddMergedColumns(new int[] { 14, 15 }, "<b>Total</b>", Importance.calender);
}
}
protected void AutoFill()
{
dataset = new DataSet();
disbursementDetailsObj = new DisbursementDetails();
yearID = 0;
loanID = 0;
yearID = int.Parse(drpYear.SelectedValue);
loanID = int.Parse(drpLoanNumber.SelectedValue);
dataset = disbursementDetailsObj.CheckExisting(loanID, yearID);
if (dataset == null || dataset.Tables[0].Rows.Count == 0)
{
txtQuarterTarget1.Text = string.Empty;
txtQuarterActual1.Text = string.Empty;
txtQuarterTarget2.Text = string.Empty;
txtQuarterActual2.Text = string.Empty;
txtQuarterTarget3.Text = string.Empty;
txtQuarterActual3.Text = string.Empty;
txtQuarterTarget4.Text = string.Empty;
txtQuarterActual4.Text = string.Empty;
txtTotalTargetDisbursement.Text = string.Empty;
txtTotalActualDisbursement.Text = string.Empty;
Session.Remove(clsConstant.SESS_DISBURSEMENT_ID);
btnSubmit.Visible = true;
btnUpdate.Visible = false;
lblPromptMessage.Text = string.Empty;
}
else
{
Session[clsConstant.SESS_DISBURSEMENT_ID] = dataset.Tables[0].Rows[0][0].ToString();
FillTextBoxes(dataset);
btnSubmit.Visible = false;
btnUpdate.Visible = true;
lblPromptMessage.Text = "Record Exist";
}
}
protected void btnUpdate_Click(object sender, EventArgs e)
{
try
{
disbursementDetailsObj = new DisbursementDetails();
ut = new Utility();
if (IsValid)
{
if (Request.QueryString[clsConstant.SESS_DISBURSEMENT_ID] != null && Request.QueryString[clsConstant.SESS_DISBURSEMENT_ID].ToString() != string.Empty)
{
disbursementID = Request.QueryString[clsConstant.SESS_DISBURSEMENT_ID].ToString();
}
else
{
disbursementID = Session[clsConstant.SESS_DISBURSEMENT_ID] as string;
}
CalculateTotal();
status = disbursementDetailsObj.EditDisbursement(Convert.ToInt32(disbursementID), int.Parse(drpLoanNumber.SelectedValue), Convert.ToInt32(drpYear.SelectedValue),
totalTargetDisbursement,
totalActualDisbursement, target1,
target2, target3,
target4, actual1,
actual2, actual3,
actual4, ((UserDetails)Session[clsConstant.TOKEN]).UserID);
if (status != 0)
{
ut.ResetFormControl(reSetDiv);
lblPromptMessage.Text = "Data Updated Sucessfully";
}
}
}
catch (Exception ex)
{
logger.Error(ex);
}
}
public async Task <IActionResult> UpdateDisbursementDetails([FromBody] List <DisbursementDetailAPIModel> ListofdisbursementdetailsAPIModel)
{
try
{
for (int i = 0; i < ListofdisbursementdetailsAPIModel.Count; i++)
{
DisbursementDetails disbursementdetails = disbursementapiservice.APImodelconvertoDisbursementDetailmodel(ListofdisbursementdetailsAPIModel[i]);
_context.Entry(disbursementdetails).State = EntityState.Modified;
//use first disbursementdetails to change disbursementdetailapproval
if (i == 0)
{
disbursementapiservice.ChangeDisbursementStatustocollectbyDisbursementDetail(disbursementdetails);
}
}
await _context.SaveChangesAsync();
return(NoContent());
}
catch (DbUpdateConcurrencyException)
{
return(NotFound());
}
}
protected void btnUpdate_Click(object sender, EventArgs e)
{
try
{
disbursementDetailsObj = new DisbursementDetails();
ut = new Utility();
if (IsValid)
{
if (Request.QueryString[clsConstant.SESS_DISBURSEMENT_ID] != null && Request.QueryString[clsConstant.SESS_DISBURSEMENT_ID].ToString() != string.Empty)
{
disbursementID = Request.QueryString[clsConstant.SESS_DISBURSEMENT_ID].ToString();
}
else
{
disbursementID = Session[clsConstant.SESS_DISBURSEMENT_ID] as string;
}
status = disbursementDetailsObj.EditDisbursementMonthWise(Convert.ToInt32(disbursementID), int.Parse(drpLoanNumber.SelectedValue), Convert.ToInt32(drpYear.SelectedValue),
txtQuarterTarget1.Text == string.Empty ? 0 : Convert.ToDecimal(txtQuarterTarget1.Text),
txtQuarterTarget2.Text == string.Empty ? 0 : Convert.ToDecimal(txtQuarterTarget2.Text),
txtQuarterTarget3.Text == string.Empty ? 0 : Convert.ToDecimal(txtQuarterTarget3.Text),
txtQuarterTarget4.Text == string.Empty ? 0 : Convert.ToDecimal(txtQuarterTarget4.Text),
txtTQuarter1Jan.Text == string.Empty ? 0 : Convert.ToDecimal(txtTQuarter1Jan.Text),
txtTQuarter1Feb.Text == string.Empty ? 0 : Convert.ToDecimal(txtTQuarter1Feb.Text),
txtTQuarter1Mar.Text == string.Empty ? 0 : Convert.ToDecimal(txtTQuarter1Mar.Text),
txtTQuarter2Apr.Text == string.Empty ? 0 : Convert.ToDecimal(txtTQuarter2Apr.Text),
txtTQuarter2May.Text == string.Empty ? 0 : Convert.ToDecimal(txtTQuarter2May.Text),
txtTQuarter2Jun.Text == string.Empty ? 0 : Convert.ToDecimal(txtTQuarter2Jun.Text),
txtTQuarter3Jul.Text == string.Empty ? 0 : Convert.ToDecimal(txtTQuarter3Jul.Text),
txtTQuarter3Aug.Text == string.Empty ? 0 : Convert.ToDecimal(txtTQuarter3Aug.Text),
txtTQuarter3Sep.Text == string.Empty ? 0 : Convert.ToDecimal(txtTQuarter3Sep.Text),
txtTQuarter4Oct.Text == string.Empty ? 0 : Convert.ToDecimal(txtTQuarter4Oct.Text),
txtTQuarter4Nov.Text == string.Empty ? 0 : Convert.ToDecimal(txtTQuarter4Nov.Text),
txtTQuarter4Dec.Text == string.Empty ? 0 : Convert.ToDecimal(txtTQuarter4Dec.Text),
txtAQuarter1Jan.Text == string.Empty ? 0 : Convert.ToDecimal(txtAQuarter1Jan.Text),
txtAQuarter1Feb.Text == string.Empty ? 0 : Convert.ToDecimal(txtAQuarter1Feb.Text),
txtAQuarter1Mar.Text == string.Empty ? 0 : Convert.ToDecimal(txtAQuarter1Mar.Text),
txtAQuarter2Apr.Text == string.Empty ? 0 : Convert.ToDecimal(txtAQuarter2Apr.Text),
txtAQuarter2May.Text == string.Empty ? 0 : Convert.ToDecimal(txtAQuarter2May.Text),
txtAQuarter2Jun.Text == string.Empty ? 0 : Convert.ToDecimal(txtAQuarter2Jun.Text),
txtAQuarter3Jul.Text == string.Empty ? 0 : Convert.ToDecimal(txtAQuarter3Jul.Text),
txtAQuarter3Aug.Text == string.Empty ? 0 : Convert.ToDecimal(txtAQuarter3Aug.Text),
txtAQuarter3Sep.Text == string.Empty ? 0 : Convert.ToDecimal(txtAQuarter3Sep.Text),
txtAQuarter4Oct.Text == string.Empty ? 0 : Convert.ToDecimal(txtAQuarter4Oct.Text),
txtAQuarter4Nov.Text == string.Empty ? 0 : Convert.ToDecimal(txtAQuarter4Nov.Text),
txtAQuarter4Dec.Text == string.Empty ? 0 : Convert.ToDecimal(txtAQuarter4Dec.Text),
((UserDetails)Session[clsConstant.TOKEN]).UserID);
if (status != 0)
{
ut.ResetFormControl(reSetDiv);
lblPromptMessage.Text = "Data Updated Sucessfully";
ResetLabel();
}
}
}
catch (Exception ex)
{
logger.Error(ex);
}
}
protected void AutoFill()
{
dataset = new DataSet();
disbursementDetailsObj = new DisbursementDetails();
yearID = 0;
loanID = 0;
yearID = int.Parse(drpYear.SelectedValue);
loanID = int.Parse(drpLoanNumber.SelectedValue);
dataset = disbursementDetailsObj.CheckExistingMonth(loanID, yearID);
if (dataset != null && dataset.Tables[0].Rows.Count == 0 && dataset.Tables[1].Rows.Count > 0)
{
drpLoanNumber.SelectedIndex = -1;
drpYear.SelectedIndex = -1;
disbursementID = dataset.Tables[1].Rows[0][0].ToString();
drpLoanNumber.ClearSelection();
if (drpLoanNumber.Items.FindByText(dataset.Tables[1].Rows[0][1].ToString()) != null)
{
drpLoanNumber.Items.FindByText(dataset.Tables[1].Rows[0][1].ToString()).Selected = true;
}
drpYear.ClearSelection();
if (drpYear.Items.FindByText(dataset.Tables[1].Rows[0][2].ToString()) != null)
{
drpYear.Items.FindByText(dataset.Tables[1].Rows[0][2].ToString()).Selected = true;
}
txtQuarterTarget1.Text = dataset.Tables[1].Rows[0]["iQ1Target"].ToString() == "0" ? string.Empty : dataset.Tables[1].Rows[0]["iQ1Target"].ToString();
txtQuarterTarget2.Text = dataset.Tables[1].Rows[0]["iQ2Target"].ToString() == "0" ? string.Empty : dataset.Tables[1].Rows[0]["iQ2Target"].ToString();
txtQuarterTarget3.Text = dataset.Tables[1].Rows[0]["iQ3Target"].ToString() == "0" ? string.Empty : dataset.Tables[1].Rows[0]["iQ3Target"].ToString();
txtQuarterTarget4.Text = dataset.Tables[1].Rows[0]["iQ4Target"].ToString() == "0" ? string.Empty : dataset.Tables[1].Rows[0]["iQ4Target"].ToString();
string decimalsepratorvalue = dataset.Tables[1].Rows[0]["iTotalTargetDisbursement"].ToString() == "0" ? string.Empty : dataset.Tables[1].Rows[0]["iTotalTargetDisbursement"].ToString();
if (!string.IsNullOrEmpty(decimalsepratorvalue))
{
lblTotalTargetDisbursement.Text = String.Format("{0:0.0}", Convert.ToInt32(decimalsepratorvalue));
}
else
{
lblTotalTargetDisbursement.Text = dataset.Tables[1].Rows[0]["iTotalTargetDisbursement"].ToString() == "0" ? string.Empty : dataset.Tables[1].Rows[0]["iTotalTargetDisbursement"].ToString();
}
txtAQuarter1Jan.Text = string.Empty;
txtAQuarter1Feb.Text = string.Empty;
txtAQuarter1Mar.Text = string.Empty;
txtAQuarter2Apr.Text = string.Empty;
txtAQuarter2May.Text = string.Empty;
txtAQuarter2Jun.Text = string.Empty;
txtAQuarter3Jul.Text = string.Empty;
txtAQuarter3Aug.Text = string.Empty;
txtAQuarter3Sep.Text = string.Empty;
txtAQuarter4Oct.Text = string.Empty;
txtAQuarter4Nov.Text = string.Empty;
txtAQuarter4Dec.Text = string.Empty;
lblAQuaterTotal1.Text = string.Empty;
lblAQuaterTotal2.Text = string.Empty;
lblAQuaterTotal3.Text = string.Empty;
lblAQuaterTotal4.Text = string.Empty;
//till here
Session.Remove(clsConstant.SESS_DISBURSEMENT_ID);
btnSubmit.Visible = true;
btnUpdate.Visible = false;
lblPromptMessage.Text = string.Empty;
}
else if (dataset != null && dataset.Tables[0].Rows.Count > 0 && dataset.Tables[1].Rows.Count > 0)
{
Session[clsConstant.SESS_DISBURSEMENT_ID] = dataset.Tables[0].Rows[0][0].ToString();
FillTextBoxes(dataset);
btnSubmit.Visible = false;
btnUpdate.Visible = true;
lblPromptMessage.Text = "Record Exist";
}
if (dataset == null || (dataset.Tables[0].Rows.Count == 0 && dataset.Tables[1].Rows.Count == 0))
{
txtTQuarter1Jan.Text = string.Empty;
txtTQuarter1Feb.Text = string.Empty;
txtTQuarter1Mar.Text = string.Empty;
txtTQuarter2Apr.Text = string.Empty;
txtTQuarter2May.Text = string.Empty;
txtTQuarter2Jun.Text = string.Empty;
txtTQuarter3Jul.Text = string.Empty;
txtTQuarter3Aug.Text = string.Empty;
txtTQuarter3Sep.Text = string.Empty;
txtTQuarter4Oct.Text = string.Empty;
txtTQuarter4Nov.Text = string.Empty;
txtTQuarter4Dec.Text = string.Empty;
lblTQuaterTotal1.Text = string.Empty;
lblTQuaterTotal2.Text = string.Empty;
lblTQuaterTotal3.Text = string.Empty;
lblTQuaterTotal4.Text = string.Empty;
txtQuarterTarget1.Text = string.Empty;
txtQuarterTarget2.Text = string.Empty;
txtQuarterTarget3.Text = string.Empty;
txtQuarterTarget4.Text = string.Empty;
lblTotalTargetDisbursement.Text = string.Empty;
txtAQuarter1Jan.Text = string.Empty;
txtAQuarter1Feb.Text = string.Empty;
txtAQuarter1Mar.Text = string.Empty;
txtAQuarter2Apr.Text = string.Empty;
txtAQuarter2May.Text = string.Empty;
txtAQuarter2Jun.Text = string.Empty;
txtAQuarter3Jul.Text = string.Empty;
txtAQuarter3Aug.Text = string.Empty;
txtAQuarter3Sep.Text = string.Empty;
txtAQuarter4Oct.Text = string.Empty;
txtAQuarter4Nov.Text = string.Empty;
txtAQuarter4Dec.Text = string.Empty;
lblAQuaterTotal1.Text = string.Empty;
lblAQuaterTotal2.Text = string.Empty;
lblAQuaterTotal3.Text = string.Empty;
lblAQuaterTotal4.Text = string.Empty;
Session.Remove(clsConstant.SESS_DISBURSEMENT_ID);
btnSubmit.Visible = true;
btnUpdate.Visible = false;
lblPromptMessage.Text = string.Empty;
}
else
{
}
}
public static DisbursementDetailAPIModel DisbursementdetailmodelConverttoAPImodel(DisbursementDetails dd)
{
DisbursementDetailAPIModel ddAPI = new DisbursementDetailAPIModel()
{
Id = dd.Id,
QtyNeeded = dd.QtyNeeded,
QtyReceived = dd.QtyReceived,
DisbursementId = dd.DisbursementId,
InventoryItemId = dd.InventoryItemId,
ItemDescription = dd.InventoryItem.Description,
};
return(ddAPI);
}
