public DataSet GetBaseBenefit(CLaimBenefitModel model)
{
DataSet ds = CspfDatabaseHelper.SelectInDataSetFromStoredProcedure(
AccessHelper.ConnectionString, 6000, "SP_GetMablagh_Original", "Table",
CspfDatabaseHelper.GetSqlParameter_BigInt("@Nationalcode", model.NationalCode),
CspfDatabaseHelper.GetSqlParameter_Int("@UnitCode", model.Unitcode),
CspfDatabaseHelper.GetSqlParameter_Int("@Year", model.Year),
CspfDatabaseHelper.GetSqlParameter_VarChar("@DEATH_DATE", model.Death_Date));
return(ds);
}
private void DoGharamtShow()
{
if (txtNationalCode.Text.Trim().Length > 0 && txtHadeseDate.Text.Trim().Length > 0)
{
// ClaimData data = new ClaimData();
CLaimBenefitModel model = new CLaimBenefitModel
{
NationalCode = Convert.ToInt64(txtNationalCode.Text),
Unitcode = SessionHelper.Dastgah.DastgahCode,
Year = Convert.ToInt32(txtHadeseDate.Text.Substring(0, 4)),
Death_Date = Convert.ToString(txtHadeseDate.Text)
};
DataSet ds = DataAccessFactory.CreateClaimData().GetBaseBenefit(model);
if (ds != null && ds.Tables.Count > 0 && ds.Tables[0].Rows.Count > 0)
{
int Reason = Convert.ToInt16(RdbChangeReason.SelectedItem.Value);
if (Reason == 1)
{
var P = Convert.ToInt32(ds.Tables[0].Rows[0]["MABLAGH"]);
lblShowMablagh.Text = P.ToString("C");
Session["FinalMablagh"] = Convert.ToInt32(ds.Tables[0].Rows[0]["MABLAGH"]);
}
else
{
int MSum = 0;
foreach (ListItem item in ListNaghsType.Items)
{
if (item.Selected)
{
MSum = Convert.ToInt32(item.Text.Substring(item.Text.IndexOf("%"), item.Text.IndexOf(")") - item.Text.IndexOf("%")).Replace(")", "").Replace("%", "")) + MSum;
}
}
if (MSum > 100)
{
MSum = 100;
}
var P1 = Convert.ToInt64(ds.Tables[0].Rows[0]["MABLAGH"]);
var p2 = (P1 * MSum) / 100;
Session["FinalMablagh"] = (int)p2;
lblShowMablagh.Text = ((int)(p2)).ToString("C");
//"#,##0"
}
lblKhataShow.Text = Convert.ToString(ds.Tables[0].Rows[0]["khata"]);
Session["OriginalMablagh"] = Convert.ToInt32(ds.Tables[0].Rows[0]["MABLAGH"]);
Session["Formid"] = Convert.ToInt32(ds.Tables[0].Rows[0]["FormId"]);
}
}
}
