protected void LoadGrid()
{
try
{
_obj_Pms_Project = new SPMS_PROJECT();
_obj_Pms_Project.Mode = 1;
_obj_Pms_Project.PROJECT_ORG_ID = Convert.ToInt32(Session["ORG_ID"]);
DataTable dt = Pms_Bll.get_Project(_obj_Pms_Project);
if (dt.Rows.Count != 0)
{
Rg_Project.DataSource = dt;
Rg_Project.DataBind();
}
else
{
DataTable dt1 = new DataTable();
Rg_Project.DataSource = dt1;
Rg_Project.DataBind();
}
}
catch (Exception ex)
{
SMHR.BLL.Error_Log(Session["USER_ID"].ToString(), ex.TargetSite.ToString(), ex.Message.Replace("'", "''"), "frm_Project", ex.StackTrace, DateTime.Now);
Response.Redirect("~/Frm_ErrorPage.aspx");
}
}
/// <summary>
///IN THIS BASED ON Project_ID(COMMANDARGUMENT) ALL DATA WILL BE TAKEN TO DATATABLE THEN WE CAN BIND TO INDIVIDUAL FIELDS
/// </summary>
/// <param name="source"></param>
/// <param name="e"></param>
protected void lnk_edit_Command(object sender, CommandEventArgs e)
{
try
{
//LoadCombos();
clearControls();
btn_Save.Text = "Update";
rtxt_ProjectName.Enabled = false;
_obj_Pms_Project = new SPMS_PROJECT();
_obj_Pms_Project.Mode = 2;
_obj_Pms_Project.PROJECT_ID = Convert.ToInt32(Convert.ToString(e.CommandArgument));
DataTable DT = Pms_Bll.get_Project(_obj_Pms_Project);
if (DT.Rows.Count != 0)
{
lbl_ProjectId.Text = Convert.ToString(DT.Rows[0]["PROJECT_ID"]);
rtxt_ProjectName.Text = Convert.ToString(DT.Rows[0]["PROJECT_NAME"]);
rtxt_ProjectDescription.Text = Convert.ToString(DT.Rows[0]["PROJECT_DESCRIPTION"]);
//rcmb_BUI.SelectedIndex = rcmb_BUI.Items.FindItemIndexByValue(Convert.ToString(DT.Rows[0]["PROJECT_BUSINESSUNIT_ID"]));
if (Convert.ToInt32(Session["WRITEFACILITY"]) == 2)
{
btn_Save.Visible = false;
}
else
{
btn_Save.Visible = true;
}
//rcmb_BUI.Enabled = false;
Rm_PROJECT_PAGE.SelectedIndex = 1;
}
}
catch (Exception ex)
{
SMHR.BLL.Error_Log(Session["USER_ID"].ToString(), ex.TargetSite.ToString(), ex.Message.Replace("'", "''"), "frm_Project", ex.StackTrace, DateTime.Now);
Response.Redirect("~/Frm_ErrorPage.aspx");
}
}
/// <summary>
/// WHILE INSERTING THERE IS NO NEED TO ADD LAST MDF BY,LAST MDF DATE,BASED ON LABEL _PROJECTID IF IT IS NULL THEN PERFORM INSERTION
/// IF END DATE IS NULL THEN WE HAVE TO USE THIS AND IT IS TO BE DEFINED IN TRANSLAYER
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
protected void btn_Save_Click(object sender, EventArgs e)
{
try
{
if (lbl_ProjectId.Text == "")
{
_obj_Pms_Project = new SPMS_PROJECT();
_obj_Pms_Project.Mode = 5;
_obj_Pms_Project.PROJECT_NAME = Pms_Bll.ReplaceQuote(Convert.ToString(rtxt_ProjectName.Text));
//_obj_Pms_Project.BUID = Convert.ToInt32(rcmb_BUI.SelectedItem.Value);
_obj_Pms_Project.PROJECT_ORG_ID = Convert.ToInt32(Session["ORG_ID"]);
DataTable dt = Pms_Bll.get_Project(_obj_Pms_Project);
if (dt.Rows.Count != 0)
{
Pms_Bll.ShowMessage(this, "Project Name Already Exist");
return;
}
else
{
_obj_Pms_Project = new SPMS_PROJECT();
_obj_Pms_Project.PROJECT_NAME = Pms_Bll.ReplaceQuote(Convert.ToString(rtxt_ProjectName.Text));
_obj_Pms_Project.PROJECT_DESCRIPTION = Pms_Bll.ReplaceQuote(Convert.ToString(rtxt_ProjectDescription.Text));
//_obj_Pms_Project.BUID = Convert.ToInt32(rcmb_BUI.SelectedValue);
_obj_Pms_Project.PROJECT_ORG_ID = Convert.ToInt32(Session["ORG_ID"]);
_obj_Pms_Project.PROJECT_CREATEDBY = Convert.ToInt32(Session["USER_ID"]);
_obj_Pms_Project.PROJECT_CREATEDDATE = DateTime.Now;
_obj_Pms_Project.Mode = 3;
bool status = Pms_Bll.set_Project(_obj_Pms_Project);
if (status == true)
{
Pms_Bll.ShowMessage(this, "Record Inserted Successfully");
LoadGrid();
btn_Save.Visible = true;
Rm_PROJECT_PAGE.SelectedIndex = 0;
return;
}
}
}
else
{
_obj_Pms_Project = new SPMS_PROJECT();
_obj_Pms_Project.PROJECT_ID = Convert.ToInt32(lbl_ProjectId.Text);
_obj_Pms_Project.PROJECT_NAME = Pms_Bll.ReplaceQuote(Convert.ToString(rtxt_ProjectName.Text));
_obj_Pms_Project.PROJECT_DESCRIPTION = Pms_Bll.ReplaceQuote(Convert.ToString(rtxt_ProjectDescription.Text));
//_obj_Pms_Project.BUID = Convert.ToInt32(rcmb_BUI.SelectedValue);
_obj_Pms_Project.PROJECT_ORG_ID = Convert.ToInt32(Session["ORG_ID"]);
_obj_Pms_Project.PROJECT_LASTMDFBY = Convert.ToInt32(Session["USER_ID"]);
_obj_Pms_Project.PROJECT_LASTMDFDATE = DateTime.Now;
_obj_Pms_Project.Mode = 4;
bool status = Pms_Bll.set_Project(_obj_Pms_Project);
if (status == true)
{
Pms_Bll.ShowMessage(this, "Record Updated Successfully");
LoadGrid();
btn_Save.Visible = true;
Rm_PROJECT_PAGE.SelectedIndex = 0;
return;
}
}
}
catch (Exception ex)
{
SMHR.BLL.Error_Log(Session["USER_ID"].ToString(), ex.TargetSite.ToString(), ex.Message.Replace("'", "''"), "frm_Project", ex.StackTrace, DateTime.Now);
Response.Redirect("~/Frm_ErrorPage.aspx");
}
}
