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