internal int InsertProject(Inv_Project InvProject) { try { _context.Inv_Project.AddObject(InvProject); _context.SaveChanges(); return(1); } catch (Exception) { throw; } }
internal int UpdateProject(Inv_Project InvProject, int projectId) { try { Inv_Project InvPro = _context.Inv_Project.First(x => x.Project_Id == projectId); InvPro.Project_Name = InvProject.Project_Name; InvPro.Project_Code = InvProject.Project_Code; InvPro.Description = InvProject.Description; _context.SaveChanges(); return(1); } catch (Exception) { throw; } }
protected void btnSubmit_Click(object sender, EventArgs e) { try { Inv_Project InvProject = new Inv_Project(); InvProject.Project_Name = txtProjectName.Text; InvProject.Project_Code = txtProjectCode.Text; InvProject.Description = txtDescription.Text; if (btnSubmit.Text == "Submit") { int Projectcount = (from Prj in _context.Inv_Project where Prj.Project_Code == InvProject.Project_Code select Prj.Project_Id).Count(); InvProject.EditDate = DateTime.Now; InvProject.EditUser = ((SessionUser)Session["SessionUser"]).UserId; InvProject.OCode = ((SessionUser)Session["SessionUser"]).OCode; // InvProject.EditDate = DateTime.Now(); if (Projectcount == 0) { int result = projectBll.InsertProject(InvProject); if (result == 1) { //lblMessage.Text = "Data Saved Successfully"; // lblMessage.ForeColor = System.Drawing.Color.Green; ScriptManager.RegisterStartupScript(this.Page, Page.GetType(), "text", "func('Data Saved Successfully')", true); GetAllProject(); txtProjectName.Text = ""; txtProjectCode.Text = ""; txtDescription.Text = ""; txtProjectName.Focus(); } else { //lblMessage.Text = "Data Saving Failure"; //lblMessage.ForeColor = System.Drawing.Color.Red; ScriptManager.RegisterStartupScript(this.Page, Page.GetType(), "text", "func('Data Saving Failure')", true); } } else { // lblMessage.Text = "Data Already Exist"; //lblMessage.ForeColor = System.Drawing.Color.Red; ScriptManager.RegisterStartupScript(this.Page, Page.GetType(), "text", "func('Data Already Exist')", true); txtProjectCode.Text = ""; txtProjectCode.Focus(); btnSubmit.Text = "Submit"; } } else { int projectId = Convert.ToInt32(hdfProjectID.Value); int result = projectBll.UpdateProject(InvProject, projectId); if (result == 1) { // lblMessage.Text = "Data Updated Sucessfully"; //lblMessage.ForeColor = System.Drawing.Color.Green; ScriptManager.RegisterStartupScript(this.Page, Page.GetType(), "text", "func('Data Updated Sucessfully')", true); GetAllProject(); txtProjectName.Text = ""; txtProjectCode.Text = ""; txtDescription.Text = ""; txtProjectName.Focus(); btnSubmit.Text = "Submit"; } else { //lblMessage.Text = "Data Updating failure"; // lblMessage.ForeColor = System.Drawing.Color.Red; ScriptManager.RegisterStartupScript(this.Page, Page.GetType(), "text", "func('Data Updating failure')", true); } } } catch (Exception ex) { ScriptManager.RegisterStartupScript(this.Page, Page.GetType(), "text", "func('" + ex.Message + "')", true); } }
internal int UpdateProject(Inv_Project InvProject, int projectId) { return(aProjectDAL.UpdateProject(InvProject, projectId)); }