/// <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);
}
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>
/// Show the Index Page
/// </summary>
/// <param name="id"></param>
/// <returns>View</returns>
public ActionResult Index(string id)
{
AdMonthModel objadmonth = _admonth.GetDetail(id.ToEnctypt());
ViewBag.MonthId = Convert.ToInt32(id.ToDecrypt());
ViewBag.Month = _common.GetMonthList().Where(a => a.Value == (objadmonth.Month).ToString()).Select(a => a.Text).FirstOrDefault();
ViewBag.Year = objadmonth.Year;
return(View());
}
public ActionResult ManageMissingEntry()
{
AdMonthModel adMonth = _admonth.GetDetailByMonthId();
if (adMonth != null)
{
ViewBag.CurrentMonth = (new DateTime(adMonth.Year, adMonth.Month, 1)).ToString("(MMMM yyyy)");
}
return(View(adMonth));
}
/// <summary>
/// open page where we can Add coupon in month
/// </summary>
/// <param name="id">monthid</param>
/// <returns>View with model</returns>
public ActionResult Add(string id)
{
CouponAdMonthModel model = new CouponAdMonthModel();
AdMonthModel objadmonth = _admonth.GetDetail(id.ToEnctypt());
model.MonthId = Convert.ToInt32(id);
model.Month = _common.GetMonthList().Where(a => a.Value == (objadmonth.Month).ToString()).Select(a => a.Text).FirstOrDefault();
model.Year = objadmonth.Year;
ViewBag.CouponList = _common.GetCouponList();
return(View(model));
}
public ActionResult Add(string id)
{
AdMonthModel model = new AdMonthModel();
if (id != null)
{
model = _AdMonth.GetDetail(id);
}
ViewBag.CouponList = _Common.GetCouponList();
model.MonthList = _Common.GetMonthList();
model.YearList = _Common.GetYearList();
model.AdOptionList = _Common.GetAdOptionList();
return(View(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 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);
}
