public Enums.CrudStatus SetEmployeeRole(Gbl_Master_Employee_Role model, Enums.CrudType crudType) { try { myshop = new MyshopDb(); var oldEmpRole = myshop.Gbl_Master_Employee_Role.Where(emp => (emp.RoleId.Equals(model.RoleId) || emp.RoleType.Equals(model.RoleType)) && emp.IsDeleted == false && emp.ShopId.Equals(WebSession.ShopId)).FirstOrDefault(); if (oldEmpRole != null && oldEmpRole.RoleType.Equals(model.RoleType) && oldEmpRole.RoleId == 0) { return(Enums.CrudStatus.AlreadyExistForSameShop); } else if (crudType == Enums.CrudType.Insert) { Gbl_Master_Employee_Role newEmpRole = new Gbl_Master_Employee_Role(); newEmpRole.RoleType = model.RoleType; newEmpRole.Description = model.Description; newEmpRole.CreatedDate = DateTime.Now; newEmpRole.CreatedBy = WebSession.UserId; newEmpRole.IsDeleted = false; newEmpRole.IsSync = false; newEmpRole.ModifiedBy = WebSession.UserId; newEmpRole.ModificationDate = DateTime.Now; newEmpRole.ShopId = WebSession.ShopId; myshop.Entry(newEmpRole).State = EntityState.Added; } else if (oldEmpRole != null) { if (crudType == Enums.CrudType.Update) { oldEmpRole.RoleType = model.RoleType; oldEmpRole.Description = model.Description; } else if (crudType == Enums.CrudType.Delete) { var emp = myshop.Gbl_Master_Employee.Where(x => x.IsDeleted == false && x.RoleId.Equals(model.RoleId)).FirstOrDefault(); if (emp != null) { return(Enums.CrudStatus.AlreadyInUse); } oldEmpRole.IsDeleted = true; } oldEmpRole.IsSync = false; oldEmpRole.ModifiedBy = WebSession.UserId; oldEmpRole.ModificationDate = DateTime.Now; myshop.Entry(oldEmpRole).State = EntityState.Modified; } int result = myshop.SaveChanges(); return(Utility.CrudStatus(result, crudType)); } catch (Exception ex) { GlobalMethod.LogError("Masters", "Set Employee Role", "Employee Management", ex.Message, ex); return(Enums.CrudStatus.Exception); } finally { } }
public Enums.CrudStatus SetExpType(ExpTypeModel model, Enums.CrudType crudType) { try { myshop = new MyshopDb(); var oldexp = myshop.Gbl_Master_ExpenseType.Where(exp => (exp.Id.Equals(model.ExpTypeId) || (exp.ExpenseType.ToLower().Equals(model.ExpType) || exp.ExpenseType.ToLower().Contains(model.ExpType))) && exp.IsDeleted == false && exp.ShopId.Equals(WebSession.ShopId)).FirstOrDefault(); if (oldexp != null) { if (oldexp.ExpenseType.ToLower() == model.ExpType) { return(Enums.CrudStatus.AlreadyExistForSameShop); } var isUsed = myshop.Gbl_Master_ExpenseItem.Where(x => x.IsDeleted == false && x.ExpTypeId.Equals(model.ExpTypeId) && x.ShopId.Equals(WebSession.ShopId)).Count() > 0 ? true : false; if (isUsed) { return(Enums.CrudStatus.AlreadyInUse); } oldexp.IsSync = false; oldexp.ModifiedBy = WebSession.UserId; oldexp.ModifiedDate = DateTime.Now; if (crudType == Enums.CrudType.Update) { oldexp.ExpenseType = model.ExpType; oldexp.Description = model.ExpTypeDesc; } else if (crudType == Enums.CrudType.Delete) { oldexp.IsDeleted = true; } myshop.Entry(oldexp).State = EntityState.Modified; } else if (crudType == Enums.CrudType.Insert) { Gbl_Master_ExpenseType newexp = new Gbl_Master_ExpenseType(); newexp.ExpenseType = model.ExpType; newexp.CreatedBy = WebSession.UserId; newexp.CreatedDate = DateTime.Now; newexp.Description = model.ExpTypeDesc; newexp.IsDeleted = false; newexp.IsSync = false; newexp.ShopId = WebSession.ShopId; newexp.ModifiedBy = WebSession.UserId; newexp.ModifiedDate = DateTime.Now; myshop.Entry(newexp).State = EntityState.Added; } int result = myshop.SaveChanges(); return(Utility.CrudStatus(result, crudType)); } catch (Exception ex) { return(Enums.CrudStatus.Exception); } finally { } }
public Enums.CrudStatus SetShopMap(int userId, int shopId, Enums.CrudType crudType) { try { myshop = new MyshopDb(); var oldUser = myshop.User_ShopMapper.Where(user => user.ShopId.Equals(shopId) && user.UserId.Equals(userId) && user.IsDeleted == false).FirstOrDefault(); int result = 0; if (crudType == Enums.CrudType.Insert) { if (oldUser != null) { return(Enums.CrudStatus.AlreadyExist); } else { User_ShopMapper map = new User_ShopMapper(); map.UserId = userId; map.ShopId = shopId; map.ModifiedBy = WebSession.UserId; map.ModificationDate = DateTime.Now; map.IsSync = false; map.IsDeleted = false; map.CreatedDate = DateTime.Now; map.CreatedBy = WebSession.UserId; myshop.User_ShopMapper.Add(map); result = myshop.SaveChanges(); return(Utility.CrudStatus(result, crudType)); } } else if (crudType == Enums.CrudType.Delete) { if (oldUser != null) { oldUser.IsSync = false; oldUser.IsDeleted = true; oldUser.ModificationDate = DateTime.Now; oldUser.ModifiedBy = WebSession.UserId; myshop.Entry(oldUser).State = EntityState.Modified; result = myshop.SaveChanges(); return(Utility.CrudStatus(result, crudType)); } else { return(Enums.CrudStatus.NotExist); } } else { return(Enums.CrudStatus.NoEffect); } } catch (Exception ex) { return(Enums.CrudStatus.Exception); } finally { } }
public Enums.CrudStatus AddDowntime(DowntimeModel model, Enums.CrudType crudType) { MyshopDb db = null; if (crudType == Enums.CrudType.Insert) { Gbl_AppDowntime newDown = new Gbl_AppDowntime(); newDown.CreatedBy = WebSession.UserId; newDown.ModifiedBy = WebSession.UserId; newDown.CreatedDate = DateTime.Now; newDown.ModifiedDate = DateTime.Now; newDown.IsDeleted = false; newDown.IsSync = false; newDown.Message = model.Message; newDown.DownTimeEnd = model.DownTimeEndDate; newDown.DownTimeStart = model.DownTimeStartDate; db = new MyshopDb(); db.Gbl_AppDowntime.Add(newDown); int result = db.SaveChanges();// DbRepo.InsertRecord<Gbl_AppDowntime>(model); return(Utility.CrudStatus(result, crudType)); } else if (crudType == Enums.CrudType.Update) { db = new MyshopDb(); int result = 0; int id = Convert.ToInt32(model.Id); var oldDown = db.Gbl_AppDowntime.Where(x => x.Id.Equals(id) && x.IsDeleted == false).FirstOrDefault(); if (oldDown != null) { oldDown.ModifiedBy = WebSession.UserId; oldDown.ModifiedDate = DateTime.Now; oldDown.IsSync = false; oldDown.Message = model.Message; oldDown.DownTimeEnd = model.DownTimeEndDate; oldDown.DownTimeStart = model.DownTimeStartDate; db.Entry(oldDown).State = EntityState.Modified; result = db.SaveChanges(); } return(Utility.CrudStatus(result, crudType)); } else { db = new MyshopDb(); int result = 0; int id = Convert.ToInt32(model.Id); var oldDown = db.Gbl_AppDowntime.Where(x => x.Id.Equals(id) && x.IsDeleted == false).FirstOrDefault(); if (oldDown != null) { oldDown.ModifiedBy = WebSession.UserId; oldDown.ModifiedDate = DateTime.Now; oldDown.IsSync = false; oldDown.IsDeleted = false; db.Entry(oldDown).State = EntityState.Modified; result = db.SaveChanges(); } return(Utility.CrudStatus(result, crudType)); } }
public Enums.CrudStatus TaskCreate(Enums.CrudType _type, Gbl_Master_Task _model) { try { myshop = new MyshopDb(); int _result = 0; if (_type == Enums.CrudType.Insert) { Gbl_Master_Task _newTask = new Gbl_Master_Task(); _newTask.CreatedBy = WebSession.UserId; _newTask.AssignedUserId = _model.AssignedUserId; _newTask.CreatedDate = DateTime.Now; _newTask.IsCompleted = false; _newTask.IsDeleted = false; _newTask.CompletedDate = null; _newTask.ModifiedDate = DateTime.Now; _newTask.IsImportant = _model.IsImportant; _newTask.IsSync = false; _newTask.Priority = _model.Priority; _newTask.ShopId = WebSession.ShopId; _newTask.TaskDetails = _model.TaskDetails; myshop.Entry(_newTask).State = EntityState.Added; _result = myshop.SaveChanges(); } else { var _oldTask = myshop.Gbl_Master_Task.Where(x => x.TaskId.Equals(_model.TaskId) && !x.IsDeleted && !x.IsCompleted && x.ShopId.Equals(WebSession.ShopId)).FirstOrDefault(); if (_type == Enums.CrudType.Update) { _oldTask.TaskDetails = _model.TaskDetails; _oldTask.IsSync = false; _oldTask.AssignedUserId = _model.AssignedUserId; _oldTask.IsCompleted = false; _oldTask.CompletedDate = null; _oldTask.IsImportant = _model.IsImportant; _oldTask.ModifiedBy = WebSession.UserId; _oldTask.ModifiedDate = DateTime.Now; _oldTask.Priority = _model.Priority; } else if (_type == Enums.CrudType.Delete) { _oldTask.IsSync = false; _oldTask.IsDeleted = false; _oldTask.ModifiedBy = WebSession.UserId; _oldTask.ModifiedDate = DateTime.Now; } myshop.Entry(_oldTask).State = EntityState.Modified; _result = myshop.SaveChanges(); } return(Utility.CrudStatus(_result, _type)); } catch (Exception ex) { return(Enums.CrudStatus.Exception); } }
public Tuple <Enums.CrudStatus, int> SetExpense(ExpenseModel model, Enums.CrudType crudType) { try { myshop = new MyshopDb(); int result = 0; Exp_Tr_New newexp = new Exp_Tr_New { BalanceAmount = model.ExpTr.BalanceAmount, CreatedBy = WebSession.UserId, CreatedDate = DateTime.Now, PaidAmount = model.ExpTr.PaidAmount, IsDeleted = false, IsSync = false, ShopId = WebSession.ShopId, PayModeId = model.ExpTr.PayModeId, PayModeRefNo = model.ExpTr.PayModeRefNo, TotalAmout = model.ExpTr.TotalAmout, VendorId = model.ExpTr.VendorId }; myshop.Entry(newexp).State = EntityState.Added; result = myshop.SaveChanges(); if (result > 0) { foreach (var dtl in model.ExpDtl) { Exp_Dtl_New newExpDtl = new Exp_Dtl_New { CreatedBy = WebSession.UserId, CreatedDate = DateTime.Now, ExpItemId = dtl.ExpItemId, ExpTrId = newexp.ExpId, IsDeleted = false, IsSync = false, Qty = dtl.Qty, ShopId = WebSession.ShopId }; myshop.Exp_Dtl_New.Add(newExpDtl); } } result = myshop.SaveChanges(); return(new Tuple <Enums.CrudStatus, int>(Utility.CrudStatus(result, crudType), newexp.ExpId)); } catch (Exception ex) { return(new Tuple <Enums.CrudStatus, int>(Enums.CrudStatus.Exception, 0)); } finally { } }
public Enums.CrudStatus SetProduct(ProductModel model, Enums.CrudType crudType) { try { myshop = new MyshopDb(); var oldPro = myshop.Gbl_Master_Product.Where(pro => (pro.ProductId.Equals(model.ProductId) || (pro.ProductName.ToLower().Equals(model.ProductName.Trim().ToLower()) || pro.ProductName.ToLower().Contains(model.ProductName.Trim().ToLower()))) && pro.IsDeleted == false && pro.SubCatId.Equals(model.SubCatId)).FirstOrDefault(); if (oldPro != null && oldPro.ShopId.Equals(WebSession.ShopId)) { if (crudType == Enums.CrudType.Update) { oldPro.MinQuantity = model.MinQuantity; oldPro.ProductName = model.ProductName; oldPro.UnitId = model.UnitId; oldPro.Description = model.Desc; oldPro.IsDeleted = false; oldPro.IsSync = false; oldPro.ModifiedBy = WebSession.UserId; oldPro.ModificationDate = DateTime.Now; myshop.Entry(oldPro).State = EntityState.Modified; } else if (crudType == Enums.CrudType.Delete) { var pro = myshop.Stk_Dtl_Entry.Where(x => x.IsDeleted == false && x.ProductId.Equals(model.ProductId) && x.ShopId.Equals(WebSession.ShopId)).FirstOrDefault(); if (pro == null) { oldPro.IsDeleted = true; oldPro.IsSync = false; oldPro.ModifiedBy = WebSession.UserId; oldPro.ModificationDate = DateTime.Now; myshop.Entry(oldPro).State = EntityState.Modified; } else { return(Enums.CrudStatus.AlreadyInUse); } } else { return(Enums.CrudStatus.AlreadyExistForSameShop); } } else if (crudType == Enums.CrudType.Insert) { Gbl_Master_Product newPro = new Gbl_Master_Product(); newPro.MinQuantity = model.MinQuantity; newPro.ProductCode = model.ProductCode; newPro.ProductName = model.ProductName; newPro.UnitId = model.UnitId; newPro.SubCatId = model.SubCatId; newPro.CreatedBy = WebSession.UserId; newPro.CreatedDate = DateTime.Now; newPro.Description = model.Desc; newPro.IsDeleted = false; newPro.IsSync = false; newPro.ModifiedBy = WebSession.UserId; newPro.ShopId = WebSession.ShopId; newPro.ModificationDate = DateTime.Now; myshop.Entry(newPro).State = EntityState.Added; } int result = myshop.SaveChanges(); return(Utility.CrudStatus(result, crudType)); } catch (Exception ex) { return(Enums.CrudStatus.Exception); } finally { } }
public Enums.CrudStatus SetStock(StockEntryModel model, List <Stk_Dtl_Entry> productList, Enums.CrudType crudType) { try { myshop = new MyshopDb(); Stk_Tr_Entry newStock = new Stk_Tr_Entry(); int result = 0; if (crudType == Enums.CrudType.Insert) { newStock.AdditionalAmt = model.AdditionalAmt; newStock.ChequePageId = model.ChequePageId; newStock.DebitAccount = model.DebitAccountId; newStock.PaidAmt = model.PaidAmt; newStock.PayModeId = model.PayModeId; newStock.ReceiptDate = model.VendorReceiptDate; newStock.RemainingAmt = model.RemainingAmt; newStock.TotalAmt = model.TotalAmt; newStock.ShopReceiptEntryNo = model.ShopReceiptEntryNo; newStock.VendorId = model.VendorId; newStock.VendorReceiptNo = model.VendorReceiptNo; newStock.CreatedBy = WebSession.UserId; newStock.CreatedDate = DateTime.Now; newStock.IsDeleted = false; newStock.IsSync = false; newStock.ModifiedBy = WebSession.UserId; newStock.ShopId = WebSession.ShopId; newStock.ModificationDate = DateTime.Now; myshop.Entry(newStock).State = EntityState.Added; result = myshop.SaveChanges(); if (result > 0) { foreach (Stk_Dtl_Entry item in productList) { item.StockMstId = newStock.Id; item.ModificationDate = DateTime.Now; item.CreatedDate = DateTime.Now; item.CreatedBy = WebSession.UserId; item.ModifiedBy = WebSession.UserId; item.IsDeleted = false; item.IsSync = false; item.ShopId = WebSession.ShopId; myshop.Entry(item).State = EntityState.Added; } result = myshop.SaveChanges(); } } else { var oldStock = myshop.Stk_Tr_Entry.Where(x => x.Id.Equals(model.StockId) && x.IsDeleted == false).FirstOrDefault(); if (oldStock != null) { if (crudType == Enums.CrudType.Update) { oldStock.ChequePageId = model.ChequePageId; oldStock.DebitAccount = model.DebitAccountId; oldStock.PaidAmt = model.PaidAmt; oldStock.AdditionalAmt = model.AdditionalAmt; oldStock.RemainingAmt = model.RemainingAmt; oldStock.TotalAmt = model.TotalAmt; oldStock.PayModeId = model.PayModeId; oldStock.ReceiptDate = model.VendorReceiptDate; oldStock.ShopReceiptEntryNo = model.ShopReceiptEntryNo; oldStock.VendorId = model.VendorId; oldStock.VendorReceiptNo = model.VendorReceiptNo; oldStock.IsSync = false; oldStock.ModifiedBy = WebSession.UserId; oldStock.ModificationDate = DateTime.Now; myshop.Entry(oldStock).State = EntityState.Modified; var oldTrStock = myshop.Stk_Dtl_Entry.Where(x => x.StockMstId.Equals(model.StockId) && x.IsDeleted == false).ToList(); if (oldTrStock != null) { foreach (Stk_Dtl_Entry item in productList) { var oldItem = oldTrStock.Where(xy => xy.StockTrId.Equals(item.StockTrId)).FirstOrDefault(); if (oldItem != null) { oldItem.ModificationDate = DateTime.Now; oldItem.ModifiedBy = WebSession.UserId; oldItem.IsDeleted = false; oldItem.IsSync = false; oldItem.SellPrice = item.SellPrice; oldItem.PurchasePrice = item.PurchasePrice; oldItem.Qty = item.Qty; oldItem.Description = item.Description; oldItem.Color = item.Color; myshop.Entry(oldItem).State = EntityState.Modified; } else { item.StockMstId = newStock.Id; item.ModificationDate = DateTime.Now; item.CreatedDate = DateTime.Now; item.CreatedBy = WebSession.UserId; item.ModifiedBy = WebSession.UserId; item.IsDeleted = false; item.IsSync = false; item.ShopId = WebSession.ShopId; myshop.Entry(item).State = EntityState.Added; } } } } else if (crudType == Enums.CrudType.Delete) { oldStock.IsDeleted = true; oldStock.IsSync = false; oldStock.ModifiedBy = WebSession.UserId; oldStock.ModificationDate = DateTime.Now; myshop.Entry(oldStock).State = EntityState.Modified; } result = myshop.SaveChanges(); } } if (result > 0 && model.ChequePageId > 0) { var ChequePage = myshop.Gbl_Master_BankChequeDetails.Where(x => x.ChequePageId.Equals(model.ChequePageId) && x.IsDeleted == false).First(); if (ChequePage != null) { ChequePage.IsSync = false; ChequePage.IsUsed = true; ChequePage.Desciption = Resource.ChequeIssue; ChequePage.ModificationDate = DateTime.Now; ChequePage.ModifiedBy = WebSession.UserId; myshop.Entry(ChequePage).State = EntityState.Modified; myshop.SaveChanges(); } } return(Utility.CrudStatus(result, crudType)); } catch (Exception ex) { return(Enums.CrudStatus.Exception); } finally { } }
public Enums.CrudStatus SetExpItem(ExpItemModel model, Enums.CrudType crudType) { try { myshop = new MyshopDb(); var oldexp = myshop.Gbl_Master_ExpenseItem.Where(exp => exp.Id.Equals(model.ExpItemId) && !exp.IsDeleted && exp.ShopId.Equals(WebSession.ShopId)).FirstOrDefault(); if (oldexp != null) { if (oldexp.Name.ToLower() == model.ExpItem) { return(Enums.CrudStatus.AlreadyExistForSameShop); } var isUsed = myshop.Exp_Dtl_New.Where(x => !x.IsDeleted && x.ShopId.Equals(WebSession.ShopId) && x.ExpItemId.Equals(model.ExpItemId)).Count() > 0 ? true : false; if (!isUsed) { oldexp.IsSync = false; oldexp.ModifiedBy = WebSession.UserId; oldexp.ModifiedDate = DateTime.Now; if (crudType == Enums.CrudType.Update) { oldexp.Name = model.ExpItem; oldexp.Description = model.ExpItemDesc; oldexp.ExpTypeId = model.ExpTypeId; oldexp.Price = model.ExpItemPrice; oldexp.UnitId = model.UnitId; } else if (crudType == Enums.CrudType.Delete) { oldexp.IsDeleted = true; } myshop.Entry(oldexp).State = EntityState.Modified; } else { return(Enums.CrudStatus.AlreadyInUse); } } else if (crudType == Enums.CrudType.Insert) { Gbl_Master_ExpenseItem newexp = new Gbl_Master_ExpenseItem { Name = model.ExpItem, ExpTypeId = model.ExpTypeId, CreatedBy = WebSession.UserId, CreatedDate = DateTime.Now, Description = model.ExpItemDesc, IsDeleted = false, IsSync = false, ShopId = WebSession.ShopId, Price = model.ExpItemPrice, UnitId = model.UnitId }; myshop.Entry(newexp).State = EntityState.Added; } int result = myshop.SaveChanges(); return(Utility.CrudStatus(result, crudType)); } catch (Exception ex) { return(Enums.CrudStatus.Exception); } finally { } }
public Enums.CrudStatus SetCustomer(CustomerModel model, Enums.CrudType crudType) { try { myshop = new MyshopDb(); var oldCustomer = myshop.Gbl_Master_Customer.Where(cust => (cust.CustomerId.Equals(model.CutomerId) || (cust.Mobile.Equals(model.Mobile.Trim()))) && cust.IsDeleted == false).FirstOrDefault(); if (oldCustomer != null && oldCustomer.ShopId.Equals(WebSession.ShopId)) { if (crudType == Enums.CrudType.Update) { oldCustomer.FirstName = model.FirstName; oldCustomer.MiddleName = model.MiddleName; oldCustomer.LastName = model.LastName; oldCustomer.Email = model.Email; oldCustomer.Address = model.Address; oldCustomer.State = model.State; oldCustomer.District = model.City; oldCustomer.PINCode = model.PINCode; oldCustomer.IsDeleted = false; oldCustomer.IsSync = false; oldCustomer.ModifiedBy = WebSession.UserId; oldCustomer.ModificationDate = DateTime.Now; myshop.Entry(oldCustomer).State = EntityState.Modified; } else if (crudType == Enums.CrudType.Delete) { var stock = myshop.Sale_Tr_Invoice.Where(x => x.IsDeleted == false && x.CustomerId.Equals(model.CustomerTypeId)).FirstOrDefault(); if (stock == null) { oldCustomer.IsDeleted = true; oldCustomer.IsSync = false; oldCustomer.ModifiedBy = WebSession.UserId; oldCustomer.ModificationDate = DateTime.Now; myshop.Entry(oldCustomer).State = EntityState.Modified; } else { return(Enums.CrudStatus.AlreadyInUse); } } else { return(Enums.CrudStatus.AlreadyExistForSameShop); } } else if (crudType == Enums.CrudType.Insert) { Gbl_Master_Customer newCustomer = new Gbl_Master_Customer(); newCustomer.FirstName = model.FirstName; newCustomer.MiddleName = model.MiddleName; newCustomer.LastName = model.LastName; newCustomer.CustomerTypeId = model.CustomerTypeId; newCustomer.Mobile = model.Mobile; newCustomer.Email = model.Email; newCustomer.Address = model.Address; newCustomer.State = model.State; newCustomer.District = model.City; newCustomer.PINCode = model.PINCode; newCustomer.IsDeleted = false; newCustomer.IsSync = false; newCustomer.ModifiedBy = WebSession.UserId; newCustomer.ModificationDate = DateTime.Now; newCustomer.CreatedBy = WebSession.UserId; newCustomer.CreatedDate = DateTime.Now; newCustomer.ShopId = WebSession.ShopId; myshop.Entry(newCustomer).State = EntityState.Added; } int result = myshop.SaveChanges(); return(Utility.CrudStatus(result, crudType)); } catch (Exception ex) { return(Enums.CrudStatus.Exception); } finally { } }
public Enums.CrudStatus SetCustomerType(CustomerTypeModel model, Enums.CrudType crudType) { try { myshop = new MyshopDb(); var oldCustomerType = myshop.Gbl_Master_CustomerType.Where(custType => (custType.CustomerTypeId.Equals(model.CustomerTypeId) || (custType.CustomerType.ToLower().Equals(model.CustomerType.ToLower().Trim()))) && custType.IsDeleted == false).FirstOrDefault(); if (oldCustomerType != null && oldCustomerType.ShopId.Equals(WebSession.ShopId)) { if (crudType == Enums.CrudType.Update) { oldCustomerType.CustomerType = model.CustomerType; oldCustomerType.Description = model.Description; oldCustomerType.IsDeleted = false; oldCustomerType.IsSync = false; oldCustomerType.ModifiedBy = WebSession.UserId; oldCustomerType.ModificationDate = DateTime.Now; myshop.Entry(oldCustomerType).State = EntityState.Modified; } else if (crudType == Enums.CrudType.Delete) { var stock = myshop.Gbl_Master_Customer.Where(x => x.IsDeleted == false && x.CustomerTypeId.Equals(model.CustomerTypeId)).FirstOrDefault(); if (stock == null) { oldCustomerType.IsDeleted = true; oldCustomerType.IsSync = false; oldCustomerType.ModifiedBy = WebSession.UserId; oldCustomerType.ModificationDate = DateTime.Now; myshop.Entry(oldCustomerType).State = EntityState.Modified; } else { return(Enums.CrudStatus.AlreadyInUse); } } else { return(Enums.CrudStatus.AlreadyExistForSameShop); } } else if (crudType == Enums.CrudType.Insert) { Gbl_Master_CustomerType newCustomerType = new Gbl_Master_CustomerType(); newCustomerType.CustomerType = model.CustomerType; newCustomerType.CreatedBy = WebSession.UserId; newCustomerType.CreatedDate = DateTime.Now; newCustomerType.Description = model.Description; newCustomerType.IsDeleted = false; newCustomerType.IsSync = false; newCustomerType.ModifiedBy = WebSession.UserId; newCustomerType.ShopId = WebSession.ShopId; newCustomerType.ModificationDate = DateTime.Now; myshop.Entry(newCustomerType).State = EntityState.Added; } int result = myshop.SaveChanges(); return(Utility.CrudStatus(result, crudType)); } catch (Exception ex) { return(Enums.CrudStatus.Exception); } finally { } }
public Enums.CrudStatus UpdateSinglePermission(List <PermissionModel> model, Enums.CrudType crudType) { try { myshop = new MyshopDb(); if (crudType == Enums.CrudType.Update) { foreach (PermissionModel item in model) { if (item.PermissionId != 0) { var oldPermission = myshop.Gbl_Master_User_Permission.Where(x => x.Id.Equals(item.PermissionId) && x.PageId.Equals(item.PageId)).FirstOrDefault(); if (oldPermission != null) { oldPermission.IsBlockAccess = item.IsBlockAccess; oldPermission.Read = item.Read; oldPermission.Write = item.Write; oldPermission.Update = item.Update; oldPermission.Delete = item.Delete; oldPermission.ModificationDate = DateTime.Now; oldPermission.ModifiedBy = WebSession.UserId; oldPermission.IsSync = false; myshop.Entry(oldPermission).State = EntityState.Modified; } } else { Gbl_Master_User_Permission newPermission = new Gbl_Master_User_Permission(); newPermission.IsBlockAccess = model[0].IsBlockAccess; newPermission.Read = model[0].Read; newPermission.PageId = model[0].PageId; newPermission.Write = model[0].Write; newPermission.Update = model[0].Update; newPermission.Delete = model[0].Delete; newPermission.CreationBy = WebSession.UserId; newPermission.CreationDate = DateTime.Now; newPermission.IsDeleted = false; newPermission.ModificationDate = DateTime.Now; newPermission.ModifiedBy = WebSession.UserId; newPermission.IsSync = false; newPermission.UserId = model[0].UserId; myshop.Entry(newPermission).State = EntityState.Added; } myshop.SaveChanges(); } return(Enums.CrudStatus.Updated); } else if (crudType == Enums.CrudType.Insert) { Gbl_Master_User_Permission newPermission = new Gbl_Master_User_Permission(); newPermission.IsBlockAccess = model[0].IsBlockAccess; newPermission.PageId = model[0].PageId; newPermission.Read = model[0].Read; newPermission.Write = model[0].Write; newPermission.Update = model[0].Update; newPermission.Delete = model[0].Delete; newPermission.CreationBy = WebSession.UserId; newPermission.CreationDate = DateTime.Now; newPermission.IsDeleted = false; newPermission.ModificationDate = DateTime.Now; newPermission.ModifiedBy = WebSession.UserId; newPermission.IsSync = false; newPermission.UserId = model[0].UserId; myshop.Entry(newPermission).State = EntityState.Added; myshop.SaveChanges(); return(Enums.CrudStatus.Inserted); } else if (crudType == Enums.CrudType.Delete) { foreach (PermissionModel item in model) { var oldPermission = myshop.Gbl_Master_User_Permission.Where(x => x.Id.Equals(item.PermissionId) && x.UserId.Equals(item.UserId)).FirstOrDefault(); if (oldPermission != null) { oldPermission.IsDeleted = true; oldPermission.IsSync = false; oldPermission.ModificationDate = DateTime.Now; oldPermission.ModifiedBy = WebSession.UserId; myshop.Entry(oldPermission).State = EntityState.Modified; myshop.SaveChanges(); } } return(Enums.CrudStatus.Deleted); } else { return(Enums.CrudStatus.NoEffect); } } catch (Exception ex) { return(Enums.CrudStatus.Exception); } }
public Enums.CrudStatus SetBrand(BrandModel model, Enums.CrudType crudType) { try { myshop = new MyshopDb(); var oldBrand = myshop.Gbl_Master_Brand.Where(brand => (brand.BrandId.Equals(model.BrandId) || (brand.BrandName.ToLower().Equals(model.BrandName) || brand.BrandName.ToLower().Contains(model.BrandName))) && brand.IsDeleted == false).FirstOrDefault(); if (oldBrand != null && oldBrand.ShopId.Equals(WebSession.ShopId)) { if (crudType == Enums.CrudType.Update) { oldBrand.BrandName = model.BrandName; oldBrand.Description = model.BrandDesc; oldBrand.IsDeleted = false; oldBrand.IsSync = false; oldBrand.ModifiedBy = WebSession.UserId; oldBrand.ModificationDate = DateTime.Now; myshop.Entry(oldBrand).State = EntityState.Modified; } else if (crudType == Enums.CrudType.Delete) { var stock = myshop.Stk_Dtl_Entry.Where(x => x.IsDeleted == false && x.BrandId.Equals(model.BrandId) && x.ShopId.Equals(WebSession.ShopId)).FirstOrDefault(); if (stock == null) { oldBrand.IsDeleted = true; oldBrand.IsSync = false; oldBrand.ModifiedBy = WebSession.UserId; oldBrand.ModificationDate = DateTime.Now; myshop.Entry(oldBrand).State = EntityState.Modified; } else { return(Enums.CrudStatus.AlreadyInUse); } } else { return(Enums.CrudStatus.AlreadyExistForSameShop); } } else if (crudType == Enums.CrudType.Insert) { Gbl_Master_Brand newBrand = new Gbl_Master_Brand(); newBrand.BrandName = model.BrandName; newBrand.CreatedBy = WebSession.UserId; newBrand.CreatedDate = DateTime.Now; newBrand.Description = model.BrandDesc; newBrand.IsDeleted = false; newBrand.IsSync = false; newBrand.ModifiedBy = WebSession.UserId; newBrand.ShopId = WebSession.ShopId; newBrand.ModificationDate = DateTime.Now; myshop.Entry(newBrand).State = EntityState.Added; } int result = myshop.SaveChanges(); return(Utility.CrudStatus(result, crudType)); } catch (Exception ex) { return(Enums.CrudStatus.Exception); } finally { } }
public Enums.CrudStatus SetUser(CreateUserModel model, Enums.CrudType crudType) { try { myshop = new MyshopDb(); byte[] picture = null; if (!string.IsNullOrEmpty(model.Picturename)) { if (Directory.Exists(model.Picturename.Substring(0, model.Picturename.LastIndexOf("\\")))) { picture = File.ReadAllBytes(model.Picturename); } } Gbl_Master_User newUser = new Gbl_Master_User(); var oldUser = myshop.Gbl_Master_User.Where(user => (user.UserId.Equals(model.UserId) || (user.Username.ToLower().Equals(model.Username))) && user.IsDeleted == false).FirstOrDefault(); if (oldUser != null) { if (crudType == Enums.CrudType.Update) { oldUser.Firstname = model.Firstname; oldUser.Lastname = model.Lastname; oldUser.Gender = model.Gender; oldUser.Mobile = model.Mobile; oldUser.UserTypeId = model.UserTypeId; oldUser.IsDeleted = false; oldUser.IsSync = false; oldUser.ModifiedBy = WebSession.UserId; oldUser.ModificationDate = DateTime.Now; oldUser.Photo = picture; myshop.Entry(oldUser).State = EntityState.Modified; } else if (crudType == Enums.CrudType.Delete) { var stock = myshop.User_ShopMapper.Where(x => x.IsDeleted == false && x.UserId.Equals(model.UserId)).FirstOrDefault(); if (stock == null) { oldUser.IsDeleted = true; oldUser.IsSync = false; oldUser.ModifiedBy = WebSession.UserId; oldUser.ModificationDate = DateTime.Now; myshop.Entry(oldUser).State = EntityState.Modified; } else { return(Enums.CrudStatus.AlreadyInUse); } } else { return(Enums.CrudStatus.AlreadyExistForSameShop); } } else if (crudType == Enums.CrudType.Insert) { newUser.Username = model.Username; newUser.Mobile = model.Mobile; newUser.Firstname = model.Firstname; newUser.Lastname = model.Lastname; newUser.Gender = model.Gender; newUser.UserTypeId = model.UserTypeId; newUser.IsActive = true; newUser.IsBlocked = false; newUser.CreationBy = WebSession.UserId; newUser.CreationDate = DateTime.Now; newUser.Password = Utility.getHash(model.Password); // Get String Hash Value newUser.IsDeleted = false; newUser.IsSync = false; newUser.ModifiedBy = WebSession.UserId; newUser.ModificationDate = DateTime.Now; newUser.Photo = picture; newUser.ShopId = WebSession.ShopId; myshop.Entry(newUser).State = EntityState.Added; } int result = myshop.SaveChanges(); if (result > 0) { Login newlogin = new Login(); int ResetExpireTime = 0; string ResetExpireTimeFromConfig = Utility.GetAppSettingsValue("DefaultPasswordResetExpire", "1440"); int.TryParse(ResetExpireTimeFromConfig, out ResetExpireTime); newlogin.CreationBy = WebSession.UserId; newlogin.CreationDate = DateTime.Now; newlogin.IsDeleted = false; newlogin.IsSync = false; newlogin.LoginDate = DateTime.Now; newlogin.ModificationDate = DateTime.Now; newlogin.ModifiedBy = WebSession.UserId; newlogin.UserId = WebSession.UserId; newlogin.OTPid = string.Empty; newlogin.ReserExpireTime = DateTime.Now.AddMinutes(ResetExpireTime); newlogin.GUID = Guid.NewGuid(); // Create new GUID newlogin.IsReset = true; myshop.Logins.Add(newlogin); myshop.SaveChanges(); string emailBody = Utility.EmailUserCreationBody(model.Firstname + " " + model.Lastname, model.Username, model.Mobile, model.Password, "", newlogin.ReserExpireTime.ToString()); string _mailSubject = crudType == Enums.CrudType.Insert ? "Account Created" : "Account Updated"; Utility.EmailSendHtmlFormatted(model.Username, _mailSubject, emailBody); } return(Utility.CrudStatus(result, crudType)); } catch (Exception ex) { return(Enums.CrudStatus.Exception); } finally { if (myshop != null) { myshop = null; } } }
public Enums.CrudStatus SetAppModule(AppModuleModel model, Enums.CrudType crudType) { try { myshop = new MyshopDb(); var oldBank = myshop.Gbl_Master_AppModule.Where(app => (app.ModuleId.Equals(model.ModuleId) || (app.ModuleName.ToLower().Equals(model.ModuleName) || app.ModuleName.ToLower().Contains(model.ModuleName))) && app.IsDeleted == false).FirstOrDefault(); if (oldBank != null) { if (crudType == Enums.CrudType.Update) { oldBank.ModuleName = model.ModuleName; oldBank.Description = model.ModuleDesc; oldBank.IsDeleted = false; oldBank.IsSync = false; oldBank.ModifiedBy = WebSession.UserId; oldBank.ModificationDate = DateTime.Now; myshop.Entry(oldBank).State = EntityState.Modified; } else if (crudType == Enums.CrudType.Delete) { var stock = myshop.Gbl_Master_Page.Where(x => x.IsDeleted == false && x.ModuleId.Equals(model.ModuleId)).FirstOrDefault(); if (stock == null) { oldBank.IsDeleted = true; oldBank.IsSync = false; oldBank.ModifiedBy = WebSession.UserId; oldBank.ModificationDate = DateTime.Now; myshop.Entry(oldBank).State = EntityState.Modified; } else { return(Enums.CrudStatus.AlreadyInUse); } } else { return(Enums.CrudStatus.AlreadyExistForSameShop); } } else if (crudType == Enums.CrudType.Insert) { Gbl_Master_AppModule newBank = new Gbl_Master_AppModule(); newBank.ModuleName = model.ModuleName; newBank.CreatedBy = WebSession.UserId; newBank.CreationDate = DateTime.Now; newBank.Description = model.ModuleDesc; newBank.IsDeleted = false; newBank.IsSync = false; newBank.ModifiedBy = WebSession.UserId; newBank.ModificationDate = DateTime.Now; myshop.Entry(newBank).State = EntityState.Added; } int result = myshop.SaveChanges(); return(Utility.CrudStatus(result, crudType)); } catch (Exception ex) { return(Enums.CrudStatus.Exception); } finally { } }
public Enums.CrudStatus SetUnit(UnitModel model, Enums.CrudType crudType) { try { myshop = new MyshopDb(); var oldUnit = myshop.Gbl_Master_Unit.Where(unit => unit.UnitName.ToLower().Equals(model.UnitName) || unit.UnitName.ToLower().Contains(model.UnitName) && unit.IsDeleted == false).FirstOrDefault(); if (oldUnit != null && oldUnit.ShopId.Equals(WebSession.ShopId)) { if (crudType == Enums.CrudType.Update) { oldUnit.UnitName = model.UnitName; oldUnit.Description = model.UnitDesc; oldUnit.IsDeleted = false; oldUnit.IsSync = false; oldUnit.ModifiedBy = WebSession.UserId; oldUnit.ModificationDate = DateTime.Now; myshop.Entry(oldUnit).State = EntityState.Modified; } else if (crudType == Enums.CrudType.Delete) { var pro = myshop.Gbl_Master_Product.Where(x => x.IsDeleted == false && x.UnitId.Equals(model.UnitId) && x.ShopId.Equals(WebSession.ShopId)).FirstOrDefault(); if (pro == null) { oldUnit.IsDeleted = false; oldUnit.IsSync = false; oldUnit.ModifiedBy = WebSession.UserId; oldUnit.ModificationDate = DateTime.Now; myshop.Entry(oldUnit).State = EntityState.Modified; } else { return(Enums.CrudStatus.AlreadyInUse); } } else { return(Enums.CrudStatus.AlreadyExistForSameShop); } } else if (crudType == Enums.CrudType.Insert) { Gbl_Master_Unit newUnit = new Gbl_Master_Unit(); newUnit.UnitName = model.UnitName; newUnit.CreatedBy = WebSession.UserId; newUnit.CreatedDate = DateTime.Now; newUnit.Description = model.UnitDesc; newUnit.IsDeleted = false; newUnit.IsSync = false; newUnit.ModifiedBy = WebSession.UserId; newUnit.ShopId = WebSession.ShopId; newUnit.ModificationDate = DateTime.Now; myshop.Entry(newUnit).State = EntityState.Added; } int result = myshop.SaveChanges(); return(Utility.CrudStatus(result, crudType)); } catch (Exception ex) { return(Enums.CrudStatus.Exception); } finally { } }
public Enums.CrudStatus SetVendor(VendorModel model, Enums.CrudType crudType) { try { myshop = new MyshopDb(); var onldVen = myshop.Gbl_Master_Vendor.Where(ven => (ven.VendorId.Equals(model.VendorId) || (ven.VendorName.ToLower().Equals(model.VendorName) || ven.VendorName.ToLower().Contains(model.VendorName))) && ven.IsDeleted == false).FirstOrDefault(); if (onldVen != null && onldVen.ShopId.Equals(WebSession.ShopId)) { if (crudType == Enums.CrudType.Update) { onldVen.VendorName = model.VendorName; onldVen.VendorAddress = model.VendorAddress; onldVen.VendorMobile = model.VendorMobile; onldVen.Description = model.VendorDesc; onldVen.IsDeleted = false; onldVen.IsSync = false; onldVen.ModifiedBy = WebSession.UserId; onldVen.ModificationDate = DateTime.Now; myshop.Entry(onldVen).State = EntityState.Modified; } else if (crudType == Enums.CrudType.Delete) { var stock = myshop.Stk_Dtl_Entry.Where(x => x.IsDeleted == false && x.BrandId.Equals(model.VendorId) && x.ShopId.Equals(WebSession.ShopId)).FirstOrDefault(); if (stock == null) { onldVen.IsDeleted = true; onldVen.IsSync = false; onldVen.ModifiedBy = WebSession.UserId; onldVen.ModificationDate = DateTime.Now; myshop.Entry(onldVen).State = EntityState.Modified; } else { return(Enums.CrudStatus.AlreadyInUse); } } else { return(Enums.CrudStatus.AlreadyExistForSameShop); } } else if (crudType == Enums.CrudType.Insert) { Gbl_Master_Vendor newVendor = new Gbl_Master_Vendor(); newVendor.VendorName = model.VendorName; newVendor.VendorAddress = model.VendorAddress; newVendor.VendorMobile = model.VendorMobile; newVendor.Description = model.VendorDesc; newVendor.CreatedBy = WebSession.UserId; newVendor.CreatedDate = DateTime.Now; newVendor.IsDeleted = false; newVendor.IsSync = false; newVendor.ModifiedBy = WebSession.UserId; newVendor.ShopId = WebSession.ShopId; newVendor.ModificationDate = DateTime.Now; myshop.Entry(newVendor).State = EntityState.Added; } int result = myshop.SaveChanges(); return(Utility.CrudStatus(result, crudType)); } catch (Exception ex) { return(Enums.CrudStatus.Exception); } finally { } }
internal static Enums.CrudStatus CrudStatus(int result, Enums.CrudType type) { return(result > 0 ? (type == Enums.CrudType.Insert ? Enums.CrudStatus.Inserted : (type == Enums.CrudType.Update ? Enums.CrudStatus.Updated : Enums.CrudStatus.Deleted)) : Enums.CrudStatus.NoEffect); }
public Tuple <Enums.CrudStatus, Gbl_Master_Employee> SetEmployee(Gbl_Master_Employee model, Enums.CrudType crudType, HttpPostedFileBase files = null) { try { if (files != null) { FileStatus = GlobalMethod.FileUpload(files, files.FileName, GlobalResource.Resource.Module_AddEmployee); if (FileStatus.Item1 < 1) { return(new Tuple <Enums.CrudStatus, Gbl_Master_Employee>(Enums.CrudStatus.FileNotUploaded, model)); } else if (FileStatus.Item2.Length > 0) { model.UserImage = Convert.ToBase64String(FileStatus.Item2); } } myshop = new MyshopDb(); var oldEmp = myshop.Gbl_Master_Employee.Where(emp => emp.EmpId.Equals(model.EmpId) && emp.IsDeleted == false).FirstOrDefault(); Gbl_Master_Employee newEmp = new Gbl_Master_Employee(); if (oldEmp != null) { if (crudType == Enums.CrudType.Update) { oldEmp.Address = model.Address; oldEmp.City = model.City; oldEmp.Distict = model.Distict; oldEmp.DOB = model.DOB; oldEmp.FatherName = model.FatherName; oldEmp.FirstName = model.FirstName; oldEmp.IsAppAccess = model.IsAppAccess; oldEmp.LastName = model.LastName; oldEmp.Mobile = model.Mobile; oldEmp.PANCardNo = model.PANCardNo; oldEmp.PINCode = model.PINCode; oldEmp.RoleId = model.RoleId; oldEmp.State = model.State; oldEmp.IsDeleted = false; oldEmp.IsSync = false; oldEmp.ImageId = FileStatus.Item1; oldEmp.ModifiedBy = WebSession.UserId; oldEmp.ModificationDate = DateTime.Now; myshop.Entry(oldEmp).State = EntityState.Modified; } else if (crudType == Enums.CrudType.Delete) { //var stock = myshop.Gbl_Master_BankAccount.Where(x => x.IsDeleted == false && x.BankId.Equals(model.BankId)).FirstOrDefault(); //if (stock == null) //{ oldEmp.IsDeleted = true; oldEmp.IsSync = false; oldEmp.ModifiedBy = WebSession.UserId; oldEmp.ModificationDate = DateTime.Now; myshop.Entry(oldEmp).State = EntityState.Modified; //} //else //{ // return Enums.CrudStatus.AlreadyInUse; //} } else { return(new Tuple <Enums.CrudStatus, Gbl_Master_Employee>(Enums.CrudStatus.AlreadyExistForSameShop, model)); } } else if (crudType == Enums.CrudType.Insert) { newEmp.AadharNo = model.AadharNo; newEmp.Address = model.Address; newEmp.City = model.City; newEmp.Distict = model.Distict; newEmp.DOB = model.DOB; newEmp.DOJ = model.DOJ; newEmp.EmailId = model.EmailId; newEmp.ShopId = WebSession.ShopId; newEmp.FatherName = model.FatherName; newEmp.FirstName = model.FirstName; newEmp.IsActive = true; newEmp.IsAppAccess = model.IsAppAccess; newEmp.LastName = model.LastName; newEmp.Mobile = model.Mobile; newEmp.PANCardNo = model.PANCardNo; newEmp.PINCode = model.PINCode; newEmp.RoleId = model.RoleId; newEmp.State = model.State; newEmp.CreatedDate = DateTime.Now; newEmp.CreatedBy = WebSession.UserId; newEmp.IsDeleted = false; newEmp.IsSync = false; newEmp.ModifiedBy = WebSession.UserId; newEmp.ModificationDate = DateTime.Now; newEmp.ImageId = FileStatus.Item1; newEmp.AddressDocProofId = model.AddressDocProofId; newEmp.AddressDocProofNo = model.AddressDocProofNo; newEmp.IdentityDocProofId = model.IdentityDocProofId; newEmp.IdentityDocProofNo = model.IdentityDocProofNo; newEmp.Gender = model.Gender.ToLower() == "male" ? "M" : "F"; newEmp.EmergencyContactNo = model.EmergencyContactNo; newEmp.TotalExp = model.TotalExp; newEmp.BloodGroup = model.BloodGroup; newEmp.IsAppAccess = model.IsAppAccess; myshop.Entry(newEmp).State = EntityState.Added; } int result = myshop.SaveChanges(); model.EmpId = newEmp.EmpId; return(new Tuple <Enums.CrudStatus, Gbl_Master_Employee>(Utility.CrudStatus(result, crudType), model)); } catch (Exception ex) { GlobalMethod.LogError("Masters", "Set Employee", "Employee Management", ex.Message, ex); return(new Tuple <Enums.CrudStatus, Gbl_Master_Employee>(Enums.CrudStatus.Exception, model)); } finally { } }