Exemplo n.º 1
0
        protected void Button1_Click(object sender, EventArgs e)
        {
            //try
            //{
            DataRow r; r = dsEmp.EmployeeCRUD.NewRow();

            if (id == -1)
            {
                r             = dsEmp.EmployeeCRUD.NewRow();
                r["empFirst"] = this.txtFirst.Text;
                r["empLast"]  = this.txtLast.Text;
                r["posID"]    = this.ddlPosition.SelectedValue;
                dsEmp.EmployeeCRUD.Rows.Add(r);
            }
            else
            {
                dsEmp.EmployeeCRUD.FindByid(id).empFirst = txtFirst.Text;
                dsEmp.EmployeeCRUD.FindByid(id).empLast  = txtLast.Text;
                dsEmp.EmployeeCRUD.FindByid(id).posID    = Convert.ToInt32(ddlPosition.SelectedValue);
            }
            GRASSLYLIB.EmmasDataSetTableAdapters.EmployeeCRUDTableAdapter daEmp = new GRASSLYLIB.EmmasDataSetTableAdapters.EmployeeCRUDTableAdapter();
            daEmp.Update(dsEmp.EmployeeCRUD);
            dsEmp.AcceptChanges();
            dsEmp.EmployeeCRUD.Clear();
            daEmp.Fill(dsEmp.EmployeeCRUD);
            Response.Redirect("~/Employee.aspx");
        }
Exemplo n.º 2
0
        protected void btnDeleteEmp_Click(object sender, EventArgs e)
        {
            try
            {
                GRASSLYLIB.EmmasDataSet.EmployeeCRUDRow row = dsEmp.EmployeeCRUD.FindByid(id);

                row.Delete();
                GRASSLYLIB.EmmasDataSetTableAdapters.EmployeeCRUDTableAdapter daEmp = new GRASSLYLIB.EmmasDataSetTableAdapters.EmployeeCRUDTableAdapter();
                daEmp.Update(dsEmp.EmployeeCRUD);
                dsEmp.AcceptChanges();
                dsEmp.CustomerCRUD.Clear();
                daEmp.Fill(dsEmp.EmployeeCRUD);
                Response.Redirect("~/Employee.aspx");
            }
            catch (Exception ex)
            {
                lblEmp.ForeColor = System.Drawing.Color.Red;

                if (ex.Message.Contains("fk"))
                {
                    lblEmp.Text = "You can't delete this employee, they have other records.";
                }
                else
                {
                    lblEmp.Text = ex.Message;
                }
            }
        }
Exemplo n.º 3
0
 static EmployeeCreate()
 {
     GRASSLYLIB.EmmasDataSetTableAdapters.EmployeeCRUDTableAdapter daEmp = new GRASSLYLIB.EmmasDataSetTableAdapters.EmployeeCRUDTableAdapter();
     daEmp.Fill(dsEmp.EmployeeCRUD);
 }