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 Page_Load(object sender, EventArgs e)
{
if (!User.Identity.IsAuthenticated) { Response.Redirect("~/Default.aspx"); }
if (IsPostBack) return;
NBD_DatabaseEntities db = new NBD_DatabaseEntities();
foreach (PROJECT c in db.PROJECTs)
this.ddlProject.Items.Add(c.projName);
}
protected void Page_Load(object sender, EventArgs e)
{
if (!User.Identity.IsAuthenticated) { Response.Redirect("~/Default.aspx"); }
HtmlGenericControl body = (HtmlGenericControl)Master.FindControl("BodyTag");
body.Attributes.Add("class", "client-entry");
if (IsPostBack) return;
NBD_DatabaseEntities db = new NBD_DatabaseEntities();
foreach (CITY c in db.CITies)
this.ddlCity.Items.Add(c.city1);
}
protected void Page_Load(object sender, EventArgs e)
{
if (!User.Identity.IsAuthenticated){Response.Redirect("~/Default.aspx");}
if (IsPostBack) return;
NBD_DatabaseEntities db = new NBD_DatabaseEntities();
//Fill drop down lists
foreach (CLIENT c in db.CLIENTs)
this.ddlClientName.Items.Add(c.cliName);
foreach (WORKER d in db.WORKERs)
if (d.designerFName != null)
this.ddlDesignerFName.Items.Add(d.designerFName);
}
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);
}
