protected void btnInsert_Click(object sender, EventArgs e)
{
try
{
//Inserting new client into databse
NBD_DatabaseEntities db = new NBD_DatabaseEntities();
CLIENT c = new CLIENT();
c.cliName = this.txtBusiness.Text;
c.cliAddress = this.txtAddress.Text;
c.cityID = this.ddlCity.SelectedIndex + 1;
c.cliProvince = this.ddlProv.SelectedValue;
c.cliPCode = this.txtPCode.Text;
c.cliPhone = this.txtPhone.Text;
c.cliConFName = this.txtClientFName.Text;
c.cliConLName = this.txtClientLName.Text;
c.cliConPosition = this.txtClientPos.Text;
db.CLIENTs.Add(c);
db.SaveChanges();
LblMessage.Text = "New Client Sucessfuly Added.";
}
catch
{
LblMessage.Text = "Error";
}
//Call click event for btnClear the clear the form
btnClear_Click(sender, e);
}
protected void btnInsert_Click(object sender, EventArgs e)
{
try
{
NBD_DatabaseEntities db = new NBD_DatabaseEntities();
PROJECT p = new PROJECT();
p.projSite = this.txtProjSite.Text;
p.projName = this.txtProjName.Text;
p.clientID = Convert.ToInt32(this.ddlClientName.SelectedValue);
p.designerID = 3;
p.projBidDate = Convert.ToDateTime(this.txtBidDate.Text);
db.PROJECTs.Add(p);
db.SaveChanges();
LblMessage.Text = "New Project Sucessfuly Added.";
}
catch
{
LblMessage.Text = "Error";
}
//Call click event for btnClear the clear the form
btnClear_Click(sender, e);
}
protected void btnInsert_Click(object sender, EventArgs e)
{
try
{
NBD_DatabaseEntities db = new NBD_DatabaseEntities();
LABOUR_REQUIREMENT lr = new LABOUR_REQUIREMENT();
PROD_TEAM pt = new PROD_TEAM();
lr.prodTeamID = (pt.projectID = this.ddlProject.SelectedIndex + 1);
lr.taskID = this.ddlTask.SelectedIndex + 1;
lr.lreqActHours = Convert.ToInt16(this.txtUserHours.Text);
db.LABOUR_REQUIREMENT.Add(lr);
db.SaveChanges();
LblMessage.Text = "Project Task Sucessfuly Updated.";
}
catch
{
LblMessage.Text = "Error";
}
//Call click event for btnClear the clear the form
btnClear_Click(sender, e);
}
