public void EditSetting(Setting s) { Setting set = context.Settings.FirstOrDefault(m => m.Key == s.Key); if (set != null) { set.Category = s.Category; set.Value = s.Value; set.Option = s.Option; set.Type = s.Type; context.SaveChanges(); } else { context.Settings.Add(s); context.SaveChanges(); } //else //{ // set = new Setting(); // set.Category = s.Category; // set.Key = s.Key; // set.Value = s.Value; // set.Option = s.Option; // set.Type = s.Type; // context.Settings.AddObject(set); //} }
public static void AddRole(Role role) { CTSContext entities = new CTSContext(); entities.Roles.Add(role); entities.SaveChanges(); }
public void RemoveRole(string roleName, string userName) { BLL.CTSContext entities = new CTSContext(); UserRole role = entities.UserRoles.Where(r => r.Role.Name == roleName && r.UserProfile.UserName == userName).SingleOrDefault(); if (role != null) { entities.UserRoles.Remove(role); entities.SaveChanges(); } }
public void AddUserToRole(int roleId, string userName) { BLL.CTSContext entities = new CTSContext(); UserProfile user = entities.UserProfiles.Where(p => p.UserName == userName).FirstOrDefault(); if (user != null) { UserRole role = new UserRole(); role.RoleID = roleId; role.UserProfileID = user.UserProfileID; entities.UserRoles.Add(role); entities.SaveChanges(); } }
/// <summary> /// Updates the specified inserted. /// </summary> /// <param name="inserted">The inserted.</param> /// <param name="updated">The updated.</param> /// <param name="deleted">The deleted.</param> public void Update(List <BLL.DispatchDetail> inserted, List <BLL.DispatchDetail> updated, List <BLL.DispatchDetail> deleted) { CTSContext db = new CTSContext(); BLL.Dispatch orginal = db.Dispatches.Where(p => p.DispatchID == this.DispatchID).SingleOrDefault(); if (orginal != null) { orginal.BidNumber = this.BidNumber; orginal.DispatchDate = this.DispatchDate; orginal.DriverName = this.DriverName; orginal.FDPID = this.FDPID; orginal.GIN = this.GIN; orginal.PeriodYear = this.PeriodYear; orginal.PeriodMonth = this.PeriodMonth; orginal.PlateNo_Prime = this.PlateNo_Prime; orginal.PlateNo_Trailer = this.PlateNo_Trailer; //orginal.ProgramID = this.ProgramID; orginal.RequisitionNo = this.RequisitionNo; orginal.Round = this.Round; //orginal.StackNumber = this.StackNumber; //orginal.StoreID = this.StoreID; orginal.TransporterID = this.TransporterID; orginal.UserProfileID = this.UserProfileID; //orginal.WarehouseID = this.WarehouseID; orginal.WeighBridgeTicketNumber = this.WeighBridgeTicketNumber; orginal.Remark = this.Remark; orginal.DispatchedByStoreMan = this.DispatchedByStoreMan; //orginal.ProjectNumber = this.ProjectNumber; //orginal.SINumber = this.SINumber; foreach (BLL.DispatchDetail update in updated) { BLL.DispatchDetail updatedCommodity = db.DispatchDetails.Where(p => p.DispatchDetailID == update.DispatchDetailID).SingleOrDefault(); if (updatedCommodity != null) { updatedCommodity.CommodityID = update.CommodityID; updatedCommodity.Description = update.Description; //updatedCommodity.DispatchedQuantityInUnit = update.DispatchedQuantityInUnit; //updatedCommodity.DispatchedQuantityInMT = update.DispatchedQuantityInMT; updatedCommodity.RequestedQunatityInUnit = update.RequestedQunatityInUnit; updatedCommodity.RequestedQuantityInMT = update.RequestedQuantityInMT; updatedCommodity.UnitID = update.UnitID; } } db.SaveChanges(); } }
public static void SendSMS(int fdpId, string text) { CTSContext db = new CTSContext(); var contacts = (from contact in db.Contacts where contact.FDPID == fdpId select contact).ToList(); foreach (Contact contact in contacts) { // INSERT SMS (InOutInd, MobileNumber, Text, RequestDate, SendAfterDate, Status, StatusDate, Attempts, EventTag) //VALUES ('O', @MobileNumber, @SMSMessage, @Today, @SendAfterDate, 'pending', @Today, 0, 'SEND_SMS') SMS sms = new DRMFSS.BLL.SMS(); sms.Attempts = 0; sms.EventTag = "SEND_SMS"; sms.InOutInd = "O"; sms.LastAttemptDate = null; sms.MobileNumber = contact.PhoneNo; sms.Text = text; sms.RequestDate = DateTime.Today; sms.SendAfterDate = DateTime.Today; sms.Status = "pending"; sms.StatusDate = DateTime.Today; db.SMS.Add(sms); //try //{ //} //catch (Exception e) //{ //} } db.SaveChanges(); }
public void Save() { _context.SaveChanges(); }
/// <summary> /// Updates the specified inserted. /// </summary> /// <param name="inserted">The inserted.</param> /// <param name="updated">The updated.</param> /// <param name="deleted">The deleted.</param> public void Update(List<BLL.ReceiveDetail> inserted, List<BLL.ReceiveDetail> updated, List<BLL.ReceiveDetail> deleted) { CTSContext db = new CTSContext(); BLL.Receive orginal = db.Receives.SingleOrDefault(p => p.ReceiveID == this.ReceiveID); if (orginal != null) { // CreatedDate = DateTime.Now, orginal.ReceiptDate = this.ReceiptDate; // orginal.ReceiveID = this.ReceiveID; orginal.DriverName = this.DriverName; orginal.GRN = this.GRN; orginal.PlateNo_Prime = this.PlateNo_Prime; orginal.PlateNo_Trailer = this.PlateNo_Trailer; //orginal.StackNumber = this.StackNumber; orginal.TransporterID = this.TransporterID; orginal.HubID = this.HubID; // orginal.SINumber = this.SINumber; //orginal.CommodityTypeID = this.CommodityTypeID; orginal.WayBillNo = this.WayBillNo; orginal.ResponsibleDonorID = this.ResponsibleDonorID; orginal.SourceDonorID = this.SourceDonorID; //orginal.ReceivedByStoreMan = this.ReceivedByStoreMan; //orginal.CommoditySourceID = this.CommoditySourceID; orginal.WeightBeforeUnloading = this.WeightBeforeUnloading; orginal.WeightAfterUnloading = this.WeightAfterUnloading; orginal.Remark = this.Remark; orginal.VesselName = this.VesselName; orginal.PortName = this.PortName; orginal.WeightBridgeTicketNumber = this.WeightBridgeTicketNumber; foreach (BLL.ReceiveDetail insert in inserted) { //TODO THIS should be in transaction //orginal.ReceiveDetails.Add(insert); } foreach (BLL.ReceiveDetail delete in deleted) { BLL.ReceiveDetail deletedCommodity = db.ReceiveDetails.SingleOrDefault(p => p.ReceiveDetailID == delete.ReceiveDetailID); if (deletedCommodity != null) { // db.ReceiveDetails.DeleteObject(deletedCommodity); } } foreach (BLL.ReceiveDetail update in updated) { BLL.ReceiveDetail updatedCommodity = db.ReceiveDetails.SingleOrDefault(p => p.ReceiveDetailID == update.ReceiveDetailID); if (updatedCommodity != null) { //updatedCommodity.CommodityID = update.CommodityID; updatedCommodity.Description = update.Description; //updatedCommodity.ReceiveDetailID = update.ReceiveDetailID; //updatedCommodity.SentQuantityInMT = update.SentQuantityInMT; //updatedCommodity.ReceivedQuantityInMT = updatedCommodity.ReceivedQuantityInMT; //updatedCommodity.SentQuantityInUnit = update.SentQuantityInUnit; //updatedCommodity.UnitID = update.UnitID; } } db.SaveChanges(); } }
/// <summary> /// Updates the specified inserted. /// </summary> /// <param name="inserted">The inserted.</param> /// <param name="updated">The updated.</param> /// <param name="deleted">The deleted.</param> public void Update(List <BLL.ReceiveDetail> inserted, List <BLL.ReceiveDetail> updated, List <BLL.ReceiveDetail> deleted) { CTSContext db = new CTSContext(); BLL.Receive orginal = db.Receives.SingleOrDefault(p => p.ReceiveID == this.ReceiveID); if (orginal != null) { // CreatedDate = DateTime.Now, orginal.ReceiptDate = this.ReceiptDate; // orginal.ReceiveID = this.ReceiveID; orginal.DriverName = this.DriverName; orginal.GRN = this.GRN; orginal.PlateNo_Prime = this.PlateNo_Prime; orginal.PlateNo_Trailer = this.PlateNo_Trailer; //orginal.StackNumber = this.StackNumber; orginal.TransporterID = this.TransporterID; orginal.HubID = this.HubID; // orginal.SINumber = this.SINumber; //orginal.CommodityTypeID = this.CommodityTypeID; orginal.WayBillNo = this.WayBillNo; orginal.ResponsibleDonorID = this.ResponsibleDonorID; orginal.SourceDonorID = this.SourceDonorID; //orginal.ReceivedByStoreMan = this.ReceivedByStoreMan; //orginal.CommoditySourceID = this.CommoditySourceID; orginal.WeightBeforeUnloading = this.WeightBeforeUnloading; orginal.WeightAfterUnloading = this.WeightAfterUnloading; orginal.Remark = this.Remark; orginal.VesselName = this.VesselName; orginal.PortName = this.PortName; orginal.WeightBridgeTicketNumber = this.WeightBridgeTicketNumber; foreach (BLL.ReceiveDetail insert in inserted) { //TODO THIS should be in transaction //orginal.ReceiveDetails.Add(insert); } foreach (BLL.ReceiveDetail delete in deleted) { BLL.ReceiveDetail deletedCommodity = db.ReceiveDetails.SingleOrDefault(p => p.ReceiveDetailID == delete.ReceiveDetailID); if (deletedCommodity != null) { // db.ReceiveDetails.DeleteObject(deletedCommodity); } } foreach (BLL.ReceiveDetail update in updated) { BLL.ReceiveDetail updatedCommodity = db.ReceiveDetails.SingleOrDefault(p => p.ReceiveDetailID == update.ReceiveDetailID); if (updatedCommodity != null) { //updatedCommodity.CommodityID = update.CommodityID; updatedCommodity.Description = update.Description; //updatedCommodity.ReceiveDetailID = update.ReceiveDetailID; //updatedCommodity.SentQuantityInMT = update.SentQuantityInMT; //updatedCommodity.ReceivedQuantityInMT = updatedCommodity.ReceivedQuantityInMT; //updatedCommodity.SentQuantityInUnit = update.SentQuantityInUnit; //updatedCommodity.UnitID = update.UnitID; } } db.SaveChanges(); } }
public override bool ChangePassword(string username, string oldPassword, string newPassword) { if (ValidateUser(username, oldPassword)) { var context = new CTSContext(); UserProfile user = context.UserProfiles.Where(p => p.UserName == username).SingleOrDefault(); if (user != null) { user.Password = MD5Hashing.MD5Hash(newPassword); context.SaveChanges(); return true; } } return false; }
/// <summary> /// Updates the specified inserted. /// </summary> /// <param name="inserted">The inserted.</param> /// <param name="updated">The updated.</param> /// <param name="deleted">The deleted.</param> public void Update(List<BLL.DispatchDetail> inserted, List<BLL.DispatchDetail> updated, List<BLL.DispatchDetail> deleted) { CTSContext db = new CTSContext(); BLL.Dispatch orginal = db.Dispatches.Where(p => p.DispatchID == this.DispatchID).SingleOrDefault(); if (orginal != null) { orginal.BidNumber = this.BidNumber; orginal.DispatchDate = this.DispatchDate; orginal.DriverName = this.DriverName; orginal.FDPID = this.FDPID; orginal.GIN = this.GIN; orginal.PeriodYear = this.PeriodYear; orginal.PeriodMonth = this.PeriodMonth; orginal.PlateNo_Prime = this.PlateNo_Prime; orginal.PlateNo_Trailer = this.PlateNo_Trailer; //orginal.ProgramID = this.ProgramID; orginal.RequisitionNo = this.RequisitionNo; orginal.Round = this.Round; //orginal.StackNumber = this.StackNumber; //orginal.StoreID = this.StoreID; orginal.TransporterID = this.TransporterID; orginal.UserProfileID = this.UserProfileID; //orginal.WarehouseID = this.WarehouseID; orginal.WeighBridgeTicketNumber = this.WeighBridgeTicketNumber; orginal.Remark = this.Remark; orginal.DispatchedByStoreMan = this.DispatchedByStoreMan; //orginal.ProjectNumber = this.ProjectNumber; //orginal.SINumber = this.SINumber; foreach (BLL.DispatchDetail update in updated) { BLL.DispatchDetail updatedCommodity = db.DispatchDetails.Where(p => p.DispatchDetailID == update.DispatchDetailID).SingleOrDefault(); if (updatedCommodity != null) { updatedCommodity.CommodityID = update.CommodityID; updatedCommodity.Description = update.Description; //updatedCommodity.DispatchedQuantityInUnit = update.DispatchedQuantityInUnit; //updatedCommodity.DispatchedQuantityInMT = update.DispatchedQuantityInMT; updatedCommodity.RequestedQunatityInUnit = update.RequestedQunatityInUnit; updatedCommodity.RequestedQuantityInMT = update.RequestedQuantityInMT; updatedCommodity.UnitID = update.UnitID; } } db.SaveChanges(); } }