public int UpdateCentralFirstReleasedAmount(CentralStateShare centralStateShare)
{
return(DAL.DataAccess.Instance.ExecuteNonQuery(StoredProcedure.spUpdateCentralFirstReleased, System.Data.CommandType.StoredProcedure, new List <ICommanParameter>
{
new CommanParameter {
Name = DataBaseFields.APOFileId, Type = System.Data.DbType.Int32, value = centralStateShare.APOId
},
new CommanParameter {
Name = DataBaseFields.Quantity, Type = System.Data.DbType.Decimal, value = centralStateShare.Quantity
},
new CommanParameter {
Name = DataBaseFields.SanctionedAmount, Type = System.Data.DbType.Decimal, value = centralStateShare.CFYSanctionAmount
},
new CommanParameter {
Name = DataBaseFields.UnspentAdjustedAmount, Type = System.Data.DbType.Decimal, value = centralStateShare.UnspentAdjustedAmount
},
new CommanParameter {
Name = DataBaseFields.CentralShare, Type = System.Data.DbType.Decimal, value = centralStateShare.CentralShare
},
new CommanParameter {
Name = DataBaseFields.StateShare, Type = System.Data.DbType.Decimal, value = centralStateShare.StateShare
},
new CommanParameter {
Name = DataBaseFields.FirstCentralRelease, Type = System.Data.DbType.Decimal, value = centralStateShare.FirstCentralRelease
},
new CommanParameter {
Name = DataBaseFields.IFDDiaryNumber, Type = System.Data.DbType.String, value = centralStateShare.IFDDiaryNumber
},
new CommanParameter {
Name = DataBaseFields.IFDDate, Type = System.Data.DbType.DateTime, value = centralStateShare.IFDDate
},
}));
}
protected void btnSecondRelease_Click(object sender, EventArgs e)
{
try
{
if (Session["centralStateShare"] != null)
{
centralStateShare = (CentralStateShare)Session["centralStateShare"];
CentralStateShareBAL.Instance.UpdateStateSecondReleasedAmount(centralStateShare);
string strSuccess = "Second installment of state share has been released successfully.";
vmSuccess.Message = strSuccess;
FlashMessage.ErrorMessage(vmSuccess.Message);
Session["centralStateShare"] = null;
GetCentralStateShare();
IFDdiv.Style.Add("display", "none");
FistInstallmentDiv.Style.Add("display", "none");
SecondInstallmentDiv.Style.Add("display", "none");
UserBAL.Instance.InsertAuditTrailDetail("Released Second Installment of State Share", "Monitoring Central-State Share");
}
}
catch (Exception ex)
{
LogHandler.LogFatal((ex.InnerException != null ? ex.InnerException.Message : ex.Message), ex, this.GetType());
Response.RedirectPermanent("~/ErrorPage.aspx", false);
//string strError = ex.Message;
//vmError.Message = strError;
//FlashMessage.ErrorMessage(vmError.Message);
//return;
}
}
public int UpdateStateSecondReleasedAmount(CentralStateShare centralStateShare)
{
return(DAL.DataAccess.Instance.ExecuteNonQuery(StoredProcedure.spUpdateStateSecondReleased, System.Data.CommandType.StoredProcedure, new List <ICommanParameter>
{
new CommanParameter {
Name = DataBaseFields.APOFileId, Type = System.Data.DbType.Int32, value = centralStateShare.APOId
},
new CommanParameter {
Name = DataBaseFields.SecondStateRelease, Type = System.Data.DbType.Decimal, value = centralStateShare.SecondStateRelease
},
}));
}
protected void btnFirstRelease_Click(object sender, EventArgs e)
{
try
{
if (!IsFinalUCSubmitted(Convert.ToInt32(ddlApoTitle.SelectedValue)))
{
return;
}
if (Session["centralStateShare"] != null)
{
centralStateShare = (CentralStateShare)Session["centralStateShare"];
centralStateShare.IFDDiaryNumber = txtIfdDiaryNumber.Text;
if (!string.IsNullOrEmpty(txtIfdDate.Text))
{
centralStateShare.IFDDate = Convert.ToDateTime(txtIfdDate.Text);
}
else
{
centralStateShare.IFDDate = DateTime.Now;
}
CentralStateShareBAL.Instance.UpdateCentralFirstReleasedAmount(centralStateShare);
string strSuccess = "First installment of central share has been released successfully.";
vmSuccess.Message = strSuccess;
FlashMessage.ErrorMessage(vmSuccess.Message);
Session["centralStateShare"] = null;
GetCentralStateShare();
IFDdiv.Style.Add("display", "none");
FistInstallmentDiv.Style.Add("display", "none");
SecondInstallmentDiv.Style.Add("display", "block");
UserBAL.Instance.InsertAuditTrailDetail("Released First Installment of Central Share", "Monitoring Central-State Share");
}
}
catch (Exception ex)
{
string strError = ex.Message;
vmError.Message = strError;
FlashMessage.ErrorMessage(vmError.Message);
return;
}
}
protected void btnFirstRelease_Click(object sender, EventArgs e)
{
try
{
if (Session["centralStateShare"] != null)
{
centralStateShare = (CentralStateShare)Session["centralStateShare"];
centralStateShare.IFDDiaryNumber = txtIfdDiaryNumber.Text;
if (!string.IsNullOrEmpty(txtIfdDate.Text))
{
centralStateShare.IFDDate = Convert.ToDateTime(txtIfdDate.Text);
}
else
{
centralStateShare.IFDDate = DateTime.Now;
}
CentralStateShareBAL.Instance.UpdateStateFirstReleasedAmount(centralStateShare);
string strSuccess = "First installment of state share has been released successfully.";
vmSuccess.Message = strSuccess;
FlashMessage.ErrorMessage(vmSuccess.Message);
Session["centralStateShare"] = null;
GetCentralStateShare();
FistInstallmentDiv.Style.Add("display", "none");
SecondInstallmentDiv.Style.Add("display", "block");
UserBAL.Instance.InsertAuditTrailDetail("Released First Installment of State Share", "Monitoring Central-State Share");
}
}
catch (Exception ex)
{
LogHandler.LogFatal((ex.InnerException != null ? ex.InnerException.Message : ex.Message), ex, this.GetType());
Response.RedirectPermanent("~/ErrorPage.aspx", false);
//string strError = ex.Message;
//vmError.Message = strError;
//FlashMessage.ErrorMessage(vmError.Message);
//return;
}
}
