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
{
}
}
