public ActionResult ManageBannerCode(BannerCodeModel bannerCodeModel)
{
if (ModelState.IsValid)
{
using (var ctx = new LicenseApplicationContext())
{
BannerCode bannerCode;
if (IsBannerCodeDuplicate(bannerCodeModel.BannerCodeDesc, bannerCodeModel.BannerCodeID))
{
TempData["ErrorMessage"] = "Banner Code already exists in the database.";
return(View(bannerCodeModel));
}
bannerCode = Mapper.Map <BannerCode>(bannerCodeModel);
ctx.BannerCodes.AddOrUpdate(bannerCode);
ctx.SaveChanges();
}
TempData["SuccessMessage"] = "Banner Code saved successfully.";
return(RedirectToAction("BannerCode"));
}
else
{
return(View(bannerCodeModel));
}
}
public JsonResult SaveHAReqDoc(List <HAReqDoc> lstBarReqDoc)
{
try
{
using (var ctx = new LicenseApplicationContext())
{
foreach (var item in lstBarReqDoc)
{
var DocCnt = ctx.HAReqDocs.Where(x => x.RequiredDocID == item.RequiredDocID).Count();
if (DocCnt == 0)
{
HAReqDoc HAReqDoc = new HAReqDoc();
HAReqDoc.HAReqDocID = 0;
HAReqDoc.RequiredDocID = item.RequiredDocID;
ctx.HAReqDocs.AddOrUpdate(HAReqDoc);
ctx.SaveChanges();
}
}
}
TempData["SuccessMessage"] = "Banner Required Documents successfully.";
return(Json(Convert.ToString(1)));
}
catch (Exception)
{
return(Json(Convert.ToString(0)));
}
}
public JsonResult BAReqDoc([ModelBinder(typeof(DataTablesBinder))] IDataTablesRequest requestModel, string BAReqDocDesc)
{
List <TradingLicense.Model.BAReqDocModel> BAReqDoc = new List <Model.BAReqDocModel>();
int totalRecord = 0;
using (var ctx = new LicenseApplicationContext())
{
IQueryable <BAReqDoc> query = ctx.BAReqDocs;
totalRecord = query.Count();
#region Sorting
// Sorting
var sortedColumns = requestModel.Columns.GetSortedColumns();
var orderByString = String.Empty;
foreach (var column in sortedColumns)
{
orderByString += orderByString != String.Empty ? "," : "";
orderByString += (column.Data) +
(column.SortDirection ==
Column.OrderDirection.Ascendant ? " asc" : " desc");
}
query = query.OrderBy(orderByString == string.Empty ? "BAReqDocID asc" : orderByString);
#endregion Sorting
// Paging
query = query.Skip(requestModel.Start).Take(requestModel.Length);
BAReqDoc = Mapper.Map <List <BAReqDocModel> >(query.ToList());
}
return(Json(new DataTablesResponse(requestModel.Draw, BAReqDoc, totalRecord, totalRecord), JsonRequestBehavior.AllowGet));
}
public JsonResult SaveLAReqDoc(List <SALinkReqDoc> lstBarReqDoc)
{
try
{
using (var ctx = new LicenseApplicationContext())
{
foreach (var item in lstBarReqDoc)
{
var DocCnt = ctx.LAReqDocs.Where(x => x.RequiredDocID == item.RequiredDocID).Count();
if (DocCnt == 0)
{
SALinkReqDoc LAReqDoc = new SALinkReqDoc();
LAReqDoc.LAReqDocID = 0;
LAReqDoc.RequiredDocID = item.RequiredDocID;
ctx.LAReqDocs.AddOrUpdate(LAReqDoc);
ctx.SaveChanges();
}
}
}
TempData["SuccessMessage"] = "Pilihan dokumen wajib bagi Lesen Minuman Keras telah berjaya disimpan";
return(Json(Convert.ToString(1)));
}
catch (Exception)
{
return(Json(Convert.ToString(0)));
}
}
public ActionResult ForgotPassword(string emailValue, int Type)
{
try
{
using (var ctx = new LicenseApplicationContext())
{
string link = string.Empty;
var user = ctx.Users.Where(a => a.Email == emailValue).FirstOrDefault();
if (user != null && user.UsersID > 0)
{
string resetPasswordParameter = string.Format("{0}#{1}#{2}", SystemEnum.RoleType.User.GetHashCode(), user.UsersID, DateTime.Now.AddMinutes(ProjectConfiguration.ResetPasswordExpireTime).ToString(ProjectConfiguration.EmailDateTimeFormat));
string encryptResetPasswordParameter = EncryptionDecryption.GetEncrypt(resetPasswordParameter);
string encryptResetPasswordUrl = string.Format("{0}?q={1}", ProjectConfiguration.SiteUrlBase + TradingLicense.Web.Pages.Controllers.Account + "/" + Actions.ResetPassword, encryptResetPasswordParameter);
if (UserMail.SendForgotPassword(user.Email, user.Username, encryptResetPasswordUrl))
{
return(Json(new object[] { Convert.ToInt32(MessageType.success), MessageType.success.ToString(), Messages.Mailsend }, JsonRequestBehavior.AllowGet));
}
else
{
return(Json(new object[] { Convert.ToInt32(MessageType.danger), MessageType.danger.ToString(), Messages.ContactToAdmin }, JsonRequestBehavior.AllowGet));
}
}
else
{
return(Json(new object[] { Convert.ToInt32(MessageType.danger), MessageType.danger.ToString(), Messages.InvalidEmail }, JsonRequestBehavior.AllowGet));
}
}
}
catch (Exception ex)
{
// ErrorLogHelper.Log(ex);
return(Json(new object[] { Convert.ToInt32(MessageType.danger), MessageType.danger.ToString(), Messages.ContactToAdmin }, JsonRequestBehavior.AllowGet));
}
}
public JsonResult SaveBAReqDoc(List <BAReqDoc> lstBarReqDoc)
{
try
{
using (var ctx = new LicenseApplicationContext())
{
List <BAReqDoc> lstToDelete = ctx.BAReqDocs.ToList().Except(lstBarReqDoc).ToList();
foreach (var v in lstToDelete)
{
ctx.BAReqDocs.Remove(v);
ctx.SaveChanges();
}
foreach (var item in lstBarReqDoc)
{
var DocCnt = ctx.BAReqDocs.Where(x => x.RequiredDocID == item.RequiredDocID).Count();
if (DocCnt == 0)
{
BAReqDoc BAReqDoc = new BAReqDoc();
BAReqDoc.BAReqDocID = 0;
BAReqDoc.RequiredDocID = item.RequiredDocID;
ctx.BAReqDocs.AddOrUpdate(BAReqDoc);
ctx.SaveChanges();
}
}
}
TempData["SuccessMessage"] = "Banner Required Documents successfully.";
return(Json(Convert.ToString(1)));
}
catch (Exception)
{
return(Json(Convert.ToString(0)));
}
}
/// <summary>
/// Download
/// </summary>
/// <param name="attechmentID"></param>
/// /// <param name="liquorID"></param>
/// <returns></returns>
public FileResult Download(int?attechmentID, int?liquorID)
{
using (var ctx = new LicenseApplicationContext())
{
var attechment = ctx.Attachments.Where(a => a.AttachmentID == attechmentID).FirstOrDefault();
var folder = Server.MapPath(Infrastructure.ProjectConfiguration.AttachmentDocument);
try
{
try
{
if (attechment != null && attechment.AttachmentID > 0)
{
var path = Path.Combine(folder, attechment.FileName);
return(File(path, System.Net.Mime.MediaTypeNames.Application.Octet, attechment.FileName));
}
else
{
return(null);
}
}
catch
{
}
}
catch { }
return(null);
}
}
public JsonResult FillIndividual(string query)
{
using (var ctx = new LicenseApplicationContext())
{
var Individual = ctx.Individuals.Where(t => t.FullName.ToLower().Contains(query.ToLower())).Select(x => new { IndividualID = x.IndividualID, FullName = x.FullName }).ToList();
return(Json(Individual, JsonRequestBehavior.AllowGet));
}
}
public JsonResult FillIndividual(string query)
{
using (var ctx = new LicenseApplicationContext())
{
var individual = ctx.Individuals.Where(t => t.MykadNo.ToLower().Contains(query.ToLower())).Select(x => new { id = x.IndividualID, text = x.MykadNo }).ToList();
return(Json(individual, JsonRequestBehavior.AllowGet));
}
}
public JsonResult FillLiquorCode(string query)
{
using (var ctx = new LicenseApplicationContext())
{
var liquorCode = ctx.LiquorCodes.Where(t => t.LiquorCodeDesc.ToLower().Contains(query.ToLower())).Select(x => new { id = x.LiquorCodeID, text = x.LiquorCodeDesc }).ToList();
return(Json(liquorCode, JsonRequestBehavior.AllowGet));
}
}
/// <summary>
/// Get BannerApplication Data by ID
/// </summary>
/// <param name="Id"></param>
/// <returns></returns>
public ActionResult ManageBannerApplication(int?Id)
{
List <TradingLicense.Model.BAReqDocModel> BAReqDoc = new List <Model.BAReqDocModel>();
BannerApplicationModel bannerApplicationModel = new BannerApplicationModel();
List <BannerObject> BannerObjectModel = new List <BannerObject>();
List <BALinkReqDoc> BALinkReqDoc = new List <BALinkReqDoc>();
List <Attchments> Attchments = new List <Attchments>();
using (var ctx = new LicenseApplicationContext())
{
IQueryable <BAReqDoc> query = ctx.BAReqDocs;
BAReqDoc = Mapper.Map <List <BAReqDocModel> >(query.ToList());
ViewBag.bannerDocList = ctx.BAReqDocs.ToList();
var qry = ctx.Individuals.Where(e => e.IndividualID == 1);
if (Id != null && Id > 0)
{
BannerObjectModel = db.BannerObjects.Include("BannerCode")
.Include("Location")
.Include("Zone")
.Where(x => x.BannerApplicationID == Id).ToList();
var Docs = (from d in db.BALinkReqDocs
join f in db.Attachments
on d.AttachmentID equals f.AttachmentID
where d.BannerApplicationID == Id
select new
{
AttachmentID = d.AttachmentID,
RequiredDocID = d.RequiredDocID,
FileName = f.FileName
}).ToList();
foreach (var item in Docs)
{
Attchments Atch = new Attchments();
Atch.Id = Convert.ToInt32(item.AttachmentID);
Atch.RequiredDocID = item.RequiredDocID;
Atch.filename = item.FileName;
Attchments.Add(Atch);
}
int bannerApplicationID = Convert.ToInt32(Id);
var bannerApplication = ctx.BannerApplications.Where(a => a.BannerApplicationID == bannerApplicationID).FirstOrDefault();
bannerApplicationModel.BannerApplicationID = bannerApplication.BannerApplicationID;
Int32?CompId = bannerApplication.CompanyID;
bannerApplicationModel.CompanyID = Convert.ToInt32(CompId);
bannerApplicationModel.IndividualID = bannerApplication.IndividualID;
//bannerApplicationModel = Mapper.Map<BannerApplicationModel>(bannerApplication);
}
}
ViewBag.BALinkReqDoc = Attchments;
ViewBag.BannerObjects = BannerObjectModel;
return(View(bannerApplicationModel));
}
/// <summary>
/// Check Duplicate
/// </summary>
/// <param name="name"></param>
/// <param name="id"></param>
/// <returns></returns>
private bool IsBannerCodeDuplicate(string name, int?id = null)
{
using (var ctx = new LicenseApplicationContext())
{
var existObj = id != null?
ctx.BannerCodes.FirstOrDefault(
c => c.BannerCodeID != id && c.BannerCodeDesc.ToLower() == name.ToLower())
: ctx.BannerCodes.FirstOrDefault(
c => c.BannerCodeDesc.ToLower() == name.ToLower());
return(existObj != null);
}
}
public JsonResult BannerApplicationsByIndividual([ModelBinder(typeof(DataTablesBinder))] IDataTablesRequest requestModel, int?individualId)
{
List <Model.BannerApplicationModel> bannerApplication = new List <Model.BannerApplicationModel>();
int totalRecord = 0;
try
{
using (var ctx = new LicenseApplicationContext())
{
IQueryable <BannerApplication> query = ctx.BannerApplications
.Include("AppStatus")
.Include("Company")
.Include("Individual")
.Where(ba => ba.IndividualID == individualId);
totalRecord = query.Count();
#region Sorting
// Sorting
var sortedColumns = requestModel.Columns.GetSortedColumns();
var orderByString = String.Empty;
foreach (var column in sortedColumns)
{
orderByString += orderByString != String.Empty ? "," : "";
orderByString += (column.Data) +
(column.SortDirection ==
Column.OrderDirection.Ascendant ? " asc" : " desc");
}
query = query.OrderBy(orderByString == string.Empty ? "BannerApplicationID asc" : orderByString);
#endregion Sorting
// Paging
query = query.Skip(requestModel.Start).Take(requestModel.Length);
var Dtls = db.BannerApplications
.Include("AppStatus")
.Include("Company")
.Include("Individual")
.Where(ba => ba.IndividualID == individualId)
.OrderBy(m => m.BannerApplicationID).ToList();
/*var Dtls = query.ToList();*/
return(Json(new DataTablesResponse(requestModel.Draw, Dtls.ToList(), totalRecord, totalRecord), JsonRequestBehavior.AllowGet));
}
}
catch (Exception ex)
{
return(null);
}
}
public JsonResult BannerCode([ModelBinder(typeof(DataTablesBinder))] IDataTablesRequest requestModel, string bannerCodeDesc)
{
List <TradingLicense.Model.BannerCodeModel> bannerCode = new List <Model.BannerCodeModel>();
int totalRecord = 0;
int filteredRecord = 0;
using (var ctx = new LicenseApplicationContext())
{
IQueryable <BannerCode> query = ctx.BannerCodes;
totalRecord = query.Count();
#region Filtering
// Apply filters for searching
if (!string.IsNullOrWhiteSpace(bannerCodeDesc))
{
query = query.Where(p =>
p.BannerCodeDesc.Contains(bannerCodeDesc)
);
}
filteredRecord = query.Count();
#endregion Filtering
#region Sorting
// Sorting
var sortedColumns = requestModel.Columns.GetSortedColumns();
var orderByString = String.Empty;
foreach (var column in sortedColumns)
{
orderByString += orderByString != String.Empty ? "," : "";
orderByString += (column.Data) +
(column.SortDirection ==
Column.OrderDirection.Ascendant ? " asc" : " desc");
}
query = query.OrderBy(orderByString == string.Empty ? "BannerCodeID asc" : orderByString);
#endregion Sorting
// Paging
query = query.Skip(requestModel.Start).Take(requestModel.Length);
bannerCode = Mapper.Map <List <BannerCodeModel> >(query.ToList());
}
return(Json(new DataTablesResponse(requestModel.Draw, bannerCode, totalRecord, totalRecord), JsonRequestBehavior.AllowGet));
}
public JsonResult liquorCode([ModelBinder(typeof(DataTablesBinder))] IDataTablesRequest requestModel, string LiquorCodeids)
{
List <TradingLicense.Model.LiquorCodeModel> LiquorCode = new List <Model.LiquorCodeModel>();
int totalRecord = 0;
using (var ctx = new LicenseApplicationContext())
{
string[] ids = null;
if (!string.IsNullOrWhiteSpace(LiquorCodeids))
{
ids = LiquorCodeids.Split(',');
}
List <int> LiquorCodelist = new List <int>();
foreach (string id in ids)
{
int LiquorCodeID = Convert.ToInt32(id);
LiquorCodelist.Add(LiquorCodeID);
}
IQueryable <LiquorCode> query = ctx.LiquorCodes.Where(r => LiquorCodelist.Contains(r.LiquorCodeID));
#region Sorting
// Sorting
var sortedColumns = requestModel.Columns.GetSortedColumns();
var orderByString = String.Empty;
foreach (var column in sortedColumns)
{
orderByString += orderByString != String.Empty ? "," : "";
orderByString += (column.Data) +
(column.SortDirection ==
Column.OrderDirection.Ascendant ? " asc" : " desc");
}
var result = Mapper.Map <List <LiquorCodeModel> >(query.ToList());
result = result.OrderBy(orderByString == string.Empty ? "LiquorCodeID asc" : orderByString).ToList();
totalRecord = result.Count();
#endregion Sorting
LiquorCode = result;
}
return(Json(new DataTablesResponse(requestModel.Draw, LiquorCode, totalRecord, totalRecord), JsonRequestBehavior.AllowGet));
}
/// <summary>
/// Get SAReqDoc Data by ID
/// </summary>
/// <param name="Id"></param>
/// <returns></returns>
public ActionResult ManageSAReqDoc(int?Id)
{
SAReqDocModel SAReqDocModel = new SAReqDocModel();
if (Id != null && Id > 0)
{
using (var ctx = new LicenseApplicationContext())
{
int SAReqDocID = Convert.ToInt32(Id);
var SAReqDoc = ctx.SAReqDocs.Where(a => a.SAReqDocID == SAReqDocID).FirstOrDefault();
SAReqDocModel = Mapper.Map <SAReqDocModel>(SAReqDoc);
}
}
return(View(SAReqDocModel));
}
/// <summary>
/// Get HAReqDoc Data by ID
/// </summary>
/// <param name="Id"></param>
/// <returns></returns>
public ActionResult ManageHAReqDoc(int?Id)
{
HAReqDocModel HAReqDocModel = new HAReqDocModel();
if (Id != null && Id > 0)
{
using (var ctx = new LicenseApplicationContext())
{
int HAReqDocID = Convert.ToInt32(Id);
var HAReqDoc = ctx.HAReqDocs.Where(a => a.HAReqDocID == HAReqDocID).FirstOrDefault();
HAReqDocModel = Mapper.Map <HAReqDocModel>(HAReqDoc);
}
}
return(View(HAReqDocModel));
}
/// <summary>
/// Get StallCode Data by ID
/// </summary>
/// <param name="Id"></param>
/// <returns></returns>
public ActionResult ManageStallCode(int?Id)
{
StallCodeModel stallCodeModel = new StallCodeModel();
stallCodeModel.Active = true;
if (Id != null && Id > 0)
{
using (var ctx = new LicenseApplicationContext())
{
int stallCodeID = Convert.ToInt32(Id);
var stallCode = ctx.StallCodes.Where(a => a.StallCodeID == stallCodeID).FirstOrDefault();
stallCodeModel = Mapper.Map <StallCodeModel>(stallCode);
}
}
return(View(stallCodeModel));
}
/// <summary>
/// Get LiquorCode Data by ID
/// </summary>
/// <param name="Id"></param>
/// <returns></returns>
public ActionResult ManageLiquorCode(int?Id)
{
LiquorCodeModel liquorCodeModel = new LiquorCodeModel();
liquorCodeModel.Active = true;
if (Id != null && Id > 0)
{
using (var ctx = new LicenseApplicationContext())
{
int liquorCodeID = Convert.ToInt32(Id);
var liquorCode = ctx.LiquorCodes.Where(a => a.LiquorCodeID == liquorCodeID).FirstOrDefault();
liquorCodeModel = Mapper.Map <LiquorCodeModel>(liquorCode);
}
}
return(View(liquorCodeModel));
}
/// <summary>
/// Get BannerCode Data by ID
/// </summary>
/// <param name="Id"></param>
/// <returns></returns>
public ActionResult ManageBannerCode(int?Id)
{
BannerCodeModel bannerCodeModel = new BannerCodeModel();
bannerCodeModel.Active = true;
if (Id != null && Id > 0)
{
using (var ctx = new LicenseApplicationContext())
{
int bannerCodeID = Convert.ToInt32(Id);
var bannerCode = ctx.BannerCodes.Where(a => a.BannerCodeID == bannerCodeID).FirstOrDefault();
bannerCodeModel = Mapper.Map <BannerCodeModel>(bannerCode);
}
}
return(View(bannerCodeModel));
}
/// <summary>
/// Get HawkerCode Data by ID
/// </summary>
/// <param name="Id"></param>
/// <returns></returns>
public ActionResult ManageHawkerCode(int?Id)
{
HawkerCodeModel hawkerCodeModel = new HawkerCodeModel();
hawkerCodeModel.Active = true;
if (Id != null && Id > 0)
{
using (var ctx = new LicenseApplicationContext())
{
int hawkerCodeID = Convert.ToInt32(Id);
var hawkerCode = ctx.HawkerCodes.Where(a => a.HawkerCodeID == hawkerCodeID).FirstOrDefault();
hawkerCodeModel = Mapper.Map <HawkerCodeModel>(hawkerCode);
}
}
return(View(hawkerCodeModel));
}
public ActionResult UploadDocument(HttpPostedFileBase DocumentFile)
{
try
{
using (var ctx = new LicenseApplicationContext())
{
if (DocumentFile != null)
{
var file = DocumentFile;
if (file != null && file.ContentLength > 0)
{
var liquorvalue = Request["LiquorApplicationID"];
var reqDocvalue = Request["reqDocid"];
var addDocvalue = Request["addDocid"];
var isReqvalue = Request["isReqDoc"];
int liquorApplicationID;
if (int.TryParse(liquorvalue, out liquorApplicationID) && liquorApplicationID > 0)
{
int requiredDocID;
int.TryParse(reqDocvalue, out requiredDocID);
int additionalDocID;
int.TryParse(addDocvalue, out additionalDocID);
}
else
{
return(Json(new { status = "2", message = "Data Missing" }, JsonRequestBehavior.AllowGet));
}
}
else
{
return(Json(new { status = "2", message = "Please select File" }, JsonRequestBehavior.AllowGet));
}
}
return(Json(new { status = "2", message = "Please select File" }, JsonRequestBehavior.AllowGet));
}
}
catch (Exception ex)
{
return(Json(new { status = "3", message = "Something went wrong, Please try again" }, JsonRequestBehavior.AllowGet));
}
}
public ActionResult DeleteBAReqDoc(int id)
{
try
{
var BAReqDoc = new TradingLicense.Entities.BAReqDoc()
{
BAReqDocID = id
};
using (var ctx = new LicenseApplicationContext())
{
ctx.Entry(BAReqDoc).State = System.Data.Entity.EntityState.Deleted;
ctx.SaveChanges();
}
return(Json(new { success = true, message = " Deleted Successfully" }, JsonRequestBehavior.AllowGet));
}
catch
{
return(Json(new { success = false, message = "Error While Delete Record" }, JsonRequestBehavior.AllowGet));
}
}
/// <summary>
/// Get StallApplication Data by ID
/// </summary>
/// <param name="Id"></param>
/// <returns></returns>
public ActionResult ManageStallApplication(int?Id)
{
List <TradingLicense.Model.SAReqDocModel> SAReqDoc = new List <Model.SAReqDocModel>();
StallApplicationModel stallApplicationModel = new StallApplicationModel();
using (var ctx = new LicenseApplicationContext())
{
IQueryable <SAReqDoc> query = ctx.SAReqDocs;
SAReqDoc = Mapper.Map <List <SAReqDocModel> >(query.ToList());
ViewBag.stallDocList = ctx.SAReqDocs.ToList();
if (Id != null && Id > 0)
{
int stallApplicationID = Convert.ToInt32(Id);
var stallApplication = ctx.StallApplications.Where(a => a.StallApplicationID == stallApplicationID).FirstOrDefault();
stallApplicationModel = Mapper.Map <StallApplicationModel>(stallApplication);
}
}
return(View(stallApplicationModel));
}
/// <summary>
/// Get BAReqDoc Data by ID
/// </summary>
/// <param name="Id"></param>
/// <returns></returns>
public ActionResult ManageBAReqDoc(int?Id)
{
BAReqDocModel BAReqDocModel = new BAReqDocModel();
if (Id != null && Id > 0)
{
using (var ctx = new LicenseApplicationContext())
{
int BAReqDocID = Convert.ToInt32(Id);
var BAReqDoc = ctx.BAReqDocs.Where(a => a.BAReqDocID == BAReqDocID).FirstOrDefault();
BAReqDocModel = Mapper.Map <BAReqDocModel>(BAReqDoc);
}
}
IList <BAReqDoc> list = db.BAReqDocs.ToList();
ViewData["BAReqDocs"] = list;
return(View(BAReqDocModel));
}
/// <summary>
/// Get HawkerApplication Data by ID
/// </summary>
/// <param name="Id"></param>
/// <returns></returns>
public ActionResult ManageHawkerApplication(int?Id)
{
List <TradingLicense.Model.HAReqDocModel> HAReqDoc = new List <Model.HAReqDocModel>();
HawkerApplicationModel HawkerApplicationModel = new HawkerApplicationModel();
using (var ctx = new LicenseApplicationContext())
{
IQueryable <HAReqDoc> query = ctx.HAReqDocs;
HAReqDoc = Mapper.Map <List <HAReqDocModel> >(query.ToList());
ViewBag.hawkerDocList = ctx.HAReqDocs.ToList();
if (Id != null && Id > 0)
{
int HawkerApplicationID = Convert.ToInt32(Id);
var HawkerApplication = ctx.HawkerApplications.Where(a => a.HawkerApplicationID == HawkerApplicationID).FirstOrDefault();
HawkerApplicationModel = Mapper.Map <HawkerApplicationModel>(HawkerApplication);
}
}
return(View(HawkerApplicationModel));
}
public ActionResult ResetPassword(ResetPasswordModel resetPasswordModel)
{
using (var ctx = new LicenseApplicationContext())
{
if (resetPasswordModel.NewPassword != resetPasswordModel.ConfirmPassword)
{
ViewBag.openPopup = CommonHelper.ShowAlertMessageToastr(MessageType.danger.ToString(), Messages.ResetPasswordMatch);
return(View(Actions.ResetPassword, resetPasswordModel));
}
if (resetPasswordModel.RoleTypeId == SystemEnum.RoleType.User.GetHashCode())
{
var user = ctx.Users.Where(u => u.UsersID == resetPasswordModel.Id).FirstOrDefault();
if (user != null && user.UsersID > 0)
{
user.Password = EncryptionDecryption.GetEncrypt(resetPasswordModel.NewPassword);
ctx.Users.AddOrUpdate(user);
ctx.SaveChanges();
UsersModel usermodel = new UsersModel();
usermodel = Mapper.Map <UsersModel>(user);
ProjectSession.UserID = user.UsersID;
ProjectSession.User = usermodel;
FormsAuthentication.SetAuthCookie(ProjectSession.UserName, false);
return(RedirectToAction(Actions.Individual, Pages.Controllers.Master));
}
else
{
ViewBag.openPopup = CommonHelper.ShowAlertMessageToastr(MessageType.danger.ToString(), Messages.UrlNotExist);
return(View(Actions.ResetPassword, resetPasswordModel));
}
}
else
{
ViewBag.openPopup = CommonHelper.ShowAlertMessageToastr(MessageType.danger.ToString(), Messages.ResetPasswordRequest);
return(View(Actions.ResetPassword, resetPasswordModel));
}
}
}
public JsonResult LiquorApplication([ModelBinder(typeof(DataTablesBinder))] IDataTablesRequest requestModel, string LiquorApplicationID, string IndividualMkNo)
{
List <TradingLicense.Model.LiquorApplicationModel> LiquorApplication = new List <Model.LiquorApplicationModel>();
int totalRecord = 0;
using (var ctx = new LicenseApplicationContext())
{
IQueryable <LiquorApplication> query = (ProjectSession.User != null && ProjectSession.User.RoleTemplateID == (int)RollTemplate.Public) ? ctx.LiquorApplications.Where(p => p.UsersID == ProjectSession.User.UsersID) : ctx.LiquorApplications;
if (!string.IsNullOrWhiteSpace(LiquorApplicationID))
{
query = query.Where(q => q.LiquorApplicationID.ToString().Contains(LiquorApplicationID));
}
#region Sorting
// Sorting
var sortedColumns = requestModel.Columns.GetSortedColumns();
var orderByString = String.Empty;
foreach (var column in sortedColumns)
{
orderByString += orderByString != String.Empty ? "," : "";
orderByString += (column.Data) +
(column.SortDirection ==
Column.OrderDirection.Ascendant ? " asc" : " desc");
}
var result = Mapper.Map <List <LiquorApplicationModel> >(query.ToList());
result = result.OrderBy(orderByString == string.Empty ? "LiquorApplicationID asc" : orderByString).ToList();
totalRecord = result.Count();
#endregion Sorting
// Paging
result = result.Skip(requestModel.Start).Take(requestModel.Length).ToList();
LiquorApplication = result;
}
return(Json(new DataTablesResponse(requestModel.Draw, LiquorApplication, totalRecord, totalRecord), JsonRequestBehavior.AllowGet));
}
/// <summary>
/// Get LiquorApplication Data by ID
/// </summary>
/// <param name="Id"></param>
/// <returns></returns>
public ActionResult ManageLiquorApplication(int?Id)
{
LiquorApplicationModel liquorApplicationModel = new LiquorApplicationModel();
if (Id != null && Id > 0)
{
using (var ctx = new LicenseApplicationContext())
{
int LiquorApplicationID = Convert.ToInt32(Id);
var liquorApplication = ctx.LiquorApplications.Where(a => a.LiquorApplicationID == LiquorApplicationID).FirstOrDefault();
liquorApplicationModel = Mapper.Map <LiquorApplicationModel>(liquorApplication);
}
}
if (ProjectSession.User != null && ProjectSession.User.RoleTemplateID > 0)
{
liquorApplicationModel.UserRollTemplate = ProjectSession.User.RoleTemplateID.Value;
liquorApplicationModel.UsersID = ProjectSession.User.UsersID;
}
liquorApplicationModel.IsDraft = false;
return(View(liquorApplicationModel));
}
/// <summary>
/// Determines whether the specified page type has access.
/// </summary>
/// <param name="page">The page.</param>
/// <returns>has access or not</returns>
public static bool HasAccess(SystemEnum.Page page, SystemEnum.PageRight pageRight)
{
bool result = false;
try
{
using (var ctx = new LicenseApplicationContext())
{
if (ProjectSession.User != null)
{
int screenId = page.GetHashCode();
int crudLevel = pageRight.GetHashCode();
result = ctx.AccessPages.Where(o => o.RoleTemplateID == ProjectSession.User.RoleTemplateID && o.ScreenId == screenId && o.CrudLevel >= crudLevel).Count() > 0 ? true : false;
}
}
}
catch (Exception ex)
{
}
return(result);
}
