public static bool RegisterUser(Cts_User_Master userDetails) { using (DBContextDataContext db = new DBContextDataContext()) { try { var check = db.Cts_User_Masters.Where(x => x.um_userId == userDetails.um_userId).ToList(); if (check.Count == 0) { db.Cts_User_Masters.InsertOnSubmit(userDetails); db.SubmitChanges(); if (userDetails.um_id > 0) { return(true); } else { return(false); } } else { return(false); } } catch (Exception ex) { return(false); } } }
public static bool UpdateProfile(int UID, UserMaster update) { try { if (UID > 0) { using (DBContextDataContext db = new DBContextDataContext()) { List <UserMaster> profile = db.UserMasters.Where(x => x.UID == UID).ToList(); foreach (UserMaster row in profile) { row.FirstName = update.FirstName; row.LastName = update.LastName; row.Age = update.Age; row.Gender = update.Gender; row.DoB = update.DoB; row.ContactNumber = update.ContactNumber; row.AltContactNumber = update.AltContactNumber; row.EMail = update.EMail; } db.SubmitChanges(); return(true); } } else { return(false); } } catch (Exception ex) { return(false); } }
public static bool UpdateProfile(int umId, Cts_User_Master update) { try { if (umId > 0) { using (DBContextDataContext db = new DBContextDataContext()) { List <Cts_User_Master> profile = db.Cts_User_Masters.Where(x => x.um_id == umId).ToList(); foreach (Cts_User_Master row in profile) { row.um_firstName = update.um_firstName; row.um_lastName = update.um_lastName; row.um_contact = update.um_contact; row.um_PerAddress = update.um_PerAddress; row.um_CorAddress = update.um_CorAddress; row.um_emailId = update.um_emailId; } db.SubmitChanges(); return(true); } } else { return(false); } } catch (Exception ex) { return(false); } }
public static bool UpdateProfile(int UID, UserMaster update) { try { if (UID > 0) { using (DBContextDataContext db = new DBContextDataContext()) { List <UserMaster> profile = db.UserMasters.Where(x => x.UID == UID).ToList(); foreach (UserMaster row in profile) { row.LicenseNumber = update.LicenseNumber; row.AddressLine1 = update.AddressLine1; row.AddressLine2 = update.AddressLine2; row.City = update.City; row.State = update.State; row.ZipCode = update.ZipCode; row.SSN = update.SSN; } db.SubmitChanges(); return(true); } } else { return(false); } } catch (Exception ex) { return(false); } }
public static bool EditManager(int id, string add, string add1, string city, string state, long code) { try { using (DBContextDataContext db = new DBContextDataContext()) { List <Hanger> hanger = db.Hangers.Where(x => x.Hanger_ID == id).ToList(); foreach (Hanger hng in hanger) { hng.Manager_Address_Line_1 = add; hng.Manager_Address_Line_2 = add1; hng.City = city; hng.State = state; hng.Zip_Code = code; } db.SubmitChanges(); } return(true); } catch { return(false); } }
public int themThanhVien(eCauThu ct) { tblCauThu temp = db.tblCauThus.Where(x => x.MaCauThu == ct.MaCauThu).FirstOrDefault(); if (temp != null) { return(0); } tblCauThu newct = new tblCauThu(); newct.MaCauThu = ct.MaCauThu; newct.TenCauThu = ct.TenCauThu; newct.SoDienThoai = ct.SoDienThoai; newct.Email = ct.Email; newct.IdDoiBong = ct.MaDoiBong; db.tblCauThus.InsertOnSubmit(newct); db.SubmitChanges(); return(1); }
public static bool allotplanes(hangerallot rea) { if (rea.allotdetails != null) { using (DBContextDataContext db = new DBContextDataContext()) { db.hangerallots.InsertOnSubmit(rea); db.SubmitChanges(); return(true); } } else { return(false); } }
public static bool ApproveUsers(int UID, bool status) { using (DBContextDataContext db = new DBContextDataContext()) { try { var user = db.UserMasters.Where(x => x.UID == UID).FirstOrDefault(); user.IsActive = status; db.SubmitChanges(); return(true); } catch { return(false); } } }
public static bool UpdateStatusPackage(int cid, string location, string status, bool active) { using (DBContextDataContext db = new DBContextDataContext()) { try { var package = db.Cts_Packages.Where(x => x.pk_consignment_id == cid && x.pk_Package_Status != "Delivered").FirstOrDefault(); package.pk_Current_location = location; package.pk_Package_Status = status; package.pk_isActive = active; db.SubmitChanges(); return(true); } catch { return(false); } } }
public static bool ApproveUsers(int um_id, bool status, string empId, string name, long salary) { using (DBContextDataContext db = new DBContextDataContext()) { try { var user = db.Cts_User_Masters.Where(x => x.um_id == um_id).FirstOrDefault(); user.um_isActive = status; user.um_IsApprovedOn = DateTime.Now.Date; user.um_IsApprovedBy = name; user.um_Salary = salary; db.SubmitChanges(); return(true); } catch { return(false); } } }
public static bool ApprovePackage(int pk_id, bool status, int role, string empId, int cost, string location) { using (DBContextDataContext db = new DBContextDataContext()) { try { var user = db.Cts_Packages.Where(x => x.pk_consignment_id == pk_id).FirstOrDefault(); user.pk_isActive = status; user.pk_Employee_id = empId; user.pk_Accept_Date = DateTime.Now.Date; user.pk_cost = cost; user.pk_Current_location = location; db.SubmitChanges(); return(true); } catch { return(false); } } }
public static bool AddWarehouse(Cts_BranchMaster warehouse) { using (DBContextDataContext db = new DBContextDataContext()) { try { db.Cts_BranchMasters.InsertOnSubmit(warehouse); db.SubmitChanges(); if (warehouse.bm_branchCode > 0) { return(true); } else { return(false); } } catch { return(false); } } }
public static bool AddHangers(Hanger hanger) { try { using (DBContextDataContext db = new DBContextDataContext()) { db.Hangers.InsertOnSubmit(hanger); db.SubmitChanges(); if (hanger.Hanger_ID > 0) { return(true); } else { return(false); } } } catch { return(false); } }
public static bool AddPlane(Plane _plane) { try { using (DBContextDataContext db = new DBContextDataContext()) { db.Planes.InsertOnSubmit(_plane); db.SubmitChanges(); if (_plane.Plane_ID > 0) { return(true); } else { return(false); } } } catch { return(false); } }
public static bool RegisterPilot(UserMaster pilotDetails) { using (DBContextDataContext db = new DBContextDataContext()) { try { db.UserMasters.InsertOnSubmit(pilotDetails); db.SubmitChanges(); if (pilotDetails.UID > 0) { return(true); } else { return(false); } } catch (Exception ex) { return(false); } } }
public static bool AddPackage(Cts_Package _package) { try { using (DBContextDataContext db = new DBContextDataContext()) { db.Cts_Packages.InsertOnSubmit(_package); db.SubmitChanges(); if (_package.pk_consignment_id > 0) { return(true); } else { return(false); } } } catch (Exception Ex) { return(false); } }
public static bool EditPlane(int id, string fname, string lname, long mob, string email) { try { using (DBContextDataContext db = new DBContextDataContext()) { List <Plane> plane = db.Planes.Where(x => x.Plane_ID == id).ToList(); foreach (Plane plan in plane) { plan.Owner_first_Name = fname; plan.Owner_Last_name = lname; plan.Owner_Contact_number = mob; plan.Owner_Email = email; } db.SubmitChanges(); } return(true); } catch { return(false); } }