public SecondForm() { InitializeComponent(); _querySession = new CustomRepository(); _session = new ClientRepository(); GetListOfClient(); }
public ActionResult LoginUser(LoginModel model) { if (ModelState.IsValid) { tblUser logedInUser = _dbRepository.GetEntities().FirstOrDefault(m => m.Username == model.UserName && m.Password == model.Password); if (logedInUser == null) { TempData[Enums.NotifyType.Error.GetDescription()] = "Invalid Login Credentials."; return(View("Index", model)); } else { SessionHelper.UserId = Convert.ToInt32(logedInUser.UserId); SessionHelper.WelcomeUser = logedInUser.Name; SessionHelper.RoleId = logedInUser.RoleId == null ? 0 : (int)logedInUser.RoleId; SessionHelper.Email = logedInUser.UserEmail; SessionHelper.UserAccessPermissions = CustomRepository.UserAccessPermissions(SessionHelper.RoleId, logedInUser.IsSuperAdmin); CommonHelper.UserId = Convert.ToInt32(logedInUser.UserId); FormsService.SignIn(logedInUser.Name, model.RememberMe); TempData[Enums.NotifyType.Success.GetDescription()] = "Login Successfully."; return(RedirectToAction("Index", "Home")); } } return(View("Index", model)); }
public CustomTest() { // Arrange _mockRepo = new Mock <ICustom>(); repo = new CustomRepository(); //_mockRepo.Setup(repo => repo.Custom()).Returns(200); }
public void FinByGlossary_test(int id, string criteria) { CustomRepository <string> repo = new CustomRepository <string>(); DataSet ds = (DataSet)repo.FindByGlossary(id, criteria); Assert.IsTrue(ds.Tables["Customer"].Rows.Count > 0); }
//[Route("/[controller]/SignUpPost")] public async Task <IActionResult> SignUp(RegisterViewModel model) { ViewBag.Error = ""; if (ModelState.IsValid) { Regex regex = new Regex(@"[a-z0-9!#$%&'*+/=?^_`{|}~-]+(?:\.[a-z0-9!#$%&'*+/=?^_`{|}~-]+)*@(?:[a-z0-9](?:[a-z0-9-]*[a-z0-9])?\.)+[a-z0-9](?:[a-z0-9-]*[a-z0-9])?"); Match match = regex.Match(model.Email.Trim().ToLower()); if (!match.Success) { return(new JsonResult(new { code = 0, Err = "" })); } var result = CustomRepository.CreateUser(model.Email, model.PhoneNumber, model.Password, model.FullName, model.ProvinceId, model.DistricId, model.WardId, model.PlaceDetail); if (result != null) { EmailHelper.SendConfirmEmail(result); var user = _db.TblUsers.Where(x => x.Email.Equals(model.Email)).FirstOrDefault(); var re = await CustomRepository.AddUserToRoleAsync(user, 3); if (re == true) { return(RedirectToAction("SignIn", "Account", new { Email = user.Email })); } } else { ViewBag.Error = "Người dùng đã tồn tại"; return(RedirectToAction(nameof(SignUp))); } } return(new JsonResult(new { code = 0, Err = "*Có lỗi xảy ra, vui lòng thử lại" })); }
public long Insert(InvoiceModel model) { TblInvoice obj = _mapper.Map <InvoiceModel, TblInvoice>(model); obj.Day = model.InvoiceDate.Day; obj.Month = model.InvoiceDate.Month; obj.Year = model.InvoiceDate.Year; obj.InvoiceNo = ""; obj.SequenceNo = 0; obj.TotalAmount = CustomRepository.GetTotalAmountForInvoice(model.checkedDispatchId).TotalAmount; decimal SgstAmount = Math.Round(obj.TotalAmount * (model.Sgst ?? 0) / 100, 2); decimal IgstAmount = Math.Round(obj.TotalAmount * (model.Igst ?? 0) / 100, 2); decimal CgstAmount = Math.Round(obj.TotalAmount * (model.Cgst ?? 0) / 100, 2); obj.TaxAmount = SgstAmount + IgstAmount + CgstAmount; obj.TotalAmountWithTax = obj.TotalAmount + obj.TaxAmount; obj.AmountInWords = CurrencyHelper.changeCurrencyToWords(obj.TotalAmountWithTax); List <long> dispatchIdList = model.checkedDispatchId.Split(',').Select(long.Parse).ToList(); foreach (long dispatchId in dispatchIdList) { obj.TblInvoiceDetail.Add(new TblInvoiceDetail { DispatchId = dispatchId }); } _repository.Insert(obj); return(obj.InvoiceId); }
public void FinById_test(int id) { CustomRepository <string> repo = new CustomRepository <string>(); DataSet ds = (DataSet)repo.FindByID(id); Assert.IsTrue(ds.Tables["Customer"].Rows.Count > 0); }
public ActionResult SaveInquiry(tblInquiry model) { if (ModelState.IsValid) { using (StudioCraftEntities context = CustomRepository.GetDbContext()) { context.tblInquiry.Add(model); context.SaveChanges(); } string bodyTemplate = System.IO.File.ReadAllText(Server.MapPath("~/Template/InquiryTemplate.html")); bodyTemplate = bodyTemplate.Replace("[@NAME]", model.Name); bodyTemplate = bodyTemplate.Replace("[@EMAIL]", model.Email); bodyTemplate = bodyTemplate.Replace("[@BUDGET]", model.Budget); bodyTemplate = bodyTemplate.Replace("[@MESSAGE]", model.Message); bodyTemplate = bodyTemplate.Replace("[@REGARDING]", model.Regarding); Task task = new Task(() => EmailHelper.SendMail("Studio Craft - New Inquiry", bodyTemplate, true)); task.Start(); return(RedirectToAction("ThankYou")); } return(View("Index")); }
public ActionResult KendoRead([DataSourceRequest] DataSourceRequest request, int PreCommissionId) { if (!request.Sorts.Any()) { request.Sorts.Add(new SortDescriptor("PreCommisoningDate", ListSortDirection.Descending)); } DataSourceResult result = CustomRepository.GetPreCommisioningDetailData(PreCommissionId).ToDataSourceResult(request); //DataSourceResult result = _dbRepository.GetEntities().Where(m => m.PreCommissionId == PreCommissionId).ToDataSourceResult(request); List <GetPreCommisioningDetailData_Result> list = result.Data as List <GetPreCommisioningDetailData_Result>; foreach (GetPreCommisioningDetailData_Result obj in list) { if (obj.PCAccesseriesId > 0) { obj.PCAccessoryIdList = new List <int>(); obj.PCAccessoryIdList.Add(obj.PCAccesseriesId.Value); } if (obj.PCMachineId > 0) { obj.PCMachineIdList = new List <int>(); obj.PCMachineIdList.Add(obj.PCMachineId.Value); } } return(Json(list.ToDataSourceResult(request))); }
public ActionResult Index(LoginModel model) { //if (!ModelState.IsValid) //{ // return View("Index", model); //} var UserNameParam = new SqlParameter { ParameterName = "UserName", DbType = DbType.String, Value = model.UserName }; var PasswordParam = new SqlParameter { ParameterName = "Password", DbType = DbType.String, Value = model.Password }; UserModel logedInUser = new UserModel(); using (AgroAppEntities obj = new AgroAppEntities()) { try { var List = obj.Database.SqlQuery <UserModel>("Sp_UserLogin @UserName,@Password", UserNameParam, PasswordParam).FirstOrDefault(); logedInUser = List; } catch (Exception ex) { return(View()); } } if (logedInUser == null) { ModelState.AddModelError("UserName", "Invalid Login Credentials."); return(View(model)); } if (!logedInUser.IsActive) { ModelState.AddModelError("UserName", string.Format("User '{0}' is no longer active.", logedInUser.UserName)); return(View(model)); } SessionHelper.UserId = Convert.ToInt32(logedInUser.UserId); SessionHelper.WelcomeUser = logedInUser.Name; SessionHelper.RoleId = logedInUser.RoleId; SessionHelper.Email = logedInUser.EmailAddress; SessionHelper.Password = logedInUser.Password; SessionHelper.IsSuperAdmin = logedInUser.IsSuperAdmin; SessionHelper.ProfilePic = logedInUser.Image; SessionHelper.UserAccessPermissions = CustomRepository.UserAccessPermissions(SessionHelper.RoleId, logedInUser.IsSuperAdmin); FormsService.SignIn(logedInUser.UserName, model.RememberMe); return(RedirectToAction("Index", "Home")); }
public string Get([FromServices] CustomRepository repo, [FromQuery] string key) { Console.WriteLine(repo.Get(key)); repo.Text = "Invalid value"; Console.WriteLine(repo.Text); return("Get OK"); }
async public Task <string> GetAsync([FromServices] CustomRepository repo, [FromQuery] string key) { Console.WriteLine(await repo.GetAsync(key)); repo.Text = "Invalid value"; Console.WriteLine(repo.Text); return("GetAsync OK"); }
public void Validation_Test() { CustomRepository <string> repo = new CustomRepository <string>(); DataSet ds = (DataSet)repo.FillAll(); repo.Validation(); Assert.IsTrue(ds.Tables["Error"].Rows.Count > 0); }
public IEnumerable <ValidationResult> Validate(ValidationContext validationContext) { if (CustomRepository.CheckProductExistsINOrder(OrderId, ProductId, OrderDetailId)) { var fieldName = new[] { "ProductId" }; yield return(new ValidationResult("Product Already Exists.", fieldName)); } }
public IEnumerable <ValidationResult> Validate(ValidationContext validationContext) { if (CustomRepository.CheckCoreAlreadyExists(Name, Thickness, CoreId)) { var fieldName = new[] { "Name" }; yield return(new ValidationResult("Core with same Name & Thickness already Exists.", fieldName)); } }
public object FillAllCustomers() { _lastQuery = QueryCriteria.GetAll; _paramsObjects.Clear(); var _repo = new CustomRepository <string>(); return(_repo.FillAll()); }
public IEnumerable <ValidationResult> Validate(ValidationContext validationContext) { if (CustomRepository.CheckRoleExistsOrNot(RoleName, RoleId)) { var fieldName = new[] { "RoleName" }; yield return(new ValidationResult("Role is Already Exists.", fieldName)); } }
/// <summary> /// Method to bind the dispatch grid /// </summary> /// <param name="request">DataSource Request</param> /// <param name="customerId">Customer Id</param> /// <param name="consigneeId">Consignee Id</param> /// <param name="invoiceId">Invoice Id</param> /// <param name="isFinalize">Is finalized</param> /// <returns></returns> public IActionResult KendoReadDispatch([DataSourceRequest] DataSourceRequest request, long?customerId = null, long?consigneeId = null, long?invoiceId = null, bool?isFinalize = false) { if (!request.Sorts.Any()) { request.Sorts.Add(new SortDescriptor("DispatchDate", ListSortDirection.Ascending)); } return(Json(CustomRepository.GetInvoiceDispatchList(customerId, consigneeId, invoiceId, isFinalize).ToDataSourceResult(request))); }
public IActionResult KendoReadOrder4Dispatch([DataSourceRequest] DataSourceRequest request, long buyerId, long consigneeId, long productId) { if (!request.Sorts.Any()) { request.Sorts.Add(new SortDescriptor("OrderNo", ListSortDirection.Ascending)); } return(Json(CustomRepository.GetDispatchOrderList(buyerId, consigneeId, productId).ToDataSourceResult(request))); }
public IEnumerable <ValidationResult> Validate(ValidationContext validationContext) { if (CustomRepository.CheckProductExistsOrNot(FilmType, (decimal)Thickness, ProductId)) { var fieldName = new[] { "FilmType" }; yield return(new ValidationResult("Product With Same micron Already Exists.", fieldName)); } }
public IActionResult KendoReadSlitting([DataSourceRequest] DataSourceRequest request, long?dispatchId = null, long?buyerId = null, long?consigneeId = null, bool?isFinalize = false) { if (!request.Sorts.Any()) { request.Sorts.Add(new SortDescriptor("SlittingRollNo", ListSortDirection.Ascending)); } return(Json(CustomRepository.GetDispatchSlittingList(buyerId, consigneeId, dispatchId, isFinalize).ToDataSourceResult(request))); }
public IEnumerable <ValidationResult> Validate(ValidationContext validationContext) { if (CustomRepository.CheckConsigneeExistsOrNot(Gstnumber, PanNumber, PhoneNumber, ConsigneeId)) { var fieldName = new[] { "Name" }; yield return(new ValidationResult("Consignee is Already Exists.", fieldName)); } }
/// <summary> /// Method to bind the slitting grid /// </summary> /// <param name="request">DataSource Request</param> /// <param name="dispatchId">DispatchId</param> /// <returns></returns> public IActionResult KendoReadSlittingByDispatchId([DataSourceRequest] DataSourceRequest request, long?dispatchId = null) { if (!request.Sorts.Any()) { request.Sorts.Add(new SortDescriptor("SlittingRollNo", ListSortDirection.Ascending)); } return(Json(CustomRepository.GetInvoiceSlittingList(dispatchId).ToDataSourceResult(request))); }
public ActionResult KendoReadWarrantyExpiry([DataSourceRequest] DataSourceRequest request) { if (!request.Sorts.Any()) { request.Sorts.Add(new SortDescriptor("CustomerName", ListSortDirection.Ascending)); } return(Json(CustomRepository.GetWarrantyExpiryCustomerList().ToDataSourceResult(request))); }
public IActionResult KendoReadJumboRollStock([DataSourceRequest] DataSourceRequest request) { if (!request.Sorts.Any()) { request.Sorts.Add(new SortDescriptor("JumboNo", ListSortDirection.Ascending)); } return(Json(CustomRepository.GetJumboRollStockList().ToDataSourceResult(request))); }
public object GetCustomersByBirthday(DateTime date) { _lastQuery = QueryCriteria.Bithday; _paramsObjects.Clear(); _paramsObjects.Add(date); CustomRepository <DateTime> _repo = new CustomRepository <DateTime>(); return(_repo.FindBy(QueryCriteria.Bithday, date)); }
public IActionResult GetUserRightsList(DataSourceRequest request, int RoleId) { if (RoleId != 0) { List <UserRightsModel> list = CustomRepository.GetUserRightsList(RoleId).ToList(); return(Json(list.ToDataSourceResult(request))); } return(Json(new List <UserRightsModel>().ToDataSourceResult(request))); }
public object GetCustomersByLastName(string lastName) { _lastQuery = QueryCriteria.LastName; _paramsObjects.Clear(); _paramsObjects.Add(lastName); CustomRepository <string> _repo = new CustomRepository <string>(); return(_repo.FindBy(QueryCriteria.LastName, lastName)); }
public ActionResult KendoReadDetailById([DataSourceRequest] DataSourceRequest request, int preCommisioningId) { //if (!request.Sorts.Any()) //{ // request.Sorts.Add(new SortDescriptor("PreCommissioningId", ListSortDirection.Ascending)); //} return(Json(CustomRepository.GetPreCommisioningListDetail(preCommisioningId).ToDataSourceResult(request))); }
public ActionResult KendoRead([DataSourceRequest] DataSourceRequest request) { //if (!request.Sorts.Any()) //{ // request.Sorts.Add(new SortDescriptor("MachinePartsQuotationId", ListSortDirection.Ascending)); //} return(Json(CustomRepository.GetPartsQuoatationList().ToDataSourceResult(request))); }