private void BindMedicalGrid()
{
try
{
int count = 0;
RadGrid1.Visible = true;
smhr_MedicalBenfit = new SMHR_MEDICALBENFIT();
smhr_MedicalBenfit.OPERATION = operation.Get;
smhr_MedicalBenfit.OrgID = Convert.ToInt32(Session["ORG_ID"]);
//smhr_MedicalBenfit.ExpendID = Convert.ToInt32(rad_ExpenditureName.SelectedValue);
smhr_MedicalBenfit.FinancialPeriodID = Convert.ToInt32(radFinPeriod.SelectedValue);
DataTable dt = BLL.get_MedicalBenfit(smhr_MedicalBenfit);
SMHR_PERIOD osmhr_period = new SMHR_PERIOD();
osmhr_period.ORGANISATION_ID = Convert.ToInt32(Session["ORG_ID"]);
osmhr_period.PERIOD_ID = Convert.ToInt32(radFinPeriod.SelectedValue);
DataTable dtCurrentFinPeriod = BLL.IscurrentFinPeriod(osmhr_period);
if (string.Compare(dtCurrentFinPeriod.Rows[0]["ISEXISTS"].ToString(), "0", true) == 0)
{
RadGrid1.Enabled = false;
RadGrid1.MasterTableView.Columns[3].Visible = false;
}
else
{
RadGrid1.Enabled = true;
RadGrid1.MasterTableView.Columns[3].Visible = true;
}
RadGrid1.DataSource = dt;
RadGrid1.DataBind();
for (int i = 0; i < dt.Rows.Count; i++)
{
if (Convert.ToBoolean(dt.Rows[i]["medical_added"]) == false)
{
RadGrid1.MasterTableView.Columns[3].Visible = false;
return;
}
}
}
catch (Exception ex)
{
SMHR.BLL.Error_Log(Session["USER_ID"].ToString(), ex.TargetSite.ToString(), ex.Message.Replace("'", "''"), "MedicalBenifits", ex.StackTrace, DateTime.Now);
Response.Redirect("~/Frm_ErrorPage.aspx");
}
}
public void LoadGrid()
{
try
{
smhr_MedicalBenfit = new SMHR_MEDICALBENFIT();
smhr_MedicalBenfit.OPERATION = operation.Select;
smhr_MedicalBenfit.OrgID = Convert.ToInt32(Session["ORG_ID"]);
DataTable DT = BLL.get_MedicalBenfit(smhr_MedicalBenfit);
Rg_MedicalBenifit.DataSource = DT;
clearControls();
}
catch (Exception ex)
{
SMHR.BLL.Error_Log(Session["USER_ID"].ToString(), ex.TargetSite.ToString(), ex.Message.Replace("'", "''"), "MedicalBenifits", ex.StackTrace, DateTime.Now);
Response.Redirect("~/Frm_ErrorPage.aspx");
}
}
protected void btn_Save_Click(object sender, EventArgs e)
{
try
{
if (radFinPeriod.SelectedIndex <= 0)
{
BLL.ShowMessage(this, "Please Select Financial Period");
return;
}
smhr_MedicalBenfit = new SMHR_MEDICALBENFIT();
smhr_MedicalBenfit.OrgID = Convert.ToInt32(Session["ORG_ID"]);
DataTable dtGadeWiseAMount = GetGadeWiseAMount();
smhr_MedicalBenfit.GradeWiseAmount = dtGadeWiseAMount;
smhr_MedicalBenfit.FinancialPeriodID = Convert.ToInt32(radFinPeriod.SelectedValue);
smhr_MedicalBenfit.MEDICALBENFIT_CREATEDBY = Convert.ToInt32(Session["USER_ID"]);
smhr_MedicalBenfit.MEDICALBENFIT_CREATEDDATE = DateTime.Now;
smhr_MedicalBenfit.MEDICALBENFIT_MDFBY = Convert.ToInt32(Session["USER_ID"]);
smhr_MedicalBenfit.MEDICALBENFIT_MDFDATE = DateTime.Now;
switch (((Button)sender).ID.ToUpper())
{
case "BTN_UPDATE":
//smhr_MedicalBenfit.ExpendID = Convert.ToInt32(lbl_ExpenditureID.Text);
smhr_MedicalBenfit.OPERATION = operation.Insert;
if (BLL.set_MedicalBenfit(smhr_MedicalBenfit))
{
BLL.ShowMessage(this, "Information Updated Successfully");
}
else
{
BLL.ShowMessage(this, "Information Not Updated");
}
break;
case "BTN_SAVE":
//smhr_MedicalBenfit.ExpendID = Convert.ToInt32(rad_ExpenditureName.SelectedValue);
smhr_MedicalBenfit.OPERATION = operation.Insert;
if (BLL.set_MedicalBenfit(smhr_MedicalBenfit))
{
BLL.ShowMessage(this, "Information Saved Successfully");
}
else
{
BLL.ShowMessage(this, "Information Not Saved");
}
break;
default:
break;
}
Rm_CY_page.SelectedIndex = 0;
LoadGrid();
Rg_MedicalBenifit.DataBind();
}
catch (Exception ex)
{
SMHR.BLL.Error_Log(Session["USER_ID"].ToString(), ex.TargetSite.ToString(), ex.Message.Replace("'", "''"), "MedicalBenifits", ex.StackTrace, DateTime.Now);
Response.Redirect("~/Frm_ErrorPage.aspx");
}
}
protected void lnk_Edit_Command(object sender, CommandEventArgs e)
{
try
{
int finPrdID = Convert.ToInt32(e.CommandArgument);
lbl_ExpenditureID.Text = finPrdID.ToString();
int count = 0;
clearControls();
BindFinancialPeriod();
BindExpenditureNames();
rad_ExpenditureName.Enabled = false;
RadGrid1.Visible = true;
smhr_MedicalBenfit = new SMHR_MEDICALBENFIT();
smhr_MedicalBenfit.OPERATION = operation.Get;
smhr_MedicalBenfit.OrgID = Convert.ToInt32(Session["ORG_ID"]);
//smhr_MedicalBenfit.ExpendID = lbl_ExpenditureID.Text;
smhr_MedicalBenfit.FinancialPeriodID = finPrdID;
DataTable dt = BLL.get_MedicalBenfit(smhr_MedicalBenfit);
RadGrid1.DataSource = dt;
RadGrid1.DataBind();
if (dt.Rows.Count > 0)
{
SMHR_EXPENDITURE _obj_Smhr_Expenditure = new SMHR_EXPENDITURE();
_obj_Smhr_Expenditure.OPERATION = operation.Select;
_obj_Smhr_Expenditure.ORGANISATION_ID = Convert.ToInt32(Session["ORG_ID"]);
/*rad_ExpenditureName.DataSource = BLL.get_Expenditure(_obj_Smhr_Expenditure);
* rad_ExpenditureName.DataValueField = "EXPENDITURE_ID";
* rad_ExpenditureName.DataTextField = "EXPENDITURE_NAME";
* rad_ExpenditureName.DataBind();
* rad_ExpenditureName.Items.Insert(0, new Telerik.Web.UI.RadComboBoxItem("Select", "-1"));
* rad_ExpenditureName.SelectedIndex = rad_ExpenditureName.FindItemIndexByValue(smhr_MedicalBenfit.ExpendID.ToString());*/
radFinPeriod.SelectedIndex = radFinPeriod.FindItemIndexByValue(dt.Rows[0]["MEDICALBENFIT_FIN_PERIOD_ID"].ToString());
}
SMHR_PERIOD osmhr_period = new SMHR_PERIOD();
osmhr_period.ORGANISATION_ID = Convert.ToInt32(Session["ORG_ID"]);
osmhr_period.PERIOD_ID = Convert.ToInt32(radFinPeriod.SelectedValue);
DataTable dtCurrentFinPeriod = BLL.IscurrentFinPeriod(osmhr_period);
if (string.Compare(dtCurrentFinPeriod.Rows[0]["ISEXISTS"].ToString(), "0", true) == 0)
{
RadGrid1.Enabled = false;
}
else
{
RadGrid1.Enabled = true;
}
// trExpend.Visible = false;
// rad_ExpenditureName.Text = Convert.ToString(dt.Rows[0]["EXPENDITURE_NAME"]);
// rad_ExpenditureName.Enabled = false;
// rtxt_ExpenditureDesc.Text = Convert.ToString(dt.Rows[0]["EXPENDITURE_DESC"]);
if (Convert.ToInt32(Session["WRITEFACILITY"]) == 2)
{
btn_Update.Visible = false;
}
else
{
btn_Update.Visible = true;
}
Rm_CY_page.SelectedIndex = 1;
for (int i = 0; i < dt.Rows.Count; i++)
{
if (Convert.ToBoolean(dt.Rows[i]["MEDICAL_ADDED"]) == false)
{
count++;
}
}
if (count > 0)
{
RadGrid1.MasterTableView.Columns[3].Visible = false;
}
else
{
RadGrid1.MasterTableView.Columns[3].Visible = true;
}
radFinPeriod.Enabled = false;
}
catch (Exception ex)
{
SMHR.BLL.Error_Log(Session["USER_ID"].ToString(), ex.TargetSite.ToString(), ex.Message.Replace("'", "''"), "MedicalBenifits", ex.StackTrace, DateTime.Now);
Response.Redirect("~/Frm_ErrorPage.aspx");
}
}
