protected void btnClientCreate_Click(object sender, EventArgs e) { // Gather data to create new client CLIENT c = new CLIENT(); c.cliName = txtClientName.Text; c.cliAddress = txtClientAddress.Text; c.cityID = Convert.ToInt32(ddlClientCity.SelectedValue); c.cliProvince = ddlClientProv.SelectedItem.Text; c.cliPCode = txtClientPCode.Text; c.cliPhone = txtClientPhone.Text; c.cliConFName = txtClientConFName.Text; c.cliConLName = txtClientConLName.Text; c.cliConPosition = txtClientConPosition.Text; db.CLIENTs.Add(c); try { db.SaveChanges(); // Repopulate drop down lists DropDownList ddlClientList = (DropDownList)Body.FindControl("ddlClientList"); DropDownHelper.PopulateClientList(ddlClientList); NotifyJS.DisplayNotification(this.Page, c.cliName + " successfully created.", "success"); ClearClientModal(); } catch (DataException ex) { NotifyJS.DisplayNotification(this.Page, ex.InnerException.InnerException.Message, "danger"); } }
protected void btnSaveClientChanges_Click(object sender, EventArgs e) { // Find button on body content tag LinkButton btnClientRemove = (LinkButton)Body.FindControl("btnClientRemove"); // Get id from button int id = Convert.ToInt32(btnClientRemove.Attributes["data-id"]); // Find client data CLIENT c = db.CLIENTs.Find(id); c.cliName = txtClientName.Text; c.cliAddress = txtClientAddress.Text; c.cityID = Convert.ToInt32(ddlClientCity.SelectedValue); c.cliProvince = ddlClientProv.SelectedItem.Text; c.cliPCode = txtClientPCode.Text; c.cliPhone = txtClientPhone.Text; c.cliConFName = txtClientConFName.Text; c.cliConLName = txtClientConLName.Text; c.cliConPosition = txtClientConPosition.Text; // Set state to modified db.Entry(c).State = System.Data.Entity.EntityState.Modified; try { db.SaveChanges(); // Repopulate drop down lists DropDownList ddlClientList = (DropDownList)Body.FindControl("ddlClientList"); DropDownHelper.PopulateClientList(ddlClientList); NotifyJS.DisplayNotification(this.Page, c.cliName + " successfully modified.", "success"); ClearClientModal(); ReverseClientMode(true); } catch (DataException ex) { NotifyJS.DisplayNotification(this.Page, ex.InnerException.InnerException.Message, "danger"); } }
protected void btnClientEdit_Click(object sender, EventArgs e) { // Show the modal for client edit ScriptManager.RegisterStartupScript(this, this.GetType(), "Pop", "$('#mdlCreateClient').modal('show');", true); // Get client ID from button int id = Convert.ToInt32(btnClientRemove.Attributes["data-id"]); // Get controls from master page TextBox txtClientName = (TextBox)Page.Master.FindControl("txtClientName"); TextBox txtClientAddress = (TextBox)Page.Master.FindControl("txtClientAddress"); DropDownList ddlClientCity = (DropDownList)Page.Master.FindControl("ddlClientCity"); DropDownList ddlClientProv = (DropDownList)Page.Master.FindControl("ddlClientProv"); TextBox txtClientPCode = (TextBox)Page.Master.FindControl("txtClientPCode"); TextBox txtClientPhone = (TextBox)Page.Master.FindControl("txtClientPhone"); TextBox txtClientConFName = (TextBox)Page.Master.FindControl("txtClientConFName"); TextBox txtClientConLName = (TextBox)Page.Master.FindControl("txtClientConLName"); TextBox txtClientConPosition = (TextBox)Page.Master.FindControl("txtClientConPosition"); //Populate text boxes with existing data CLIENT c = db.CLIENTs.Find(id); txtClientName.Text = c.cliName; txtClientAddress.Text = c.cliAddress; ddlClientCity.SelectedItem.Selected = false; ddlClientProv.SelectedItem.Selected = false; ddlClientCity.Items.FindByValue(c.cityID.ToString()).Selected = true; ddlClientProv.Items.FindByText(c.cliProvince.ToString()).Selected = true; txtClientPCode.Text = c.cliPCode; txtClientPhone.Text = c.cliPhone; txtClientConFName.Text = c.cliConFName; txtClientConLName.Text = c.cliConLName; txtClientConPosition.Text = c.cliConPosition; // Switch back to create mode ReverseClientMode(false); }
public void DeleteClientOrProject(IQueryable <PROJECT> project, string type, int id) { // Delete all projects and child records associated with passed paramater project foreach (var p in project) { var labourSummary = db.LABOUR_SUMMARY .Where(labID => labID.projectID == p.ID); foreach (var l in labourSummary) { int lsID = l.ID; LABOUR_SUMMARY ls = db.LABOUR_SUMMARY.Find(lsID); db.LABOUR_SUMMARY.Remove(ls); } var materialRequirement = db.MATERIAL_REQ .Where(matID => matID.projectID == p.ID); foreach (var m in materialRequirement) { int mID = m.ID; MATERIAL_REQ mr = db.MATERIAL_REQ.Find(mID); db.MATERIAL_REQ.Remove(mr); } var labourRequirement = db.LABOUR_REQUIREMENT .Where(lrID => lrID.projectID == p.ID); foreach (var l in labourRequirement) { int lID = l.ID; LABOUR_REQUIREMENT lr = db.LABOUR_REQUIREMENT.Find(lID); db.LABOUR_REQUIREMENT.Remove(lr); } var prodTeam = db.PROD_TEAM .Where(ptID => ptID.projectID == p.ID); foreach (var pts in prodTeam) { int pteamID = pts.ID; PROD_TEAM pt = db.PROD_TEAM.Find(pteamID); db.PROD_TEAM.Remove(pt); var teamMember = db.TEAM_MEMBER .Where(tmID => tmID.teamID == pts.ID); foreach (var ptm in teamMember) { int teamMemberID = ptm.Id; TEAM_MEMBER tm = db.TEAM_MEMBER.Find(teamMemberID); db.TEAM_MEMBER.Remove(tm); } } db.PROJECTs.Remove(p); } if (type == "Client") { try { //delete an existing record CLIENT c = db.CLIENTs.Find(id); db.CLIENTs.Remove(c); db.SaveChanges(); DropDownHelper.PopulateClientList(ddlClientList); deletedClient = c.cliName; deleteClientFlag = true; Response.Redirect("~/Main.aspx", false); } catch (DataException dx) { NotifyJS.DisplayNotification(this.Page, dx.InnerException.InnerException.Message, "danger"); } } else { try { db.SaveChanges(); Response.Redirect("~/Main.aspx", false); } catch (DataException dx) { NotifyJS.DisplayNotification(this.Page, dx.InnerException.InnerException.Message, "danger"); } } }