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"); } }