public ActionResult Save(AdMonthModel model)
{
TransactionMessage TransMessage = new TransactionMessage();
TransMessage.Status = MessageStatus.Error;
try
{
if (ModelState.IsValid)
{
if (model.EncryptedID.IsValidEncryptedID() && model.EncryptedID.ToDecrypt().IsNumber())
{
model.AdMonthID = Convert.ToInt32(model.EncryptedID.ToDecrypt());
}
model = _AdMonth.Save(model);
if (model.TransMessage.Status == MessageStatus.Success)
{
SuccessNotification(model.TransMessage.Message);
}
}
else
{
TransMessage.Message = utilityHelper.ReadGlobalMessage("AdMonth", "ErrorMessage");
}
}
catch (Exception ex)
{
// write exception log
EventLogHandler.WriteLog(ex);
}
return(Json(model.TransMessage, JsonRequestBehavior.DenyGet));
}
/// <summary>
/// to get page full detail
/// //changed according to client discussion on 5th aug 2016
/// User choice will be done according to lock out start & end date
/// </summary>
/// <param name="encryptedId"></param>
/// <returns></returns>
public AdMonthModel GetDetailByMonthId()
{
AdMonthModel model = new AdMonthModel();
try
{
#region get detail
DateTime currentDate = utilityHelper.CurrentDateTime.Date;
model = UnitofWork.RepoAdMonth.Where(x => x.LockOutStartDate.HasValue && x.LockOutStartDate <= currentDate && x.LockOutEndDate.HasValue && x.LockOutEndDate >= currentDate).Select(x => new AdMonthModel
{
AdMonthID = x.AdMonthID,
AdOptionID = x.AdOptionID ?? 0,
AdCouponID = x.AdCoupnID ?? 0,
AdCouponName = x.Coupon != null ? x.Coupon.CouponText ?? "" : "",
AdOptionName = x.ADOption != null ? x.ADOption.ADOptionName ?? "" : "",
CorpInHomeDate = x.CorpInHomeDate ?? new DateTime(),
//InHomeEnd = x.InHomeEnd ?? new DateTime(),
//InHomeStart = x.InHomeStart ?? new DateTime(),
DropNumber = x.DropNumber ?? 0,
LockOutEndDate = x.LockOutEndDate ?? new DateTime(),
LockOutStartDate = x.LockOutStartDate ?? new DateTime(),
Month = x.Month ?? 0,
PetpartnerInfo = x.PetpartnerInfo ?? "",
Year = x.Year ?? 0,
CorpPlanText = x.CorpPlanText,
}).FirstOrDefault();
#endregion
}
catch (Exception ex)
{
EventLogHandler.WriteLog(ex);
}
return(model);
}
/// <summary>
/// to get page full detail
/// </summary>
/// <param name="encryptedId"></param>
/// <returns></returns>
public CouponModel GetDetail(string encryptedId)
{
CouponModel model = new CouponModel();
try
{
int CouponId = Convert.ToInt32(encryptedId);
#region get detail
model = UnitofWork.RepoCoupon.Where(x => x.CouponID == CouponId).Select(x => new CouponModel
{
CouponText = x.CouponText,
CouponID = x.CouponID,
IsActive = x.IsActive ?? true,
}).FirstOrDefault();
#endregion
if (model != null)
{
model.EncryptedID = model.CouponID.ToString().ToEnctypt();
}
else
{
model = new CouponModel();
}
}
catch (Exception ex)
{
EventLogHandler.WriteLog(ex);
}
return(model);
}
public AdOptionModel GetSpecialDetail(string specialAdoption)
{
AdOptionModel model = new AdOptionModel();
try
{
#region get detail
model = UnitofWork.RepoAdOption.Where(x => x.SpecialChoice == specialAdoption).Select(x => new AdOptionModel
{
ADOptionName = x.ADOptionName,
MinimumCirculation = x.MinimumCirculation,
Vendorname = x.Vendorname,
ADOptionID = x.ADOptionID,
IsActive = x.Inactive ?? true,
SpecialChoice = x.SpecialChoice,
}).FirstOrDefault();
#endregion
if (model != null)
{
model.EncryptedID = model.ADOptionID.ToString().ToEnctypt();
}
else
{
model = new AdOptionModel();
}
}
catch (Exception ex)
{
EventLogHandler.WriteLog(ex);
}
return(model);
}
public ActionResult Save(DocumentModel model, HttpPostedFileBase files)
{
TransactionMessage TransMessage = new TransactionMessage();
TransMessage.Status = MessageStatus.Error;
try
{
if (ModelState.IsValid && files != null)
{
model.FileName = files.FileName;
model.FilePath = utilityHelper.UploadFile(files);
model = _document.Save(model);
if (model.TransMessage.Status == MessageStatus.Success)
{
SuccessNotification(model.TransMessage.Message);
}
}
else
{
ErrorNotification(utilityHelper.ReadGlobalMessage("Document", "ErrorMessage"));
}
}
catch (Exception ex)
{
// write exception log
EventLogHandler.WriteLog(ex);
}
return(RedirectToAction("Index", new { id = model.MonthID }));
}
public ActionResult SaveCouponAdMonth(CouponAdMonthModel model)
{
TransactionMessage TransMessage = new TransactionMessage();
TransMessage.Status = MessageStatus.Error;
try
{
if (ModelState.IsValid)
{
model = _coupon.CouponAdMonthSave(model);
if (model.TransMessage.Status == MessageStatus.Success)
{
SuccessNotification(model.TransMessage.Message);
}
}
else
{
TransMessage.Message = utilityHelper.ReadGlobalMessage("ManageCouponAdMonth", "ErrorMessage");
}
}
catch (Exception ex)
{
// write exception log
EventLogHandler.WriteLog(ex);
}
return(Json(model.TransMessage, JsonRequestBehavior.DenyGet));
}
/// <summary>
/// to get page full detail
/// </summary>
/// <param name="encryptedId"></param>
/// <returns></returns>
public StoreOptionModel GetDetail(string encryptedId)
{
StoreOptionModel model = new StoreOptionModel();
try
{
int AllowedOptionId = Convert.ToInt32(encryptedId);
#region get detail
model = UnitofWork.RepoAllowedStoreOption.Where(x => x.AllowedStoreOptionID == AllowedOptionId).Select(x => new StoreOptionModel
{
AllowedStoreOptionId = x.AllowedStoreOptionID,
OptionId = x.AdOptionID ?? 0,
StoreId = x.StoreID,
OptionName = x.ADOption.ADOptionName,
StoreName = x.Store.Storename
}).FirstOrDefault();
#endregion
if (model != null)
{
model.EncryptedID = model.AllowedStoreOptionId.ToString().ToEnctypt();
}
else
{
model = new StoreOptionModel();
}
}
catch (Exception ex)
{
EventLogHandler.WriteLog(ex);
}
return(model);
}
/// <summary>
/// to get page full detail
/// </summary>
/// <param name="encryptedId"></param>
/// <returns></returns>
public UserStoreModel GetDetail(string encryptedId)
{
UserStoreModel model = new UserStoreModel();
try
{
int UserId = Convert.ToInt32(encryptedId);
#region get detail
model = UnitofWork.RepoUserStore.Where(x => x.UserID == UserId && x.User.IsActive == true).Select(x => new UserStoreModel
{
UserID = x.UserID ?? 0,
UserStoreID = x.UserStoreID,
StoreName = x.Store.Storename,
StoreID = x.StoreID ?? 0,
OwnerName = x.User.Ownername ?? "",
}).FirstOrDefault();
#endregion
if (model != null)
{
model.EncryptedID = model.UserID.ToString().ToEnctypt();
}
else
{
model = new UserStoreModel();
}
}
catch (Exception ex)
{
EventLogHandler.WriteLog(ex);
}
return(model);
}
/// <summary>
/// to get page full detail
/// </summary>
/// <param name="encryptedId"></param>
/// <returns></returns>
public MarketModel GetDetail(string encryptedId)
{
MarketModel model = new MarketModel();
try
{
int marketId = Convert.ToInt32(encryptedId.ToDecrypt());
#region get detail
model = UnitofWork.RepoMarket.Where(x => x.MarketID == marketId).Select(x => new MarketModel
{
MarketId = x.MarketID,
Name = x.Name
}).FirstOrDefault();
#endregion
if (model != null)
{
model.EncryptedID = model.MarketId.ToString().ToEnctypt();
}
else
{
model = new MarketModel();
}
}
catch (Exception ex)
{
EventLogHandler.WriteLog(ex);
}
return(model);
}
/// <summary>
/// to delete page
/// </summary>
/// <param name="encryptedId">encrypted page id</param>
/// <returns></returns>
public TransactionMessage Delete(string encryptedId)
{
TransactionMessage model = new TransactionMessage();
model.Status = MessageStatus.Error;
model.Message = utilityHelper.ReadGlobalMessage("ManageUser", "InvalidRequest");
try
{
if (encryptedId.IsValidEncryptedID())
{
int UserStoreId = Convert.ToInt32(encryptedId.ToDecrypt());
var item = UnitofWork.RepoUserStore.Where(x => x.UserStoreID == UserStoreId).FirstOrDefault();
if (item != null)
{
UnitofWork.RepoUserStore.Delete(item);
UnitofWork.Commit();
model.Message = utilityHelper.ReadGlobalMessage("ManageStoreOption", "Delete");
model.Status = MessageStatus.Success;
}
}
}
catch (Exception ex)
{
EventLogHandler.WriteLog(ex);
}
return(model);
}
public ActionResult SaveUser(UsersModel model)
{
TransactionMessage TransMessage = new TransactionMessage();
TransMessage.Status = MessageStatus.Error;
try
{
if (ModelState.IsValid)
{
bool isNew = true;
model.UserID = SessionHelper.UserId;
isNew = false;
model = _user.Save(model);
if (model.TransMessage.Status == MessageStatus.Success)
{
SessionHelper.UserName = model.OwnerName;
SuccessNotification(model.TransMessage.Message);
}
}
else
{
TransMessage.Message = utilityHelper.ReadGlobalMessage("ManageUser", "ErrorMessage");
}
}
catch (Exception ex)
{
// write exception log
EventLogHandler.WriteLog(ex);
}
return(Json(model.TransMessage, JsonRequestBehavior.DenyGet));
}
public ActionResult DoLogin(LoginModel model)
{
TransactionMessage TransMessage = new TransactionMessage();
TransMessage.Status = MessageStatus.Error;
try
{
if (ModelState.IsValid)
{
string password = model.Password.ToEnctyptedPassword();
// check user credential
var user = UnitofWork.RepoUser.Where(x => x.Email.ToLower() == model.Email.ToLower() && x.Password == password && x.IsAdmin == true && x.IsActive == true).FirstOrDefault();
if (user != null)
{
SessionHelper.UserId = user.UserID;
SessionHelper.UserName = user.Ownername ?? "";
SessionHelper.IsAdmin = user.IsAdmin;
if (model.RememberMe)
{
SessionHelper.UserCookie = user.UserID.ToString().ToEnctypt();
}
#region Add to History
var browser = Request.Browser;
UnitofWork.RepoLoginHistory.Add(new LoginHistory()
{
Browser = browser.Browser,
TimeStamp = utilityHelper.CurrentDateTime,
UserID = user.UserID,
IPaddress = utilityHelper.IpAddress(),
Device = browser.IsMobileDevice ? "Mobile" : "Web",
});
UnitofWork.Commit();
#endregion
TransMessage.Status = MessageStatus.Success;
TransMessage.Message = string.IsNullOrEmpty(model.ReturnUrl) ? Url.Action("Index", "Dashboard") : model.ReturnUrl;
}
else
{
TransMessage.Message = utilityHelper.ReadGlobalMessage("Login", "ErrorMessage");
}
}
else
{
TransMessage.Message = utilityHelper.ReadGlobalMessage("Login", "ErrorMessage");
}
}
catch (Exception ex)
{
// write exception log
EventLogHandler.WriteLog(ex);
}
return(Json(TransMessage, JsonRequestBehavior.DenyGet));
}
public async Task <string> WriteEvent(IActorState actor, string eventid, string parentEventid, object data)
{
if (EventLogHandler != null)
{
var result = await EventLogHandler.Write(actor,
new EventLog { Data = data, DateTime = DateTime.Now, ActorPath = actor.ActorPath, EventPath = actor.EventPath, EventID = eventid, ParentEventID = parentEventid });
return(result);
}
return(null);
}
public ActionResult SaveUserAdChoice(List <StoreAdChoiceModel> model)
{
TransactionMessage TransMessage = new TransactionMessage();
TransMessage.Status = MessageStatus.Error;
TransMessage.Message = "Redirecting to next step";
string msg = "";
int counter = 0;
int i = 0;
try
{
if (model != null)
{
List <StoreAdChoiceModel> list = new List <StoreAdChoiceModel>();
if (SessionHelper.SessionForModel != null && SessionHelper.SessionForModel.GetType() == typeof(List <StoreAdChoiceModel>))
{
list = (List <StoreAdChoiceModel>)SessionHelper.SessionForModel;
}
#region Validation
foreach (var item in model)
{
list[i++].ChoiceInitials = item.ChoiceInitials;
}
SessionHelper.SessionForModel = list;
#endregion
if (counter > 0)
{
TransMessage.Status = MessageStatus.Error;
TransMessage.Message = msg;
}
else // save to database
{
TransMessage = _storeadchoice.Save(list);
if (TransMessage.Status == MessageStatus.Success)
{
// TransMessage.Message = utilityHelper.ReadGlobalMessage("Store", "Save");
SessionHelper.SessionForModel = null;
}
}
}
}
catch (Exception ex)
{
TransMessage.Message = utilityHelper.ReadGlobalMessage("Store", "Error");
EventLogHandler.WriteLog(ex);
}
return(Json(TransMessage, JsonRequestBehavior.DenyGet));
}
public ExceptionReportModal Save(ExceptionReportModal model)
{
model.TransMessage = new TransactionMessage();
model.TransMessage.Status = MessageStatus.Error;
try
{
#region check duplicate
//if (UnitofWork.RepoExceptionReport.Where(x => x.ExceptionID == model.ExceptionID).Count() > 0)
//{
// model.TransMessage.Message = utilityHelper.ReadGlobalMessage("ExceptionReport", "Duplicate");
// return model;
//}
#endregion
ExceptionReport dbExceptionReport = UnitofWork.RepoExceptionReport.Where(x => x.ExceptionID == model.ExceptionID).FirstOrDefault();
bool isSave = false;
if (dbExceptionReport == null)
{
#region Save
dbExceptionReport = new ExceptionReport();
UnitofWork.RepoExceptionReport.Add(dbExceptionReport);
model.TransMessage.Message = utilityHelper.ReadGlobalMessage("ExceptionReport", "Save");
isSave = true;
#endregion
}
else
{
#region Update
model.TransMessage.Message = utilityHelper.ReadGlobalMessage("ExceptionReport", "Update");
#endregion
}
#region Set Value
dbExceptionReport.StoreId = model.StoreId;
dbExceptionReport.MonthId = model.MonthId;
dbExceptionReport.Description = model.Description;
dbExceptionReport.CreatedOn = model.CreatedOn;
#endregion
UnitofWork.Commit();
model.ExceptionID = dbExceptionReport.ExceptionID;
model.TransMessage.Status = MessageStatus.Success;
}
catch (Exception ex)
{
EventLogHandler.WriteLog(ex);
}
return(model);
}
/// <summary>
/// to save or update Page
/// </summary>
/// <param name="model">UsersModel</param>
/// <returns>UsersModel</returns>
public CouponModel Save(CouponModel model)
{
model.TransMessage = new TransactionMessage();
model.TransMessage.Status = MessageStatus.Error;
try
{
#region check duplicate
if (UnitofWork.RepoCoupon.Where(x => x.CouponText == model.CouponText && x.CouponID != model.CouponID).Count() > 0)
{
model.TransMessage.Message = utilityHelper.ReadGlobalMessage("Coupon", "Duplicate");
return(model);
}
#endregion
Coupon dbCoupon = UnitofWork.RepoCoupon.Where(x => x.CouponID == model.CouponID).FirstOrDefault();
bool isSave = false;
if (dbCoupon == null)
{
#region Save
dbCoupon = new Coupon();
UnitofWork.RepoCoupon.Add(dbCoupon);
model.TransMessage.Message = utilityHelper.ReadGlobalMessage("Coupon", "Save");
isSave = true;
#endregion
}
else
{
#region Update
model.TransMessage.Message = utilityHelper.ReadGlobalMessage("Coupon", "Update");
#endregion
}
#region Set Value
dbCoupon.CouponText = model.CouponText;
dbCoupon.IsActive = model.IsActive;
#endregion
UnitofWork.Commit();
model.CouponID = dbCoupon.CouponID;
model.TransMessage.Status = MessageStatus.Success;
}
catch (Exception ex)
{
EventLogHandler.WriteLog(ex);
}
return(model);
}
/// <summary>
/// to delete page
/// </summary>
/// <param name="encryptedId">encrypted page id</param>
/// <returns></returns>
public TransactionMessage Delete(string encryptedId)
{
TransactionMessage model = new TransactionMessage();
model.Status = MessageStatus.Error;
model.Message = utilityHelper.ReadGlobalMessage("Coupon", "InvalidRequest");
try
{
if (encryptedId.IsValidEncryptedID())
{
int ID = Convert.ToInt32(encryptedId.ToDecrypt());
var item = UnitofWork.RepoCoupon.Where(x => x.CouponID == ID).FirstOrDefault();
//UnitofWork.RepoCoupon.Delete(item);
if (item != null)
{
item.IsActive = false;
UnitofWork.Commit();
model.Message = utilityHelper.ReadGlobalMessage("Coupon", "Delete");
model.Status = MessageStatus.Success;
#region reference count
//int refCount = UnitofWork.RepoStoreAdChoice.Where(x => x.CouponID == ID).Count();
//if (item != null)
//{
// refCount += item.AdMonths.Count();
// if (refCount > 0)
// {
// model.Message = utilityHelper.ReadGlobalMessage("Coupon", "NotDelete");
// }
// else
// {
// UnitofWork.RepoCoupon.Delete(item);
// UnitofWork.Commit();
// model.Message = utilityHelper.ReadGlobalMessage("Coupon", "Delete");
// model.Status = MessageStatus.Success;
// }
//}
#endregion
}
}
}
catch (Exception ex)
{
EventLogHandler.WriteLog(ex);
}
return(model);
}
/// <summary>
/// to save or update Page
/// </summary>
/// <param name="model">UsersModel</param>
/// <returns>UsersModel</returns>
public MarketModel Save(MarketModel model)
{
model.TransMessage = new TransactionMessage();
model.TransMessage.Status = MessageStatus.Error;
try
{
//check duplicate
if (UnitofWork.RepoMarket.Where(x => x.Name.ToLower() == model.Name.ToLower() && x.MarketID != model.MarketId).Count() > 0)
{
model.TransMessage.Message = utilityHelper.ReadGlobalMessage("ManageMarket", "Duplicate");
return(model);
}
Data.Market dbMarket = UnitofWork.RepoMarket.Where(x => x.MarketID == model.MarketId).FirstOrDefault();
bool isSave = false;
//user table
if (dbMarket == null)
{
#region Save
dbMarket = new Data.Market();
UnitofWork.RepoMarket.Add(dbMarket);
model.TransMessage.Message = utilityHelper.ReadGlobalMessage("ManageMarket", "Save");
isSave = true;
#endregion
}
else
{
#region Update
model.TransMessage.Message = utilityHelper.ReadGlobalMessage("ManageMarket", "Update");
#endregion
}
#region Set Value
dbMarket.Name = model.Name;
#endregion
UnitofWork.Commit();
model.MarketId = dbMarket.MarketID;
model.EncryptedID = dbMarket.MarketID.ToString();
model.TransMessage.Status = MessageStatus.Success;
}
catch (Exception ex)
{
EventLogHandler.WriteLog(ex);
}
return(model);
}
/// <summary>
/// to save or update Page
/// </summary>
/// <param name="model">UsersModel</param>
/// <returns>UsersModel</returns>
public UserStoreModel Save(UserStoreModel model)
{
model.TransMessage = new TransactionMessage();
model.TransMessage.Status = MessageStatus.Error;
try
{
#region check duplicate
if (UnitofWork.RepoUserStore.Where(x => x.StoreID == model.StoreID && x.UserID == model.UserID).Count() > 0)
{
model.TransMessage.Message = utilityHelper.ReadGlobalMessage("ManageStoreOption", "Duplicate");
return(model);
}
#endregion
UserStore dbuserStore = UnitofWork.RepoUserStore.Where(x => x.UserStoreID == model.UserStoreID).FirstOrDefault();
bool isSave = false;
if (dbuserStore == null)
{
#region Save
dbuserStore = new UserStore();
UnitofWork.RepoUserStore.Add(dbuserStore);
model.TransMessage.Message = utilityHelper.ReadGlobalMessage("ManageStoreOption", "Save");
isSave = true;
#endregion
}
else
{
#region Update
model.TransMessage.Message = utilityHelper.ReadGlobalMessage("ManageStoreOption", "Update");
#endregion
}
#region Set Value
dbuserStore.UserID = model.UserID;
dbuserStore.StoreID = model.StoreID;
#endregion
UnitofWork.Commit();
model.TransMessage.Status = MessageStatus.Success;
}
catch (Exception ex)
{
EventLogHandler.WriteLog(ex);
}
return(model);
}
/// <summary>
/// to save or update Page
/// </summary>
/// <param name="model">UsersModel</param>
/// <returns>UsersModel</returns>
public StoreOptionModel Save(StoreOptionModel model)
{
model.TransMessage = new TransactionMessage();
model.TransMessage.Status = MessageStatus.Error;
try
{
#region check duplicate
if (UnitofWork.RepoAllowedStoreOption.Where(x => x.StoreID == model.StoreId && x.AdOptionID == model.OptionId && x.AllowedStoreOptionID != model.AllowedStoreOptionId).Count() > 0)
{
model.TransMessage.Message = utilityHelper.ReadGlobalMessage("ManageStoreOption", "Duplicate");
return(model);
}
#endregion
AllowedStoreOption dbAllowedOption = UnitofWork.RepoAllowedStoreOption.Where(x => x.AllowedStoreOptionID == model.AllowedStoreOptionId).FirstOrDefault();
bool isSave = false;
if (dbAllowedOption == null)
{
#region Save
dbAllowedOption = new AllowedStoreOption();
UnitofWork.RepoAllowedStoreOption.Add(dbAllowedOption);
model.TransMessage.Message = utilityHelper.ReadGlobalMessage("ManageStoreOption", "Save");
isSave = true;
#endregion
}
else
{
#region Update
model.TransMessage.Message = utilityHelper.ReadGlobalMessage("ManageStoreOption", "Update");
#endregion
}
#region Set Value
dbAllowedOption.AdOptionID = model.OptionId;
dbAllowedOption.StoreID = model.StoreId;
#endregion
UnitofWork.Commit();
model.TransMessage.Status = MessageStatus.Success;
}
catch (Exception ex)
{
EventLogHandler.WriteLog(ex);
}
return(model);
}
/// <summary>
/// to delete page
/// </summary>
/// <param name="encryptedId">encrypted page id</param>
/// <returns></returns>
public TransactionMessage DeleteCouponAdMonth(string encryptedId, string monthId)
{
TransactionMessage model = new TransactionMessage();
model.Status = MessageStatus.Error;
model.Message = utilityHelper.ReadGlobalMessage("ManageCouponAdMonth", "InvalidRequest");
try
{
if (encryptedId.IsValidEncryptedID())
{
int _couponId = Convert.ToInt32(encryptedId.ToDecrypt());
int _monthId = Convert.ToInt32(monthId);
using (dbPetSupplies_8517 db = new dbPetSupplies_8517())
{
var item = db.Coupons.Where(x => x.CouponID == _couponId && x.AdMonths1.Where(a => a.AdMonthID == _monthId).Count() > 0).FirstOrDefault();
Coupon dbCoupon = db.Coupons.Where(x => x.CouponID == _couponId).FirstOrDefault();
AdMonth dbAdMonth = db.AdMonths.Where(x => x.AdMonthID == _monthId).FirstOrDefault();
var associated = db.StoreAdChoices.Where(x => x.AdMonthID == _monthId && x.CouponID == _couponId).Count() > 0 ? true : false;
if (associated)
{
model.Message = utilityHelper.ReadGlobalMessage("ManageCouponAdMonth", "AssociatedCoupon");
model.Status = MessageStatus.Error;
}
else if (dbAdMonth.AdCoupnID == _couponId)
{
model.Message = utilityHelper.ReadGlobalMessage("ManageCouponAdMonth", "DefaultCoupon");
model.Status = MessageStatus.Error;
}
else
{
if (item != null && dbCoupon != null && dbAdMonth != null)
{
dbAdMonth.Coupons.Remove(dbCoupon);
db.SaveChanges();
model.Message = utilityHelper.ReadGlobalMessage("ManageCouponAdMonth", "Delete");
model.Status = MessageStatus.Success;
}
}
}
}
}
catch (Exception ex)
{
EventLogHandler.WriteLog(ex);
}
return(model);
}
/// <summary>
/// to get page full detail
/// </summary>
/// <param name="encryptedId"></param>
/// <returns></returns>
public AdMonthModel GetDetail(string encryptedId)
{
AdMonthModel model = new AdMonthModel();
try
{
int AdMonthId = Convert.ToInt32(encryptedId);
#region get detail
model = UnitofWork.RepoAdMonth.Where(x => x.AdMonthID == AdMonthId).Select(x => new AdMonthModel
{
AdMonthID = x.AdMonthID,
AdOptionID = x.AdOptionID ?? 0,
AdCouponID = x.AdCoupnID ?? 0,
AdCouponName = x.Coupon != null ? x.Coupon.CouponText ?? "" : "",
AdOptionName = x.ADOption != null ? x.ADOption.ADOptionName ?? "" : "",
CorpInHomeDate = x.CorpInHomeDate ?? new DateTime(),
DropNumber = x.DropNumber ?? 0,
//InHomeEnd = x.InHomeEnd ?? new DateTime(),
//InHomeStart = x.InHomeStart ?? new DateTime(),
LockOutEndDate = x.LockOutEndDate ?? new DateTime(),
LockOutStartDate = x.LockOutStartDate ?? new DateTime(),
Month = x.Month ?? 0,
PetpartnerInfo = x.PetpartnerInfo ?? "",
Year = x.Year ?? 0,
CorpPlanText = x.CorpPlanText,
}).FirstOrDefault();
#endregion
if (model != null)
{
model.EncryptedID = model.AdMonthID.ToString().ToEnctypt();
}
else
{
model = new AdMonthModel();
}
}
catch (Exception ex)
{
EventLogHandler.WriteLog(ex);
}
return(model);
}
/// <summary>
/// to save or update Page
/// </summary>
/// <param name="model">UsersModel</param>
/// <returns>UsersModel</returns>
public CouponAdMonthModel CouponAdMonthSave(CouponAdMonthModel model)
{
model.TransMessage = new TransactionMessage();
model.TransMessage.Status = MessageStatus.Error;
try
{
using (dbPetSupplies_8517 db = new dbPetSupplies_8517())
{
#region check duplicate
if (db.Coupons.Where(x => x.CouponID == model.CouponID && x.AdMonths1.Where(a => a.AdMonthID == model.MonthId).Count() > 0).Count() > 0)
{
model.TransMessage.Message = utilityHelper.ReadGlobalMessage("ManageCouponAdMonth", "Duplicate");
return(model);
}
#endregion
Coupon dbCoupon = db.Coupons.Where(x => x.CouponID == model.CouponID).FirstOrDefault();
AdMonth dbAdMonth = db.AdMonths.Where(x => x.AdMonthID == model.MonthId).FirstOrDefault();
if (dbCoupon != null && dbAdMonth != null)
{
//int refCount = UnitofWork.RepoStoreAdChoice.Where(x => x.CouponID == model.CouponID).Count();
//if (refCount == 0)
//{
dbAdMonth.Coupons.Add(dbCoupon);
db.SaveChanges();
model.TransMessage.Message = utilityHelper.ReadGlobalMessage("ManageCouponAdMonth", "Save");
model.TransMessage.Status = MessageStatus.Success;
//}
//else
//{
// model.TransMessage.Message = utilityHelper.ReadGlobalMessage("ManageCouponAdMonth", "NotAssign");
//}
}
}
}
catch (Exception ex)
{
EventLogHandler.WriteLog(ex);
}
return(model);
}
// Save all store with a single AdOption
public AllowedStoreOptionModel Save(AllowedStoreOptionModel model)
{
model.TransMessage = new TransactionMessage();
model.TransMessage.Status = MessageStatus.Error;
try
{
if (model.AdOptionID > 0 && model.Detail != null && model.Detail.Count() > 0)
{
#region Delete Existing Entry
var dbList = UnitofWork.RepoAllowedStoreOption.Where(x => x.AdOptionID == model.AdOptionID).ToList();
foreach (var item in dbList)
{
UnitofWork.RepoAllowedStoreOption.Delete(item);
}
UnitofWork.Commit();
#endregion
foreach (var item in model.Detail)
{
if (item.IsSelect && item.StoreID > 0)
{
UnitofWork.RepoAllowedStoreOption.Add(new AllowedStoreOption()
{
AdOptionID = model.AdOptionID,
StoreID = item.StoreID,
});
}
}
UnitofWork.Commit();
model.TransMessage.Message = utilityHelper.ReadGlobalMessage("ManageStoreOption", "Save");
model.TransMessage.Status = MessageStatus.Success;
}
}
catch (Exception ex)
{
EventLogHandler.WriteLog(ex);
}
return(model);
}
/// <summary>
/// to delete page
/// </summary>
/// <param name="encryptedId">encrypted page id</param>
/// <returns></returns>
public TransactionMessage Delete(string encryptedId)
{
TransactionMessage model = new TransactionMessage();
model.Status = MessageStatus.Error;
model.Message = utilityHelper.ReadGlobalMessage("AdMonth", "InvalidRequest");
try
{
if (encryptedId.IsValidEncryptedID())
{
int ID = Convert.ToInt32(encryptedId.ToDecrypt());
var item = UnitofWork.RepoAdMonth.Where(x => x.AdMonthID == ID).FirstOrDefault();
//reference count
int refCount = 0;
refCount = UnitofWork.RepoStoreAdChoice.Where(x => x.AdMonthID == ID).Count();
refCount += UnitofWork.RepoStoreAdChoiceHistory.Where(x => x.AdMonthID == ID).Count();
if (item != null)
{
if (refCount > 0 || item.Coupons.Count() > 0 || item.Documents.Count() > 0)
{
model.Message = utilityHelper.ReadGlobalMessage("AdMonth", "NotDelete");
}
else
{
UnitofWork.RepoAdMonth.Delete(item);
UnitofWork.Commit();
model.Message = utilityHelper.ReadGlobalMessage("AdMonth", "Delete");
model.Status = MessageStatus.Success;
}
}
}
}
catch (Exception ex)
{
EventLogHandler.WriteLog(ex);
}
return(model);
}
/// <summary>
/// to delete page
/// </summary>
/// <param name="encryptedId">encrypted page id</param>
/// <returns></returns>
public TransactionMessage Delete(string encryptedId)
{
TransactionMessage model = new TransactionMessage();
model.Status = MessageStatus.Error;
model.Message = utilityHelper.ReadGlobalMessage("ManageMarket", "InvalidRequest");
try
{
if (encryptedId.IsValidEncryptedID())
{
int Id = Convert.ToInt32(encryptedId.ToDecrypt());
var item = UnitofWork.RepoMarket.Where(x => x.MarketID == Id).FirstOrDefault();
var refCount = UnitofWork.RepoStore.Where(x => x.MarketID == Id).Count();
if (refCount > 0)
{
model.Message = utilityHelper.ReadGlobalMessage("ManageMarket", "NotDelete");
return(model);
}
if (item != null && refCount == 0)
{
UnitofWork.RepoMarket.Delete(item);
UnitofWork.Commit();
model.Message = utilityHelper.ReadGlobalMessage("ManageMarket", "Delete");
model.Status = MessageStatus.Success;
}
else
{
// model.Message = utilityHelper.ReadGlobalMessage("ManageMarket", "Delete");
}
}
}
catch (Exception ex)
{
EventLogHandler.WriteLog(ex);
}
return(model);
}
/// <summary>
/// to save or update Page
/// </summary>
/// <param name="model">UsersModel</param>
/// <returns>UsersModel</returns>
public DocumentModel Save(DocumentModel model)
{
model.TransMessage = new TransactionMessage();
model.TransMessage.Status = MessageStatus.Error;
try
{
#region check duplicate
if (UnitofWork.RepoDocument.Where(x => x.FileName == model.FileName && x.MonthID == model.MonthID).Count() > 0)
{
model.TransMessage.Message = utilityHelper.ReadGlobalMessage("Document", "Duplicate");
return(model);
}
#endregion
bool isSave = false;
#region Save
Document Document = new Document();
Document.FileName = model.FileName;
Document.FilePath = model.FilePath;
Document.MonthID = model.MonthID;
UnitofWork.RepoDocument.Add(Document);
model.TransMessage.Message = utilityHelper.ReadGlobalMessage("Document", "Save");
isSave = true;
#endregion
UnitofWork.Commit();
model.TransMessage.Status = MessageStatus.Success;
}
catch (Exception ex)
{
EventLogHandler.WriteLog(ex);
}
return(model);
}
/// <summary>
/// to save or update Page
/// </summary>
/// <param name="model">UsersModel</param>
/// <returns>UsersModel</returns>
public AdMonthModel Save(AdMonthModel model)
{
model.TransMessage = new TransactionMessage();
model.TransMessage.Status = MessageStatus.Error;
try
{
#region check duplicate
if (UnitofWork.RepoAdMonth.Where(x => x.Year == model.Year && x.Month == model.Month && x.DropNumber == model.DropNumber && x.AdMonthID != model.AdMonthID).Count() > 0)
{
model.TransMessage.Message = utilityHelper.ReadGlobalMessage("AdMonth", "Duplicate");
return(model);
}
#endregion
#region Valid Date and Month
//commented on 5th augest 16
//if (model.LockOutStartDate.Month != model.Month || model.LockOutEndDate.Month != model.Month)
//{
// model.TransMessage.Message = utilityHelper.ReadGlobalMessage("AdMonth", "InvalidDateMonth");
// return model;
//}
#endregion
#region Lock out Start/End Date
if (UnitofWork.RepoAdMonth.Where(x => ((x.LockOutStartDate < model.LockOutStartDate && x.LockOutEndDate > model.LockOutEndDate) || (x.LockOutStartDate >= model.LockOutStartDate && x.LockOutStartDate <= model.LockOutEndDate) || (x.LockOutEndDate >= model.LockOutStartDate && x.LockOutEndDate <= model.LockOutEndDate)) && x.AdMonthID != model.AdMonthID).Count() > 0)
{
model.TransMessage.Message = utilityHelper.ReadGlobalMessage("AdMonth", "Date");
return(model);
}
#endregion
#region Check is Auto pouplated
if (UnitofWork.RepoExceptionReport.Where(x => x.MonthId == model.AdMonthID).Count() > 0)
{
model.TransMessage.Message = utilityHelper.ReadGlobalMessage("AdMonth", "AutoPopulated");
return(model);
}
#endregion
AdMonth dbAdMonth = UnitofWork.RepoAdMonth.Where(x => x.AdMonthID == model.AdMonthID).FirstOrDefault();
bool isSave = false;
if (dbAdMonth == null)
{
#region Save
dbAdMonth = new AdMonth();
UnitofWork.RepoAdMonth.Add(dbAdMonth);
model.TransMessage.Message = utilityHelper.ReadGlobalMessage("AdMonth", "Save");
isSave = true;
#endregion
}
else
{
#region Update
model.TransMessage.Message = utilityHelper.ReadGlobalMessage("AdMonth", "Update");
#endregion
}
#region Set Value
dbAdMonth.AdOptionID = model.AdOptionID;
dbAdMonth.CorpInHomeDate = model.CorpInHomeDate;
//dbAdMonth.InHomeEnd = model.InHomeEnd;
//dbAdMonth.InHomeStart = model.InHomeStart;
dbAdMonth.DropNumber = model.DropNumber;
dbAdMonth.LockOutEndDate = model.LockOutEndDate;
dbAdMonth.LockOutStartDate = model.LockOutStartDate;
dbAdMonth.Month = model.Month;
dbAdMonth.PetpartnerInfo = model.PetpartnerInfo;
dbAdMonth.Year = model.Year;
dbAdMonth.CorpPlanText = model.CorpPlanText;
dbAdMonth.AdCoupnID = model.AdCouponID;
Coupon defaultcoupon = UnitofWork.RepoCoupon.Where(c => c.CouponID == model.AdCouponID).FirstOrDefault();
dbAdMonth.Coupons.Add(defaultcoupon);
#endregion
UnitofWork.Commit();
model.AdMonthID = dbAdMonth.AdMonthID;
model.TransMessage.Status = MessageStatus.Success;
}
catch (Exception ex)
{
EventLogHandler.WriteLog(ex);
}
return(model);
}
void Init()
{
redisConnectionString = Properties.Settings.Default["RedisServers"].ToString();
domain = Properties.Settings.Default["WindowsDomainRegex"].ToString();
usernameFilterRegex = Properties.Settings.Default["UsernameFilterRegex"].ToString();
parseKerberosEvents = Properties.Settings.Default["ParseKerberosEvents"].ToString().ToUpper() == "TRUE";
int.TryParse(Properties.Settings.Default["RedisTTL"].ToString(), out redisTTL);
var os_version = Environment.OSVersion.Version;
if (os_version.Major > 5)
{
if (parseKerberosEvents)
{
throw new Exception(@"Parsing kerberos events is not supported for this OS version yet");
}
username_index = 5;
remote_network_address_index = 18;
}
else
{
username_index = 0;
remote_network_address_index = 13;
remote_network_address_ticket_index = 6;
remote_network_address_tgt_index = 9;
logon_ev_code = (int)EventLogListener.WindowsEventCodes.WIN2K3_LOGON_NETWORK;
krb_tgt_granted_ev_code = (int)EventLogListener.WindowsEventCodes.WIN2K3_KRB_TGT_GRANTED;
krb_service_ticket_granted_ev_code = (int)EventLogListener.WindowsEventCodes.WIN2K3_KRB_SERVICE_TICKET_GRANTED;
}
//Account Logon Event Handler
logonEventsHandler = NetworkLogonEventsHandlerFactory.Build(os_version.Major, domain);
//FILTERS
IEventFilter logon_event_codes_filter = new EventCodeFilter(new long[] { logon_ev_code });
IEventFilter usernameFilter = new NOT_EventFilter(new ReplacementStringFilter(new Dictionary <int, string>()
{
{ username_index, @"^.*\$" }
})); // Exclude machine accounts
logonEventsHandler.RegisterFilter(usernameFilter);
//LOGGERS
logonEventsHandler.RegisterLogger(
new RedisReplacementStringLogger(
redisConnectionString,
remote_network_address_index,
username_index,
0,
true,
redisTTL
)
);
logonEventsHandler.RegisterLogger(
new RedisTimeStampLogger(
redisConnectionString,
new int[] { username_index, remote_network_address_index },
0,
true,
redisTTL
)
);
logonEventsHandler.SetExceptionLogger(logger);
//Kerberos Ticket Request Event Handler
kerberosEventsHandler = NetworkLogonEventsHandlerFactory.Build(os_version.Major, domain, ip2userLib.NetworkLogonEventSources.KERBEROS);
//FILTERS
IEventFilter krb_event_codes_filter = new EventCodeFilter(new long[] { krb_service_ticket_granted_ev_code, krb_tgt_granted_ev_code });
kerberosEventsHandler.RegisterFilter(krb_event_codes_filter);
kerberosEventsHandler.RegisterFilter(usernameFilter);
//LOGGERS
kerberosEventsHandler.RegisterLogger(
new RedisReplacementStringLogger(
redisConnectionString,
remote_network_address_ticket_index,
username_index,
krb_service_ticket_granted_ev_code,
true,
redisTTL
)
);
kerberosEventsHandler.RegisterLogger(
new RedisReplacementStringLogger(
redisConnectionString,
remote_network_address_tgt_index,
username_index,
krb_tgt_granted_ev_code,
true,
redisTTL
)
);
kerberosEventsHandler.SetExceptionLogger(logger);
}
public Task <EventLog> ReadEvent(IActorState actor, string eventid)
{
return(EventLogHandler?.Read(actor, eventid));
}
