public static void EditDepartment(string deptcode, string deptname, string contactname, string phone, string fax, string headname, string collectionpoint, string repname, string contacttitle, string headtitle) { using (Model1 entities = new Model1()) { Department department = entities.Departments.Where(p => p.DeptCode == deptcode).First <Department>(); department.DeptName = deptname; department.ContactName = contactname; department.Phone = phone; department.Fax = fax; department.HeadName = headname; department.CollectionPoint = collectionpoint; department.RepName = repname; department.HeadTitle = headtitle; department.ContactTitle = contacttitle; entities.SaveChanges(); } }
protected void btn_Submit_Click(object sender, EventArgs e) { Model1 ctx = new Model1(); int count = ctx.Users.Count(); User[] users = new User[count]; users = ctx.Users.ToArray(); User u = ctx.Users.Where(x => x.Email == tbx_Email.Text).First(); encryption enc = new encryption(); string newpassword = enc.Encryption(tbx_Password.Text.ToString()); u.Password = newpassword; ctx.SaveChanges(); lbl_Status.Text = "Reset Successful!"; tbx_Password.Enabled = false; tbx_Confirm.Enabled = false; tbx_Email.Enabled = true; tbx_UserName.Enabled = true; tbx_Verification.Enabled = true; }
public static void AddNewSupplier(string suppcode, string suppname, string contacttitle, string contactname, string phone, string fax, string address, string postcode, string gst) { using (Model1 entities = new Model1()) { Supplier supplier = new Supplier() { SuppCode = suppcode, SuppName = suppname, ContactTitle = contacttitle, ContactName = contactname, Phone = phone, Fax = fax, Address = address, PostalCode = postcode, GSTNo = gst, }; entities.Suppliers.Add(supplier); entities.SaveChanges(); } }
public static void AddRequest(int RequestID, string DeptCode, string DeptName, int UserID, string UserName, DateTime Date, string ApprovalStatus, int ApprovalBy, string ABName, string Comment, string CollectionStatus, string CollectionPoint) { using (Model1 entities = new Model1()) { Request request = new Request { RequestID = RequestID, DeptCode = DeptCode, DeptName = DeptName, UserID = UserID, UserName = UserName, Date = Date, ApprovalStatus = ApprovalStatus, ApprovalBy = ApprovalBy, ABName = ABName, Comment = Comment, CollectionPoint = CollectionPoint, CollectionStatus = CollectionStatus, }; entities.Requests.Add(request); entities.SaveChanges(); } }
// public static void AddNewDepartment(string deptcode, string deptname, string contactname, string phone, string fax, string headname, string collectionpoint, string repname, string contacttitle, string headtitle) { using (Model1 entities = new Model1()) { Department department = new Department() { DeptCode = deptcode, DeptName = deptname, ContactName = contactname, Phone = phone, Fax = fax, HeadName = headname, CollectionPoint = collectionpoint, RepName = repname, ContactTitle = contacttitle, HeadTitle = headtitle, }; entities.Departments.Add(department); entities.SaveChanges(); } }