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