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