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 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 CrudStatus SaveReturnInvoice(InvoiceReturnDetails invoiceDetails)
{
if (invoiceDetails != null && invoiceDetails.Products != null)
{
_myshopDb = new MyshopDb();
var _oldInvoice = _myshopDb.Sale_Tr_Invoice.Where(x => x.InvoiceId.Equals(invoiceDetails.InvoiceId) && !x.IsDeleted && x.ShopId.Equals(WebSession.ShopId)).FirstOrDefault();
if (_oldInvoice == null)
{
return(CrudStatus.NotExist);
}
else if (_oldInvoice.IsCancelled)
{
return(CrudStatus.InvoiceAlreadyCancelled);
}
else
{
_oldInvoice.IsAmountRefunded = invoiceDetails.RefundAmount > 0 ? true : false;
_oldInvoice.RefundPayModeId = invoiceDetails.RefundPayModeId;
_oldInvoice.RefundAmount = invoiceDetails.RefundAmount;
_oldInvoice.BalanceAmount = invoiceDetails.BalanceAmount;
_oldInvoice.IsSync = false;
_oldInvoice.ModifiedBy = WebSession.UserId;
_oldInvoice.ModifiedDate = DateTime.Now;
_myshopDb.Entry(_oldInvoice).State = EntityState.Modified;
int _retult = _myshopDb.SaveChanges();
if (_retult > 0)
{
var _oldInvoiceDetails = _myshopDb.Sale_Dtl_Invoice.Where(x => x.InvoiceId.Equals(_oldInvoice.InvoiceId) && !x.IsDeleted && x.ShopId.Equals(WebSession.ShopId)).ToList();
foreach (var _currentProduct in invoiceDetails.Products)
{
var _returnProduct = _oldInvoiceDetails.Where(x => x.ProductId.Equals(_currentProduct.ProductId)).FirstOrDefault();
_returnProduct.IsReturn = true;
_returnProduct.IsSync = false;
_returnProduct.ModifiedBy = WebSession.UserId;
_returnProduct.ModifiedDate = DateTime.Now;
_returnProduct.ReturnAmount = _currentProduct.ReturnAmount;
_returnProduct.ReturnDate = DateTime.Now;
_returnProduct.ReturnQty = _currentProduct.ReturnQty;
_returnProduct.ReturnRemark = _currentProduct.ReturnRemark;
_myshopDb.Entry(_returnProduct).State = EntityState.Modified;
}
return(_myshopDb.SaveChanges() > 0 ? CrudStatus.Updated : CrudStatus.PartiallyUpdated);
}
else
{
return(CrudStatus.NoEffect);
}
}
}
else
{
return(CrudStatus.InvalidParameter);
}
}
public CrudStatus CancelInvoice(int InvoiceId, string InvoiceRemark)
{
if (InvoiceId < 1)
{
return(CrudStatus.InvalidParameter);
}
else
{
_myshopDb = new MyshopDb();
var _oldInvoice = _myshopDb.Sale_Tr_Invoice.Where(x => !x.IsDeleted && x.InvoiceId.Equals(InvoiceId) && x.ShopId.Equals(WebSession.ShopId)).FirstOrDefault();
if (_oldInvoice.IsCancelled)
{
return(CrudStatus.InvoiceAlreadyCancelled);
}
else
{
_oldInvoice.IsCancelled = true;
_oldInvoice.CancelledDate = DateTime.Now;
_oldInvoice.CancelRemark = InvoiceRemark;
_oldInvoice.IsSync = false;
_oldInvoice.ModifiedBy = WebSession.UserId;
_oldInvoice.ModifiedDate = DateTime.Now;
_myshopDb.Entry(_oldInvoice).State = EntityState.Modified;
return(_myshopDb.SaveChanges() > 0 ? CrudStatus.Updated : CrudStatus.NoEffect);
}
}
}
public Enums.CrudStatus UpdateErrorLog(int ErrorId)
{
try
{
myshop = new MyshopDb();
var log = myshop.ErrorLogs.Where(x => x.IsDeleted == false && x.Id.Equals(ErrorId)).FirstOrDefault();
if (log == null)
{
return(Enums.CrudStatus.NotExist);
}
else
{
int result = 0;
log.IsResolved = true;
log.ModifiedDate = DateTime.Now;
myshop.Entry(log).State = EntityState.Modified;
result = myshop.SaveChanges();
return(result > 0 ? Utility.CrudStatus(result, Enums.CrudType.Update) : Enums.CrudStatus.NoEffect);
}
}
catch (Exception ex)
{
return(Enums.CrudStatus.Exception);
}
}
public Enums.LoginStatus ResetPassword(string username, string password)
{
try
{
string passHash = Utility.getHash(password);
myShop = new MyshopDb();
var IsSet = myShop.Gbl_Master_User.Where(user => user.Username.ToLower().Equals(username.ToLower()) && user.IsActive == true && user.IsBlocked == false && user.IsDeleted == false).FirstOrDefault();
if (IsSet != null)
{
IsSet.ModificationDate = DateTime.Now;
IsSet.ModifiedBy = IsSet.UserId;
IsSet.IsSync = false;
IsSet.Password = passHash;
myShop.Entry(IsSet).State = EntityState.Modified;
myShop.SaveChanges();
return(Enums.LoginStatus.Authenticate);
}
else
{
return(Enums.LoginStatus.InvalidUser);
}
}
catch (Exception)
{
return(Enums.LoginStatus.Exception);
}
}
public Enums.CrudStatus DeleteUserNotificationList(int notificationId)
{
try
{
myshop = new MyshopDb();
var notify = myshop.Gbl_Master_Notification.Where(x => x.NotificationId.Equals(notificationId) && x.ShopId.Equals(WebSession.ShopId) && x.UserId.Equals(WebSession.UserId)).FirstOrDefault();
if (notify != null)
{
notify.IsDeleted = true;
notify.ModificationDate = DateTime.Now;
notify.ModifiedBy = WebSession.UserId;
notify.IsSync = false;
myshop.Entry(notify).State = EntityState.Modified;
int result = myshop.SaveChanges();
return(result > 0 ? Enums.CrudStatus.Deleted : Enums.CrudStatus.NotDeleted);
}
else
{
return(Enums.CrudStatus.NotExist);
}
}
catch (Exception ex)
{
return(Enums.CrudStatus.Exception);
}
}
public static int DeleteRecord <T>(T row) where T : class
{
MyshopDb dbContext = new MyshopDb();
dbContext.Entry(row).State = EntityState.Modified;
return(dbContext.SaveChanges());
}
public Enums.CrudStatus SetAccess(List <UserAccessModel> model)
{
try
{
int result = 0;
myshop = new MyshopDb();
foreach (UserAccessModel item in model)
{
var user = myshop.Gbl_Master_User.Where(x => x.IsDeleted == false && x.UserId.Equals(item.UserId)).FirstOrDefault();
if (user != null)
{
user.IsDeleted = false;
user.IsSync = false;
user.ModificationDate = DateTime.Now;
user.ModifiedBy = WebSession.UserId;
user.IsActive = item.IsActive;
user.IsBlocked = item.IsBlocked;
myshop.Entry(user).State = EntityState.Modified;
result += myshop.SaveChanges();
}
}
return(Utility.CrudStatus(result, Enums.CrudType.Update));
}
catch (Exception)
{
throw;
}
}
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 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.OtpStatus VerifyOTP(string username, string otp)
{
try
{
myShop = new MyshopDb();
var isExist = myShop.Gbl_Master_User.Where(user => user.Username.ToLower().Equals(username.ToLower()) && user.IsActive == true && user.IsBlocked == false && user.IsDeleted == false).FirstOrDefault();
if (isExist != null)
{
var login = myShop.Logins.Where(log => log.UserId.Equals(isExist.UserId) && log.IsDeleted == false && log.IsReset == true).FirstOrDefault();
if (isExist != null)
{
Enums.OtpStatus status = Utility.VerifyOTP(otp, login.OTPid);
if (status == Enums.OtpStatus.Valid)
{
login.IsReset = false;
login.ReserExpireTime = DateTime.Now.AddHours(-1);
login.GUID = null;
login.ModificationDate = DateTime.Now;
login.ModifiedBy = isExist.UserId;
login.IsSync = false;
myShop.Entry(login).State = EntityState.Modified;
myShop.SaveChanges();
return(Enums.OtpStatus.Valid);
}
return(status);
}
return(Enums.OtpStatus.InvalidUser);
}
else
{
return(Enums.OtpStatus.InvalidUser);
}
}
catch (Exception ex)
{
return(Enums.OtpStatus.Exception);
}
finally
{
if (myShop != null)
{
myShop = null;
}
}
}
public Enums.LoginStatus ChangePassword(string username, string newPassword, string oldPassword)
{
try
{
string oldPassHash = Utility.getHash(oldPassword);
string newPassHash = Utility.getHash(newPassword);
myShop = new MyshopDb();
var _user = myShop.Gbl_Master_User.Where(user => user.Username.ToLower().Equals(username.ToLower()) && user.IsActive == true && user.IsBlocked == false && user.IsDeleted == false && user.Password.Equals(oldPassHash)).FirstOrDefault();
if (_user != null)
{
_user.ModificationDate = DateTime.Now;
_user.ModifiedBy = WebSession.UserId;
_user.IsSync = false;
_user.HasDefaultPassword = false;
_user.Password = newPassHash;
myShop.Entry(_user).State = EntityState.Modified;
int count = myShop.SaveChanges();
if (count > 0)
{
string _userFullname = string.Format("{0} {1}", _user.Firstname, _user.Lastname);
Utility.EmailSendHtmlFormatted(_user.Username, "Password Changed", Utility.ChangePasswordEmailBody(_userFullname));
return(Enums.LoginStatus.Authenticate);
}
else
{
return(Enums.LoginStatus.Failed);
}
}
else
{
return(Enums.LoginStatus.InvalidUser);
}
}
catch (Exception ex)
{
return(Enums.LoginStatus.Exception);
}
}
public Enums.CrudStatus ResetUserPassword(int _userId)
{
try
{
myshop = new MyshopDb();
var _user = myshop.Gbl_Master_User.Where(x => x.IsDeleted == false && x.UserId.Equals(_userId) && x.ShopId.Equals(WebSession.ShopId)).FirstOrDefault();
if (_user == null)
{
return(Enums.CrudStatus.NotExist);
}
else
{
string _randomPassword = Utility.GetDefaultPassword(10);
_user.Password = Utility.getHash(_randomPassword);
_user.HasDefaultPassword = true;
_user.ModificationDate = DateTime.Now;
_user.ModifiedBy = WebSession.UserId;
_user.IsSync = false;
myshop.Entry(_user).State = EntityState.Modified;
int result = myshop.SaveChanges();
if (result > 0)
{
string _userFullname = _user.Firstname + " " + _user.Lastname;
string _emailBody = Utility.EmailUserAdminPasswordResetBody(_userFullname, _user.Username, _randomPassword);
Utility.EmailSendHtmlFormatted(_user.Username, "Password Reset by Admin", _emailBody);
return(Utility.CrudStatus(result, Enums.CrudType.Update));
}
else
{
return(Enums.CrudStatus.NoEffect);
}
}
}
catch (Exception ex)
{
return(Enums.CrudStatus.Exception);
}
}
public Enums.CrudStatus CancelExpenseItem(int ExpenseId, int ExpenseDetailId, string CancelReason)
{
myshop = new MyshopDb();
var expenseDetails = myshop.Exp_Dtl_New.Where(x => !x.IsDeleted && x.ShopId.Equals(WebSession.ShopId) && x.ExpTrId.Equals(ExpenseId)).ToList();
int alreadyCancelled = expenseDetails.Where(x => x.IsCancelled).Count();
var cancelableItem = expenseDetails.Where(x => x.ExpDtlId.Equals(ExpenseDetailId)).FirstOrDefault();
if (cancelableItem != null)
{
cancelableItem.IsCancelled = true;
cancelableItem.CancelReason = CancelReason;
cancelableItem.CancelledDate = DateTime.Now;
cancelableItem.ModifiedBy = WebSession.UserId;
cancelableItem.ModifiedDate = DateTime.Now;
cancelableItem.IsSync = false;
myshop.Entry(cancelableItem).State = EntityState.Modified;
int result = myshop.SaveChanges();
var expTr = myshop.Exp_Tr_New.Where(x => !x.IsDeleted && x.ExpId.Equals(ExpenseId) && x.ShopId.Equals(WebSession.ShopId)).FirstOrDefault();
if (expTr != null)
{
if (expenseDetails.Count == alreadyCancelled + result)
{
expTr.IsCancelled = true;
expTr.CancelledDate = DateTime.Now;
expTr.CancelReason = "All Items Cancelled";
}
expTr.BalanceAmount -= cancelableItem.Qty * cancelableItem.Gbl_Master_ExpenseItem.Price;
expTr.IsSync = false;
expTr.ModifiedBy = WebSession.UserId;
expTr.ModifiedDate = DateTime.Now;
myshop.SaveChanges();
}
return(result > 0 ? Enums.CrudStatus.Updated : Enums.CrudStatus.NotUpdated);
}
return(Enums.CrudStatus.NotExist);
}
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
{
}
}
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 TaskMarkComplete(int _taskId)
{
try
{
myshop = new MyshopDb();
var _oldTask = myshop.Gbl_Master_Task.Where(x => x.TaskId.Equals(_taskId) && x.AssignedUserId.Equals(WebSession.UserId) && !x.IsDeleted && !x.IsCompleted && x.ShopId.Equals(WebSession.ShopId)).FirstOrDefault();
if (_oldTask != null)
{
_oldTask.IsSync = false;
_oldTask.IsCompleted = true;
_oldTask.ModifiedBy = WebSession.UserId;
_oldTask.ModifiedDate = DateTime.Now;
myshop.Entry(_oldTask).State = EntityState.Modified;
int _result = myshop.SaveChanges();
if (_result > 0)
{
var taskUser = myshop.Gbl_Master_Task.Where(x =>
x.IsDeleted == false &&
!x.IsCompleted &&
x.ShopId.Equals(WebSession.ShopId) &&
x.AssignedUserId.Equals(WebSession.UserId)).ToList();
List <TaskUserModel> _taskList = new List <TaskUserModel>();
foreach (Gbl_Master_Task item in taskUser)
{
TaskUserModel _newItem = new TaskUserModel();
_newItem.TaskId = item.TaskId;
_newItem.CreatedDate = item.CreatedDate;
_newItem.TaskCreatedByName = item.Gbl_Master_User.Firstname + " " + item.Gbl_Master_User.Lastname;
_newItem.TaskCreatedById = item.Gbl_Master_User.UserId;
_newItem.TaskCreatedByPhoto = Convert.ToBase64String(Utility.GetImageThumbnails(item.Gbl_Master_User.Photo, 30));
_newItem.IsImporatant = item.IsImportant;
_newItem.TaskAssignedUserId = item.AssignedUserId;
_newItem.TaskAssignedUserName = item.Gbl_Master_User1.Firstname + " " + item.Gbl_Master_User1.Lastname;;
_newItem.Priority = item.Priority;
_newItem.TaskDetails = item.TaskDetails;
TimeSpan span = DateTime.Now.Subtract(Convert.ToDateTime(item.CreatedDate));
if (span.Days == 1)
{
_newItem.TaskAssignedTime = string.Format("{0} day ago", span.Days.ToString());
}
else if (span.Days > 1)
{
_newItem.TaskAssignedTime = string.Format("{0} days ago", span.Days.ToString());
}
else if (span.Hours >= 1 && span.Hours <= 23)
{
_newItem.TaskAssignedTime = string.Format("{0} hour ago", span.Hours.ToString());
}
else //if (span.Minutes < 60)
{
_newItem.TaskAssignedTime = string.Format("{0} min ago", span.Minutes.ToString());
}
_taskList.Add(_newItem);
}
WebSession.TaskCount = taskUser.Count();
WebSession.TaskList = _taskList;
}
return(Utility.CrudStatus(_result, Enums.CrudType.Update));
}
else
{
return(Enums.CrudStatus.NotExist);
}
}
catch (Exception ex)
{
return(Enums.CrudStatus.Exception);
}
}
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 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 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 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 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 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.ResetLinkStatus sendPasswordRestLink(string username, string _os, string _browser)
{
try
{
myShop = new MyshopDb();
var isExist = myShop.Gbl_Master_User.Where(user => user.Username.ToLower().Equals(username.ToLower())).FirstOrDefault();
if (isExist != null)
{
//Setting session properties
WebSession.Firstname = isExist.Firstname;
WebSession.Lastname = isExist.Lastname;
WebSession.Username = isExist.Username;
if (isExist.IsDeleted == true)
{
return(Enums.ResetLinkStatus.UserDeleted);
}
else if (isExist.IsActive == false)
{
return(Enums.ResetLinkStatus.InactiveUser);
}
else if (isExist.IsBlocked == true)
{
return(Enums.ResetLinkStatus.BlockedUser);
}
else if (string.IsNullOrEmpty(isExist.Mobile))
{
return(Enums.ResetLinkStatus.invalidMobile);
}
else
{
string otp = string.Empty;
int ResetExpireTime = 0;
string ResetExpireTimeFromConfig = Utility.GetAppSettingsValue("PasswordResetExpire", "30");
int.TryParse(ResetExpireTimeFromConfig, out ResetExpireTime);
string messageId = Utility.CreateOTP(isExist.Mobile, out otp);
var login = myShop.Logins.Where(log => log.UserId.Equals(isExist.UserId) && log.IsDeleted == false).FirstOrDefault();
if (login != null)
{
login.ModificationDate = DateTime.Now;
login.IsSync = false;
login.ModifiedBy = isExist.UserId;
login.OTPid = messageId;
login.ReserExpireTime = DateTime.Now.AddMinutes(30);
login.GUID = Guid.NewGuid(); // Create new GUID
login.IsReset = true;
myShop.Entry(login).State = EntityState.Modified;
}
else
{
Login newlogin = new Login();
newlogin.CreationBy = isExist.UserId;
newlogin.CreationDate = DateTime.Now;
newlogin.IsDeleted = false;
newlogin.IsSync = false;
newlogin.LoginDate = DateTime.Now;
newlogin.ModificationDate = DateTime.Now;
newlogin.ModifiedBy = isExist.UserId;
newlogin.UserId = isExist.UserId;
newlogin.OTPid = messageId;
newlogin.ReserExpireTime = DateTime.Now.AddMinutes(ResetExpireTime);
newlogin.GUID = Guid.NewGuid(); // Create new GUID
newlogin.IsReset = true;
myShop.Logins.Add(newlogin);
}
int result = myShop.SaveChanges();
if (result > 0)
{
Utility.EmailSendHtmlFormatted(isExist.Username, "Password Reset Link", Utility.EmailResetBody(isExist.Firstname + " " + isExist.Lastname, isExist.UserId.ToString(), login.GUID.ToString(), _os, _browser, DateTime.Now.AddMinutes(ResetExpireTime), otp));
}
return(Enums.ResetLinkStatus.send);
}
}
else
{
return(Enums.ResetLinkStatus.invalidUser);
}
}
catch (Exception ex)
{
return(Enums.ResetLinkStatus.exception);
}
finally
{
if (myShop != null)
{
myShop = null;
}
}
}
public Enums.LoginStatus getLogin(string username, string password)
{
try
{
myShop = new MyshopDb();
string passHash = Utility.getHash(password);
var isAuthenticated = myShop.Gbl_Master_User.Where(user => user.Username.Equals(username)).FirstOrDefault();
if (isAuthenticated == null)
{
return(Enums.LoginStatus.NotExist);
}
else if (isAuthenticated.IsActive == false)
{
return(Enums.LoginStatus.Inactive);
}
else if (isAuthenticated.IsBlocked == true)
{
return(Enums.LoginStatus.UserBlocked);
}
else if (isAuthenticated.IsDeleted == true)
{
return(Enums.LoginStatus.UserDeleted);
}
else
{
var login = myShop.Logins.Where(log => log.UserId.Equals(isAuthenticated.UserId) && log.IsDeleted == false).FirstOrDefault();
if (login != null)
{
if (login.IsLoginBlocked)
{
return(Enums.LoginStatus.LoginBlocked);
}
else if (isAuthenticated.Password != passHash)
{
login.LoginAttempt += 1;
login.ModificationDate = DateTime.Now;
login.ModifiedBy = isAuthenticated.UserId;
myShop.Entry(login).State = EntityState.Modified;
myShop.SaveChanges();
return(Enums.LoginStatus.InvalidCredential);
}
else if (login.LoginAttempt >= 3)
{
login.IsLoginBlocked = true;
login.ModificationDate = DateTime.Now;
login.ModifiedBy = isAuthenticated.UserId;
myShop.Entry(login).State = EntityState.Modified;
myShop.SaveChanges();
return(Enums.LoginStatus.AttemptExceeded);
}
}
else
{
Login newLogin = new Login();
newLogin.CreationBy = WebSession.UserId;
newLogin.UserId = isAuthenticated.UserId;
newLogin.ModifiedBy = WebSession.UserId;
newLogin.ModificationDate = DateTime.Now;
newLogin.LoginDate = DateTime.Now;
newLogin.IsSync = false;
newLogin.IsReset = false;
newLogin.IsLoginBlocked = false;
newLogin.IsDeleted = false;
newLogin.CreationDate = DateTime.Now;
myShop.Entry(newLogin).State = EntityState.Added;
myShop.SaveChanges();
}
var userType = myShop.Gbl_Master_UserType.Where(type => type.UserTypeId.Equals(isAuthenticated.UserTypeId) && type.IsDeleted == false).FirstOrDefault();
List <CustomPermission> userPermission = (from permission in myShop.Gbl_Master_User_Permission.Where(x => x.UserId.Equals(isAuthenticated.UserId) && x.IsDeleted == false)
from page in myShop.Gbl_Master_Page.Where(x => x.PageId.Equals(permission.PageId) && x.IsDeleted == false)
from module in myShop.Gbl_Master_AppModule.Where(x => x.ModuleId.Equals(page.ModuleId) && x.IsDeleted == false)
select new CustomPermission
{
Delete = permission.Delete,
IsBlockAccess = permission.IsBlockAccess,
Read = permission.Read,
Update = permission.Update,
Write = permission.Write,
UserId = permission.UserId,
PageId = permission.PageId,
PageName = page.PageName,
Url = page.Url,
ParentId = page.ParentId,
ModuleId = page.ModuleId,
ModuleName = module.ModuleName
}).ToList();
var shopname =
(from shopMap in myShop.User_ShopMapper
join shop in myShop.Gbl_Master_Shop on shopMap.ShopId equals shop.ShopId
where shopMap.IsDeleted == false && shop.IsDeleted == false && shopMap.UserId == isAuthenticated.UserId
select new
{
shop.ShopId,
ShopName = shop.Name,
shop.Mobile,
shop.Address,
shop.Email,
State = shop.Gbl_Master_State.StateName,
Distict = shop.Gbl_Master_City.CityName,
shop.Owner
}).ToList();
List <ShopCollection> shopCol = new List <ShopCollection>();
if (shopname.Count > 0)
{
WebSession.ShopId = shopname[0].ShopId;
WebSession.ShopName = shopname[0].ShopName;
foreach (var item in shopname)
{
ShopCollection newShop = new ShopCollection();
newShop.ShopId = item.ShopId;
newShop.ShopName = item.ShopName;
newShop.ShopCity = item.Distict;
newShop.OwnerEmail = item.Email;
newShop.OwnerMobile = item.Mobile;
newShop.ShopAddress = item.Address;
newShop.ShopState = item.State;
shopCol.Add(newShop);
}
}
var downtime = myShop.Gbl_AppDowntime.Where(x => x.IsDeleted == false && x.DownTimeEnd >= DateTime.Now).FirstOrDefault();
if (downtime != null)
{
WebSession.DowntimeEnd = downtime.DownTimeEnd;
WebSession.DowntimeStart = downtime.DownTimeStart;
WebSession.DowntimeMessage = downtime.Message;
}
else
{
WebSession.DowntimeMessage = string.Empty;
}
if (login != null)
{
login.LoginAttempt = 0;
login.LoginDate = DateTime.Now;
login.ModificationDate = DateTime.Now;
login.IsSync = false;
login.ModifiedBy = isAuthenticated.UserId;
myShop.Entry(login).State = EntityState.Modified;
}
WebSession.UserId = isAuthenticated.UserId;
WebSession.Firstname = isAuthenticated.Firstname;
WebSession.Lastname = isAuthenticated.Lastname;
WebSession.UserIsActive = isAuthenticated.IsActive;
WebSession.UserIsDeleted = isAuthenticated.IsDeleted;
WebSession.UserIsBlocked = isAuthenticated.IsBlocked;
WebSession.UserMobile = isAuthenticated.Mobile;
WebSession.Username = isAuthenticated.Username;
WebSession.ShopList = shopCol;
WebSession.UserPhoto = isAuthenticated.Photo == null ? string.Empty : Convert.ToBase64String(isAuthenticated.Photo);
WebSession.UserType = isAuthenticated.Gbl_Master_UserType.UserType;
WebSession.UserGender = isAuthenticated.Gender.ToUpper();
if (userType != null)
{
WebSession.UserType = userType.UserType;
}
if (userPermission != null)
{
WebSession.Permission = userPermission;
}
var notification = myShop.Gbl_Master_Notification.Where(x =>
x.IsDeleted == false &&
x.IsPushed == true &&
x.IsRead == false &&
x.MessageExpireDate >= DateTime.Now &&
x.ShopId.Equals(WebSession.ShopId) &&
(x.UserId.Equals(WebSession.UserId) || x.IsForAll == true) &&
(x.Gbl_Master_NotificationType.NotificationType.ToLower().IndexOf("push") > -1 || x.Gbl_Master_NotificationType.NotificationType.ToLower().IndexOf("web") > -1)
).ToList();
List <WebSessionNotificationList> _notificationList = new List <WebSessionNotificationList>();
foreach (Gbl_Master_Notification item in notification)
{
WebSessionNotificationList _newItem = new WebSessionNotificationList();
_newItem.Message = item.Message;
_newItem.Sender = string.Format("{0} {1}", item.Gbl_Master_User.Firstname, item.Gbl_Master_User.Lastname);
_newItem.Photo = Convert.ToBase64String(item.Gbl_Master_User.Photo);
_newItem.ReceiveDate = Convert.ToDateTime(item.PushedDate);
_newItem.NotificationId = item.NotificationId;
TimeSpan span = DateTime.Now.Subtract(Convert.ToDateTime(item.PushedDate));
if (span.Days == 1)
{
_newItem.ReceiveTime = string.Format("{0} day ago", span.Days.ToString());
}
else if (span.Days > 1)
{
_newItem.ReceiveTime = string.Format("{0} days ago", span.Days.ToString());
}
else if (span.Hours >= 1 && span.Hours <= 23)
{
_newItem.ReceiveTime = string.Format("{0} hour ago", span.Hours.ToString());
}
else //if (span.Minutes < 60)
{
_newItem.ReceiveTime = string.Format("{0} min ago", span.Minutes.ToString());
}
_notificationList.Add(_newItem);
}
WebSession.NotificationList = _notificationList;
WebSession.NotificationCount = _notificationList.Count();
var taskUser = myShop.Gbl_Master_Task.Where(x =>
x.IsDeleted == false &&
!x.IsCompleted &&
x.ShopId.Equals(WebSession.ShopId) &&
x.AssignedUserId.Equals(WebSession.UserId)).ToList();
List <TaskUserModel> _taskList = new List <TaskUserModel>();
foreach (Gbl_Master_Task item in taskUser)
{
TaskUserModel _newItem = new TaskUserModel();
_newItem.TaskId = item.TaskId;
_newItem.CreatedDate = item.CreatedDate;
_newItem.TaskCreatedByName = item.Gbl_Master_User.Firstname + " " + item.Gbl_Master_User.Lastname;
_newItem.TaskCreatedById = item.Gbl_Master_User.UserId;
_newItem.TaskCreatedByPhoto = Convert.ToBase64String(Utility.GetImageThumbnails(item.Gbl_Master_User.Photo, 30));
_newItem.IsImporatant = item.IsImportant;
_newItem.TaskAssignedUserId = item.AssignedUserId;
_newItem.TaskAssignedUserName = item.Gbl_Master_User1.Firstname + " " + item.Gbl_Master_User1.Lastname;;
_newItem.Priority = item.Priority;
_newItem.TaskDetails = item.TaskDetails;
TimeSpan span = DateTime.Now.Subtract(Convert.ToDateTime(item.CreatedDate));
if (span.Days == 1)
{
_newItem.TaskAssignedTime = string.Format("{0} day ago", span.Days.ToString());
}
else if (span.Days > 1)
{
_newItem.TaskAssignedTime = string.Format("{0} days ago", span.Days.ToString());
}
else if (span.Hours >= 1 && span.Hours <= 23)
{
_newItem.TaskAssignedTime = string.Format("{0} hour ago", span.Hours.ToString());
}
else //if (span.Minutes < 60)
{
_newItem.TaskAssignedTime = string.Format("{0} min ago", span.Minutes.ToString());
}
_taskList.Add(_newItem);
}
WebSession.TaskCount = taskUser.Count();
WebSession.TaskList = _taskList;
if (isAuthenticated.HasDefaultPassword ?? false)
{
WebSession.HasDefaultPassword = true;
return(Enums.LoginStatus.HasDefaultPassword);
}
else
{
return(shopname.Count > 0 ? Enums.LoginStatus.Authenticate : Enums.LoginStatus.NoShopMapped);
}
}
}
catch (Exception)
{
throw;
}
finally
{
if (myShop != null)
{
myShop = null;
}
}
}
public CrudStatus SaveSetting(SalesSettingModel model, CrudType crudType)
{
myshopDb = new MyshopDb();
int _result = 0;
if (model.Id < 1 && crudType == CrudType.Insert)
{
var _oldSetting = myshopDb.Sale_Setting.Where(x => !x.IsDeleted && x.ShopId.Equals(WebSession.ShopId)).FirstOrDefault();
if (_oldSetting != null)
{
_oldSetting.IsDeleted = true;
_oldSetting.IsSync = false;
_oldSetting.ModifiedBy = WebSession.UserId;
_oldSetting.ModifiedDate = DateTime.Now;
myshopDb.Entry(_oldSetting).State = EntityState.Modified;
_result = myshopDb.SaveChanges();
}
Sale_Setting _newSetting = new Sale_Setting();
_newSetting.CreatedBy = WebSession.UserId;
_newSetting.CreatedDate = DateTime.Now;
_newSetting.GSTIN = model.GSTIN;
_newSetting.IsDeleted = false;
_newSetting.IsSync = false;
_newSetting.ReturnPolicy = model.ReturnPolicy;
_newSetting.GstRate = model.GstRate;
_newSetting.WeeklyClosingDay = model.WeeklyClosingDay;
_newSetting.ExchangeDayTime = model.ExchangeDayTime;
_newSetting.SalesClosingTime = model.SalesClosingTime;
_newSetting.SalesOpeningTime = model.SalesOpeningTime;
_newSetting.ShopId = WebSession.ShopId;
myshopDb.Entry(_newSetting).State = EntityState.Added;
_result = myshopDb.SaveChanges();
}
else
{
var _setting = myshopDb.Sale_Setting.Where(x => !x.IsDeleted && x.Id.Equals(model.Id) && x.ShopId.Equals(WebSession.ShopId)).FirstOrDefault();
if (_setting != null)
{
_setting.IsSync = false;
_setting.ModifiedBy = WebSession.UserId;
_setting.ModifiedDate = DateTime.Now;
if (crudType == CrudType.Delete)
{
_setting.IsDeleted = true;
goto Save;
}
_setting.GSTIN = model.GSTIN;
_setting.GstRate = model.GstRate;
_setting.ReturnPolicy = model.ReturnPolicy;
_setting.SalesClosingTime = model.SalesClosingTime;
_setting.SalesOpeningTime = model.SalesOpeningTime;
_setting.WeeklyClosingDay = model.WeeklyClosingDay;
_setting.ExchangeDayTime = model.ExchangeDayTime;
#region Set Sales Session
WebSession.GstRate = model.GstRate;
WebSession.ShopClosingTime = Convert.ToInt32(model.SalesClosingTime);
WebSession.ShopOpeningTime = Convert.ToInt32(model.SalesOpeningTime);
WebSession.ShopReturnPolicy = model.ReturnPolicy;
#endregion
Save:
myshopDb.Entry(_setting).State = EntityState.Modified;
_result = myshopDb.SaveChanges();
}
}
return(Utility.CrudStatus(_result, crudType));
}
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
{
}
}
