/// <summary>
        /// Update Employee Information
        /// </summary>
        /// <param name="Emp"></param>
        /// <returns></returns>
        public string Update_Employee(cust_reg Emp)
        {
            if (Emp != null)
            {
                using (DB09TMS170_1718Entities Obj = new DB09TMS170_1718Entities())
                {
                    var      Emp_   = Obj.Entry(Emp);
                    cust_reg EmpObj = Obj.cust_reg.Where(x => x.subid == Emp.subid).FirstOrDefault();
                    EmpObj.name        = Emp.name;
                    EmpObj.dob         = Emp.dob;
                    EmpObj.contact_num = Emp.contact_num;
                    EmpObj.stat        = Emp.stat;
                    EmpObj.city        = Emp.city;
                    EmpObj.addr1       = Emp.addr1;
                    EmpObj.addr2       = Emp.addr2;
                    EmpObj.pincode     = Emp.pincode;
                    //EmpObj.acc_id = Emp.acc_id;
                    //EmpObj.balance = Emp.balance;
                    //EmpObj.statu = Emp.statu;
                    //EmpObj.update_d = Emp.update_d;
                    //EmpObj.pwd = Emp.pwd;
                    //EmpObj.rol = Emp.rol;

                    Obj.SaveChanges();
                    return("Employee Updated Successfully");
                }
            }
            else
            {
                return("Employee Not Updated! Try Again");
            }
        }
 /// <summary>
 /// Insert New Employee
 /// </summary>
 /// <param name="Employe"></param>
 /// <returns></returns>
 public string Insert_Employee(cust_reg Employe)
 {
     if (Employe != null)
     {
         using (DB09TMS170_1718Entities Obj = new DB09TMS170_1718Entities())
         {
             Obj.cust_reg.Add(Employe);
             Obj.SaveChanges();
             return("Employee Added Successfully");
         }
     }
     else
     {
         return("Employee Not Inserted! Try Again");
     }
 }
 /// <summary>
 /// Delete Employee Information
 /// </summary>
 /// <param name="Emp"></param>
 /// <returns></returns>
 public string Delete_Employee(cust_reg Emp)
 {
     if (Emp != null)
     {
         using (DB09TMS170_1718Entities Obj = new DB09TMS170_1718Entities())
         {
             var Emp_ = Obj.Entry(Emp);
             if (Emp_.State == System.Data.Entity.EntityState.Detached)
             {
                 Obj.cust_reg.Attach(Emp);
                 Obj.cust_reg.Remove(Emp);
             }
             Obj.SaveChanges();
             return("Employee Deleted Successfully");
         }
     }
     else
     {
         return("Employee Not Deleted! Try Again");
     }
 }