static void Main(string[] args) { var numbers = new List <string>() { "09193121247", "09120815107", "09124254257", "09354047788" }; var nextToday = DateTime.Now.AddDays(2); var persianDate = DateUtility.GetPersianDate(nextToday); using (var db = new KiaGalleryMainContextEntities()) { var foodName = db.FoodCensus.Where(x => DbFunctions.TruncateTime(x.Date) == DbFunctions.TruncateTime(nextToday)).Select(x => x.FoodName).FirstOrDefault(); var registerFoodCount = db.FoodRegistrations.Where(x => DbFunctions.TruncateTime(x.Date) == DbFunctions.TruncateTime(nextToday) && x.Food == true).Count(); var registerAppetizerCount = db.FoodRegistrations.Where(x => DbFunctions.TruncateTime(x.Date) == DbFunctions.TruncateTime(nextToday) && x.Appertizer == true).Count(); var appetizerSettingCount = int.Parse(db.FoodSettings.SingleOrDefault(x => x.Key == FoodSchedule.Settings.KeyAppetizerCount)?.Value); var foodSettingCount = int.Parse(db.FoodSettings.SingleOrDefault(x => x.Key == FoodSchedule.Settings.KeyFoodCount)?.Value); var foodWithoutRice = db.FoodRegistrations.Where(x => DbFunctions.TruncateTime(x.Date) == DbFunctions.TruncateTime(nextToday) && x.FoodWithoutRice == true).Count(); var foodSum = registerFoodCount + foodSettingCount; var messageFood = db.FoodCensus.Where(x => DbFunctions.TruncateTime(x.Date) == DbFunctions.TruncateTime(nextToday)).Select(x => x.TypeFood).SingleOrDefault(); var apertizerSum = registerAppetizerCount + appetizerSettingCount; if (messageFood == true) { NikSmsWebServiceClient.SendSmsNik("اطلاعات غذا به تاریخ " + persianDate + "به شرح زیر است.\n نام غذا:" + foodName + "\n تعداد غذا بدون برنج برای هر نفر: " + foodWithoutRice + "\n تعداد غذا با برنج برای هر نفر:" + foodSum + "\n تعداد سالاد به تعداد نفرات:" + apertizerSum + " \n با تشکر", numbers); } else { NikSmsWebServiceClient.SendSmsNik("اطلاعات غذا به تاریخ " + persianDate + "به شرح زیر است.\n نام غذا:" + foodName + "\n تعداد غذا برای هر نفر:" + foodSum + "\n تعداد سالاد به تعداد نفرات:" + apertizerSum + " \n با تشکر", numbers); } Console.WriteLine("Connecting To DataBase..."); Console.WriteLine("Text Messages Sent..."); Console.WriteLine("Job Done!"); } }
public JsonResult Load(int id) { Response response; try { using (var db = new KiaGalleryContext()) { var item = db.FoodRegistration.Where(x => x.Id == id).SingleOrDefault(); var data = new FoodCensusViewModel() { id = item.Id, foodCensusId = item.FoodCensusId, appertizer = item.Appertizer, typeFood = item.FoodWithoutRice, food = item.Food, date = DateUtility.GetPersianDate(item.Date) }; response = new Response() { status = 200, data = data, }; } } catch (Exception ex) { response = Core.GetExceptionResponse(ex); } return(Json(response, JsonRequestBehavior.AllowGet)); }
private void sendGoldReport() { using (var db = new KiaGalleryMainEntities()) { var data = db.BranchGolds.Where(x => x.CreateDate >= DateTime.Today).GroupBy(x => x.Branches).Select(y => new { weight = y.OrderByDescending(x => x.Id).Select(x => x.Weight).FirstOrDefault(), price = y.OrderByDescending(x => x.Id).Select(x => x.Price).FirstOrDefault(), branch = y.Key.Name }).ToList(); var persianDate = DateUtility.GetPersianDate(DateTime.Now); double sum = data.Sum(x => x.weight); long priceSum = data.Sum(x => x.price); var rate = priceSum / sum * 4.3318; string message = persianDate + "\nجمع کل: " + sum + " گرم" + "\n جمع قیمت: " + Core.ToSeparator(priceSum) + " ریال " + " \nمیانگین مظنه: " + Core.ToSeparator(rate) + " ریال " + "\n"; foreach (var item in data) { message += "شعبه " + item.branch + ": " + item.weight + " گرم " + Core.ToSeparator(item.price) + " ریال \n"; } if (sum > 0) { var user = db.BotGoldReportUserData.Where(x => x.BotUserType == 1).ToList(); user.ForEach(x => { var task = Bot.SendTextMessageAsync(x.ChatId, message.Trim()); task.Wait(); }); } } }
public JsonResult Load(string date) { Response response; try { var dt = DateUtility.GetDateTime(date); using (var db = new KiaGalleryContext()) { var item = db.FoodCensus.Where(x => x.Date == dt).SingleOrDefault(); var data = new FoodCensusViewModel() { id = item.Id, foodName = item.FoodName, typeFood = item.TypeFood, holiday = item.Holiday, date = DateUtility.GetPersianDate(item.Date) }; response = new Response() { status = 200, data = data, }; } } catch (Exception ex) { response = Core.GetExceptionResponse(ex); } return(Json(response, JsonRequestBehavior.AllowGet)); }
public JsonResult CustomerInfoAutoCompelete(string term) { try { using (var db = new KiaGalleryContext()) { var list = db.CustomerLoyality.Where(x => x.PhoneNumber.Contains(term) || x.FirstName.Contains(term) || x.LastName.Contains(term)).Select(x => new SearchAutoCompeleteViewModel { phoneNumber = x.PhoneNumber, firstName = x.FirstName, lastName = x.LastName, birthDate = x.BirthDate != null ? x.BirthDate : DateTime.Now, mariageDate = x.MariageDate != null ? x.MariageDate : DateTime.Now, }).OrderBy(x => x.phoneNumber).Take(3).ToList(); list.ForEach(x => { x.persianBirthDate = DateUtility.GetPersianDate(x.birthDate); x.persianMarriageDate = DateUtility.GetPersianDate(x.mariageDate); }); return(Json(list, JsonRequestBehavior.AllowGet)); } } catch (Exception ex) { Core.SaveException(ex); return(Json("[]", JsonRequestBehavior.AllowGet)); } }
public JsonResult ReturnDate(InstagramPostDateViewModel model) { Response response; try { PersianCalendar Calendar = new PersianCalendar(); //var date = DateUtility.GetDateTime(model.publishDate); var date = DateUtility.GetDateTime(model.publishDate); var finalPublishDate = date.Value.AddDays(model.dayCounter); var finalPersianPublishDate = DateUtility.GetPersianDate(finalPublishDate); response = new Response() { status = 200, data = new { finalPersianPublishDate, }, }; } catch (Exception ex) { response = Core.GetExceptionResponse(ex); } return(Json(response, JsonRequestBehavior.AllowGet)); }
public JsonResult Load(int id) { Response response; try { using (var db = new KiaGalleryContext()) { var item = db.InstagramPost.Where(x => x.Id == id).SingleOrDefault(); var data = new InstagramPostViewModel() { id = item.Id, title = item.Title, instagramPostType = item.InstagramPostType, dayCounter = item.DayCounter, publishDate = DateUtility.GetPersianDate(item.PublishDate), respite = item.Respite, fileId = item.FileId, fileName = item.FileName, }; response = new Response() { status = 200, data = data, }; } } catch (Exception ex) { response = Core.GetExceptionResponse(ex); } return(Json(response, JsonRequestBehavior.AllowGet)); }
public JsonResult Load(int id) { try { var entity = _context.News.Where(x => x.StatusId != NewsStatus.Deleted.Id && x.Id == id).Select(x => new NewsViewModel() { id = x.Id, fileId = x.FileId, fileName = x.FileName, view = x.View.Value, publishDate = x.PublishDate, expiredDate = x.ExpiredDate, statusId = x.StatusId, statusTitle = x.Status.PersianTitle, translations = x.TranslationList.Select(y => new NewsTranslationViewModel() { languageId = y.LanguageId, title = y.Title, abstractText = y.AbstractText, text = y.Text, keywords = y.Keywords, }).ToList() }).Single(); entity.PersianPublishDate = DateUtility.GetPersianDate(entity.publishDate); entity.PersianExpiredDate = DateUtility.GetPersianDate(entity.expiredDate); return(Success(entity)); } catch (Exception ex) { return(ServerError(ex)); } }
public JsonResult GetCustomer(string barcode) { Response response; try { using (var db = new KiaGalleryContext()) { var entity = db.Customer.Where(x => x.Barcode == barcode).Select(x => new { id = x.Id, firstName = x.FirstName, lastName = x.LastName, nationalityCode = x.NationalityCode, mobileNo = x.MobileNo, balance = x.Balance, birthDate = x.BirthDate, weddingDate = x.WeddingDate, sex = x.Sex }).SingleOrDefault(); if (entity != null) { var customer = new CustomerViewModel() { id = entity.id, firstName = entity.firstName, lastName = entity.lastName, nationalityCode = entity.nationalityCode, mobileNo = entity.mobileNo, birthDate = DateUtility.GetPersianDate(entity.birthDate), weddingDate = DateUtility.GetPersianDate(entity.weddingDate), balance = entity.balance, sex = entity.sex, sexTitle = Enums.GetTitle(entity.sex) }; response = new Response() { status = 200, data = customer }; } else { response = new Response() { status = 404, message = "مشتری مورد نظر یافت نشد" }; } } } catch (Exception ex) { response = Core.GetExceptionResponse(ex); } return(Json(response, JsonRequestBehavior.AllowGet)); }
public JsonResult Load(int id) { Response response; try { SalaryViewModel item; using (var db = new KiaGalleryContext()) { int?nextId = db.Salary.FirstOrDefault(x => x.Id == (id + 1))?.Id; int?prevId = db.Salary.FirstOrDefault(x => x.Id == (id - 1))?.Id; item = db.Salary.Where(x => x.Id == id).Select(x => new SalaryViewModel() { id = x.Id, fullName = x.Person.FirstName + " " + x.Person.LastName, personNumber = x.Person.PersonNumber, branch = x.Person.Branch.Name, workHours = x.WorkHours, hourlyWageRate = x.HourlyWageRate, overtimeRate = x.OvertimeRate, mission = x.Mission, reward = x.Reward, remuneration = x.Remuneration, others = x.Others, loanInstallment = x.LoanInstallment, imprest = x.Imprest, commodityItem = x.CommodityItem, monthCalculatedDate = x.MonthCalculated, insurance = x.Insurance }).FirstOrDefault(); item.monthCalculated = DateUtility.GetPersianDate(item.monthCalculatedDate); item.nextId = nextId; item.prevId = prevId; } if (item != null) { response = new Response() { status = 200, data = item }; } else { response = new Response() { status = 404, message = "پرسنل مورد نظر یافت نشد." }; } } catch (Exception ex) { response = Core.GetExceptionResponse(ex); } return(Json(response, JsonRequestBehavior.AllowGet)); }
public JsonResult GetExpiredCustomer(CustomerLoyalitySearchViewModel model) { var currentUser = GetAuthenticatedUser(); Response response; int dataCount; try { using (var db = new KiaGalleryContext()) { var query = db.CustomerFactor.Where(x => x.PurchaseType == PurchaseType.Return && DbFunctions.AddDays(x.Date, 30) < x.ReturnDate); if (model.branchId != null) { query = query.Where(x => x.BranchId == model.branchId); } dataCount = query.Count(); query = query.OrderByDescending(x => x.Id).Skip(model.page * model.count).Take(model.count); var list = query.Select(x => new CustomerLoyalityViewModel { id = x.Id, fullName = x.CustomerLoyality.FirstName + " " + x.CustomerLoyality.LastName, phoneNumber = x.CustomerLoyality.PhoneNumber, branchId = x.BranchId, branchName = x.Branch.Name, date = x.Date, returnDate = x.ReturnDate, factorPrice = x.FactorPrice, factorNumber = x.FactorNumber, purchaseType = x.PurchaseType }).ToList(); list.ForEach(x => { x.persianDate = DateUtility.GetPersianDate(x.date); x.persianReturnDate = DateUtility.GetPersianDate(x.returnDate); x.separateFactorPrice = Core.ToSeparator(x.factorPrice); x.purchaseTypeTitle = Enums.GetTitle(x.purchaseType); }); response = new Response() { status = 200, data = new { list = list, pageCount = Math.Ceiling((double)dataCount / model.count), count = dataCount, page = model.page + 1 } }; } } catch (Exception ex) { response = Core.GetExceptionResponse(ex); } return(Json(response, JsonRequestBehavior.AllowGet)); }
public JsonResult Search(SearchBranchNoteViewModel model) { Response response; try { int status = 200; string message = string.Empty; var user = GetAuthenticatedUser(); List <BranchNoteViewModel> list = new List <BranchNoteViewModel>(); int dataCount = 0; double pageCount = 0; if (user.BranchId != null) { using (var db = new KiaGalleryContext()) { var query = db.BranchNote.Where(x => x.BranchId == user.BranchId); if (!string.IsNullOrEmpty(model.term)) { query = query.Where(x => x.CreateUser.FirstName.Contains(model.term) || x.CreateUser.FirstName.Contains(model.term.Trim().Replace("ی", "ي").Replace("ک", "ك")) || x.CreateUser.LastName.Contains(model.term) || x.CreateUser.LastName.Contains(model.term.Trim().Replace("ی", "ي").Replace("ک", "ك"))); } dataCount = query.Count(); list = query.OrderByDescending(x => x.Id).Skip(model.count * model.page).Take(model.count).Select(x => new BranchNoteViewModel() { id = x.Id, text = x.Text, createUserName = x.CreateUser.FirstName + " " + x.CreateUser.LastName, CreateDate = x.CreateDate }).ToList(); } list.ForEach(x => x.createDate = DateUtility.GetPersianDate(x.CreateDate)); if (dataCount > 0) { pageCount = Math.Ceiling((double)dataCount / model.count); } } response = new Response() { data = new { list = list, pageCount = pageCount, count = dataCount, page = model.page + 1 }, status = status, message = message }; } catch (Exception ex) { response = Core.GetExceptionResponse(ex); } return(Json(response, JsonRequestBehavior.AllowGet)); }
public JsonResult GetOrderUsableProductCartList(ShowOrderUsableProductViewModel model) { Response response; try { using (var db = new KiaGalleryContext()) { var user = GetAuthenticatedUser(); var query = db.UsableProductCart.Where(x => x.BranchId == user.BranchId).Select(x => x); query = query.Where(x => x.Count > 0); if (model.categoryId != null && model.categoryId > 0) { query = query.Where(x => x.UsableProduct.CategoryUsableProduct.Id == model.categoryId); } if (model.childId != null && model.childId > 0) { query = query.Where(x => x.UsableProduct.CategoryUsableProduct.Id == model.childId); } var list = query.Select(item => new ShowOrderUsableProductViewModel { id = item.Id, name = item.UsableProduct.Name, childId = item.UsableProduct.CategoryUsableProduct.ParentId, productCount = item.Count, usableProductId = item.UsableProductId, description = item.Description, specification = item.Specification, createUser = item.CreateUser.FirstName + " " + item.CreateUser.LastName, image = item.UsableProduct.UsableProductFileList.Select(y => y.FileName).FirstOrDefault(), category = item.UsableProduct.CategoryUsableProduct.Title, unit = item.UsableProduct.Unit, createDate = item.CreateDate }).OrderBy(item => item.id).ToList(); list.ForEach(x => { x.persianDate = DateUtility.GetPersianDate(x.createDate); }); response = new Response() { status = 200, data = new { list = list, } }; }; } catch (Exception ex) { response = Core.GetExceptionResponse(ex); } return(Json(response, JsonRequestBehavior.AllowGet)); }
public JsonResult Search(InstagramPostParamsViewModel model) { Response response; try { List <InstagramPostSearchViewModel> list; int dataCount; using (var db = new KiaGalleryContext()) { var query = db.InstagramPost.Select(x => x); if (model.instagramPostType != null) { query = query.Where(x => x.InstagramPostType == model.instagramPostType); } dataCount = query.Count(); query = query.OrderBy(x => x.Id).Skip(model.page * model.count).Take(model.count); list = query.Select(item => new InstagramPostSearchViewModel() { id = item.Id, title = item.Title, dayCounter = item.DayCounter, publishDate = item.PublishDate, fileId = item.FileId, fileName = item.FileName, respite = item.Respite, instagramPostType = item.InstagramPostType, }).ToList(); list.ForEach(x => { x.persianPublishDate = DateUtility.GetPersianDate(x.publishDate); x.instagramPostTypeTitle = Enums.GetTitle(x.instagramPostType); x.finalPersianPublishDate = DateUtility.GetPersianDate(x.publishDate.Value.AddDays(x.dayCounter)); }); } response = new Response() { status = 200, data = new { list = list, pageCount = Math.Ceiling((double)dataCount / model.count), count = dataCount, page = model.page + 1 } }; } catch (Exception ex) { response = Core.GetExceptionResponse(ex); } return(Json(response, JsonRequestBehavior.AllowGet)); }
public JsonResult LoadCustomer(int id) { Response response; try { CrmCustomer item; using (var db = new KiaGalleryContext()) { item = db.CrmCustomer.FirstOrDefault(x => x.Id == id); var list = new CrmCustomerViewModel { id = item.Id, fullName = item.FullName, phoneNumber = item.PhoneNumber, factorNumber = item.FactorNumber, buyType = item.BuyType, buyTypeOnline = item.BuyTypeOnline, buyTypeSubset = item.BuyTypeSubset, score = item.Score, date = DateUtility.GetPersianDate(item.Date), answerList = item.CrmCustomerAnswerList.Select(x => new CrmCustomerAnswerViewModel() { crmQuestionId = x.CrmQuestionId, crmQuestionType = x.CrmQuestion.CrmQuestionType, buyType = x.CrmQuestion.BuyType, buyTypeSubset = x.CrmQuestion.BuyTypeSubset, buyTypeOnline = x.CrmQuestion.BuyTypeOnline, crmQuestionValueId = x.CrmQuestionValueId, descriptiveAnswer = x.DescriptiveAnswer, yesNoAnswer = x.YesNoAnswer, }).ToList() }; if (list != null) { response = new Response() { status = 200, data = list, }; } else { response = new Response() { status = 404, message = "سوال مورد نظر یافت نشد." }; } } } catch (Exception ex) { response = Core.GetExceptionResponse(ex); } return(Json(response, JsonRequestBehavior.AllowGet)); }
/// <summary> /// داشبورد /// </summary> /// <returns>صفحه مورد نظر</returns> public ActionResult Index() { var date = DateUtility.GetPersianDate(DateTime.Now); ViewBag.Date = date; ViewBag.DashDate = date.Replace("/", "-"); return(View()); }
/// <summary> /// برگرداندن لیست جزئیات سفارشات ارسال شده از سمت دفترمرکزی برای نمایش در کاربر چاپخانه /// </summary> /// <param name="model"></param> /// <returns></returns> public JsonResult GetFinalOrderDetail(ShowOrderUsableProductViewModel model) { Response response; int dataCount; try { using (var db = new KiaGalleryContext()) { var user = GetAuthenticatedUser(); var query = db.OrderUsableProductDetail.Where(x => x.OrderUsableProductId == model.orderUsableProductId && x.UsableProduct.PrintingHouseId == user.PrintingHouseId); var list = query.Select(item => new ShowOrderUsableProductViewModel { id = item.Id, name = item.UsableProduct.Name, printingHouseId = item.UsableProduct.PrintingHouseId, orderUsableProductId = item.OrderUsableProductId, productCount = item.Count, specification = item.Specification, unit = item.UsableProduct.Unit, code = item.UsableProduct.Code, image = item.UsableProduct.UsableProductFileList.Select(y => y.FileName).FirstOrDefault(), category = item.UsableProduct.CategoryUsableProduct.Title, createUser = item.CreateUser.FirstName + " " + item.CreateUser.LastName, createBranch = item.OrderUsableProduct.Branch.Name, createDate = item.CreateDate, officeInventory = item.OfficeInventory.Value, remain = item.Remain.Value, delivered = item.Delivered, confirmDelivered = item.ConfirmDelivered, printingHouseInventory = item.PrintingHouseInventory, remainFinal = item.RemainFinal, readyForDelivery = item.ReadyForDelivery, branchType = item.OrderUsableProduct.Branch.BranchType, }).ToList(); list.ForEach(x => { x.orderUsableProductStatusTitle = Enums.GetTitle(x.orderUsableProductStatus); x.persianDate = DateUtility.GetPersianDate(x.createDate); }); response = new Response() { status = 200, data = new { list = list, } }; } } catch (Exception ex) { response = Core.GetExceptionResponse(ex); } return(Json(response, JsonRequestBehavior.AllowGet)); }
public JsonResult Search(PostSearchViewModel model) { Response response; try { List <PostItem> list; int dataCount; using (var db = new KiaGalleryContext()) { var query = db.PostItem.Include(x => x.City).Select(x => x); if (!string.IsNullOrEmpty(model.term?.Trim())) { query = query.Where(x => x.TrackingCode.Contains(model.term.Trim()) || x.InvoiceNo.Contains(model.term.Trim()) || x.Customer.Contains(model.term.Trim()) || x.Customer.Contains(model.term.Trim().Replace("ی", "ي").Replace("ک", "ك")) || x.PhoneNumber.Contains(model.term.Trim()) || x.MobileNumber.Contains(model.term.Trim()) || x.Address.Contains(model.term.Trim()) || x.Address.Contains(model.term.Trim().Replace("ی", "ي").Replace("ک", "ك")) || x.PostalCode.Contains(model.term.Trim())); } dataCount = query.Count(); query = query.OrderByDescending(x => x.Id).Skip(model.page * model.count).Take(model.count); list = query.ToList(); } response = new Response() { status = 200, data = new { list = list.Select(item => new { id = item.Id, cityName = item.City.Name, invoiceNo = item.InvoiceNo, count = item.Count, weight = item.Weight, customer = item.Customer, submitUser = item.SubmitUser, submitDate = DateUtility.GetPersianDate(item.SubmitDate), postDate = DateUtility.GetPersianDate(item.PostDate), trackingCode = item.TrackingCode }), pageCount = Math.Ceiling((double)dataCount / model.count), count = dataCount, page = model.page + 1 } }; } catch (Exception ex) { response = Core.GetExceptionResponse(ex); } return(Json(response, JsonRequestBehavior.AllowGet)); }
public JsonResult Load(int id) { Response response; try { PostItem item; using (var db = new KiaGalleryContext()) { item = db.PostItem.Find(id); if (item != null) { response = new Response() { status = 200, data = new PostViewModel { id = item.Id, provinceId = item.City.ParentId, submitDate = DateUtility.GetPersianDate(item.SubmitDate), postDate = DateUtility.GetPersianDate(item.PostDate), cityId = item.CityId, invoiceNo = item.InvoiceNo, count = item.Count, weight = item.Weight, submitUser = item.SubmitUser, price = item.Price, customer = item.Customer, phoneNumber = item.PhoneNumber, mobileNumber = item.MobileNumber, address = item.Address, postalCode = item.PostalCode, sex = item.Sex } }; } else { response = new Response() { status = 404, message = "اطلاعات پست مورد نظر یافت نشد." }; } } } catch (Exception ex) { response = Core.GetExceptionResponse(ex); } return(Json(response, JsonRequestBehavior.AllowGet)); }
public JsonResult ReturnDataValue(FoodCensusValueViewModel model) { Response response; try { var fromDate = DateUtility.GetDateTime(model.persianFirstDayOfMonth); var toDate = DateUtility.GetDateTime(model.persianLastDayOfMonth); var nextTommorow = DateTime.Now.AddDays(2); var nextDay = DateTime.Now.AddDays(1); using (var db = new KiaGalleryContext()) { var userId = GetAuthenticatedUserId(); List <FoodCensusValueViewModel> item; var entity = db.FoodCensus.Where(x => x.Date >= fromDate && x.Date <= toDate).Select(x => new FoodCensusViewModel { id = x.Id, boolDate = x.Date >= nextTommorow ? true : false, boolCheckingDate = x.Date >= nextDay ? true : false, dateTime = x.Date, holiday = x.Holiday, typeFood = x.TypeFood, foodName = !string.IsNullOrEmpty(x.FoodName) ? x.FoodName : string.Empty, food = x.FoodRegistrationList.Where(y => y.UserId == userId).FirstOrDefault().Food, appertizer = x.FoodRegistrationList.Where(y => y.UserId == userId).FirstOrDefault().Appertizer, foodCount = x.FoodRegistrationList.Where(y => y.Food == true).Count(), foodRegisterList = x.FoodRegistrationList.Where(y => y.UserId > 0).Count(), foodRegistrationId = x.FoodRegistrationList.Where(y => y.UserId == userId).FirstOrDefault().Id > 0 ? x.FoodRegistrationList.Where(y => y.UserId == userId).FirstOrDefault().Id : 0, foodWithoutRice = x.FoodRegistrationList.Where(y => y.UserId == userId).FirstOrDefault().FoodWithoutRice, }).ToList(); entity.ForEach(x => { x.persianDate = DateUtility.GetPersianDate(x.dateTime); }); response = new Response() { status = 200, data = new { list = entity, } }; } } catch (Exception ex) { response = Core.GetExceptionResponse(ex); } return(Json(response, JsonRequestBehavior.AllowGet)); }
public JsonResult Load(int id) { var currentUser = GetAuthenticatedUser(); Response response; try { using (var db = new KiaGalleryContext()) { var entity = db.CustomerFactor.FirstOrDefault(x => x.Id == id); if (!User.IsInRole("admin") && !User.IsInRole("loyalCustomer")) { entity = db.CustomerFactor.FirstOrDefault(x => x.BranchId == currentUser.BranchId && x.Id == id); } if (entity != null) { response = new Response() { status = 200, data = new CustomerLoyalityViewModel() { id = entity.Id, productCode = entity.ProductCode, persianDate = DateUtility.GetPersianDate(entity.Date), persianReturnDate = DateUtility.GetPersianDate(entity.ReturnDate), firstName = entity.CustomerLoyality.FirstName, lastName = entity.CustomerLoyality.LastName, phoneNumber = entity.CustomerLoyality.PhoneNumber, branchId = entity.BranchId, factorPrice = entity.FactorPrice, factorWeight = entity.FactorWeight, factorNumber = entity.FactorNumber, purchaseType = entity.PurchaseType, } }; } else { response = new Response() { status = 404, message = "موردی یافت نشد." }; } } } catch (Exception ex) { response = Core.GetExceptionResponse(ex); } return(Json(response, JsonRequestBehavior.AllowGet)); }
public JsonResult Load(int id) { var user = GetAuthenticatedUser(); Response response; try { CompanyInvoice item; using (var db = new KiaGalleryContext()) { item = db.CompanyInvoices.FirstOrDefault(x => x.Id == id); var data = new CompanyInvoiceViewModel { id = item.Id, buyerAddress = item.BuyerAddress, reduction = item.Reduction, buyerEconomicalNumber = item.BuyerEconomicalNumber, buyerName = item.BuyerName, buyerNationalId = item.BuyerNationalId, buyerPhone = item.BuyerPhone, buyerPostalCode = item.BuyerPostalCode, date = DateUtility.GetPersianDate(item.Date), companyInvoiceDetailViewModel = item.CompanyInvoiceDetailList.Select(x => new CompanyInvoiceDetailViewModel() { detailId = x.Id, carat = x.Carat, descriptionProduct = x.DescriptionProduct, gram = x.Gram, identificationCode = x.IdentificationCode, stonePrice = x.StonePrice, stoneWeight = x.StoneWeight, wage = x.Wage, whistle = x.Whistle, goldPrice = x.GoldPrice, }).ToList(), }; response = new Response { status = 200, data = data, }; } } catch (Exception ex) { response = Core.GetExceptionResponse(ex); } return(Json(response, JsonRequestBehavior.AllowGet)); }
public JsonResult ManipulateAll(ShowOrderUsableProductViewModel model) { Response response; int dataCount; try { var currentUser = GetAuthenticatedUser(); using (var db = new KiaGalleryContext()) { var user = GetAuthenticatedUser(); var query = db.OrderUsableProductDetail.Where(x => x.OrderUsableProductId == model.orderUsableProductId); var list = query.Select(item => new ShowOrderUsableProductViewModel { id = item.Id, name = item.UsableProduct.Name, orderUsableProductId = item.OrderUsableProductId, printingHouseOrderId = item.UsableProduct.PrintingHouseId, productCount = item.Count, printingHouserOrder = item.OrderUsableProduct.PrintingHouserOrder, orderUsableProductStatus = item.OrderUsableProduct.OrderUsableProductStatus, image = item.UsableProduct.UsableProductFileList.Select(y => y.FileName).FirstOrDefault(), category = item.UsableProduct.CategoryUsableProduct.Title, description = item.Description, specification = item.Specification, createUser = item.CreateUser.FirstName + " " + item.CreateUser.LastName, createBranch = item.OrderUsableProduct.Branch.Name, createDate = item.CreateDate }).ToList(); list.ForEach(x => { x.persianDate = DateUtility.GetPersianDate(x.createDate); }); response = new Response() { status = 200, data = new { list = list, } }; } } catch (Exception ex) { response = Core.GetExceptionResponse(ex); } return(Json(response, JsonRequestBehavior.AllowGet)); }
public JsonResult Search(SalaryParamsViewModel model) { Response response; try { List <SalarySearchViewModel> salaryList; int dataCount; using (var db = new KiaGalleryContext()) { var query = db.Salary.Select(x => x); if (!string.IsNullOrEmpty(model.date)) { DateTime dateTime = DateUtility.GetDateTime(model.date).GetValueOrDefault(); query = query.Where(x => x.MonthCalculated == dateTime); } dataCount = query.Count(); query = query.OrderByDescending(x => x.Id).Skip(model.page * model.count).Take(model.count); salaryList = query.Select(x => new SalarySearchViewModel() { id = x.Id, fullName = x.Person.FirstName + " " + x.Person.LastName, workHours = x.WorkHours, branch = x.Person.Branch.Name, monthCalculatedDate = x.MonthCalculated }).ToList(); salaryList.ForEach(x => x.monthCalculated = DateUtility.GetPersianDate(x.monthCalculatedDate)); } response = new Response() { status = 200, data = new { list = salaryList, pageCount = Math.Ceiling((double)dataCount / model.count), count = dataCount, page = model.page + 1 } }; } catch (Exception ex) { response = Core.GetExceptionResponse(ex); } return(Json(response, JsonRequestBehavior.AllowGet)); }
public JsonResult ReturnDataValue(InfoInventoryViewModel model) { Response response; try { var fromDate = DateUtility.GetDateTime(model.date); var firstDayOfMonth = new DateTime(fromDate.Value.Year, fromDate.Value.Month, 1); fromDate = firstDayOfMonth; string[] datePart = model.date.Split('/'); string Month = datePart[1]; int numberMonth = Convert.ToInt32(Month); var toDate = fromDate.Value.AddDays(30); if (numberMonth <= 6) { toDate = fromDate.Value.AddDays(31); } using (var db = new KiaGalleryContext()) { List <DailyInventoryDetailViewModel> item; item = db.InventoryDetail.Where(x => x.CreateDate >= fromDate && x.CreateDate <= toDate).Select(x => new DailyInventoryDetailViewModel { date = x.Date, }).ToList(); item.ForEach(x => { x.persianDate = DateUtility.GetPersianDate(x.date); }); response = new Response() { status = 200, data = new { list = item, } }; } } catch (Exception ex) { response = Core.GetExceptionResponse(ex); } return(Json(response, JsonRequestBehavior.AllowGet)); }
/// <summary> /// بارگذاری اطلاعات از قبیل :تعداد فاکتور صادر شده برای هر شعبه /// </summary> /// <param name="date"></param> /// <returns></returns> public JsonResult Search(string date, int?branchId) { var dateTime = DateUtility.GetDateTime(date); Response response; try { var currentuser = GetAuthenticatedUserId(); using (var db = new KiaGalleryContext()) { var query = db.BranchFactor.Select(x => x); if (date != null) { query = query.Where(x => DbFunctions.TruncateTime(x.Date) == dateTime); } var list = query.GroupBy(x => x.Branch).Select(x => new BranchFactorSearchViewModel() { branchId = x.Key.Id, branchName = x.Key.Name, number = x.Sum(y => (y.Number)), factorCount = db.CustomerFactor.Count(y => y.BranchId == x.Key.Id && y.Date == dateTime), }).ToList(); list.ForEach(x => { x.persianDate = DateUtility.GetPersianDate(x.date); }); response = new Response() { status = 200, data = new { list = list } }; } } catch (Exception ex) { response = Core.GetExceptionResponse(ex); } return(Json(response, JsonRequestBehavior.AllowGet)); }
public JsonResult Search(SearchSmsViewModel model) { Response response; try { int dataCount = 0; using (var db = new KiaGalleryContext()) { var query = db.Sms.Select(x => x); dataCount = query.Count(); var list = query.OrderByDescending(x => x.Id).Skip(model.page * model.count).Take(model.count).Select(x => new SearchSmsViewModel { id = x.Id, text = x.Text, phoneNumber = x.DestinationNumber, time = x.Time, date = x.SendingDate, type = x.SendingTimeMethod }).ToList(); list.ForEach(x => { x.persianDate = DateUtility.GetPersianDate(x.date); }); response = new Response() { status = 200, data = new { list, pageCount = Math.Ceiling((double)dataCount / model.count), count = dataCount, page = model.page + 1, } }; } } catch (Exception ex) { response = Core.GetExceptionResponse(ex); } return(Json(response, JsonRequestBehavior.AllowGet)); }
static void Main(string[] args) { TimeSpan timer = TimeSpan.FromMinutes(30); Console.ForegroundColor = ConsoleColor.DarkGreen; Console.WriteLine("program started..."); var numbers = new List <string>() { "09124254257", "09122196672", "09128639319", "09122010861", "09126046937", "09124598925", "09126904936", "09361604970", "09354047788" }; //var numbers = new List<string>() { "09354047788" }; NikSmsWebServiceClient.SendSmsNik("همکار گرامی؛\n لطفا اطلاعات فروش وزنی شعبه را در پنل کاربری به روز نمایید.\n با تشکر", numbers); Console.WriteLine("text messages sent..."); System.Threading.Thread.Sleep(timer); Console.WriteLine("waited 30 minutes..."); using (var db = new KiaGalleryMainContextEntities()) { Console.WriteLine("runnig rest of the codes...."); var data = db.BranchGolds.Where(x => x.CreateDate >= DateTime.Today).GroupBy(x => x.Branches).Select(y => new { weight = y.OrderByDescending(x => x.Id).Select(x => x.Weight).FirstOrDefault(), price = y.OrderByDescending(x => x.Id).Select(x => x.Price).FirstOrDefault(), branch = y.Key.Name, }).ToList(); var persianDate = DateUtility.GetPersianDate(DateTime.Now); double sum = data.Sum(x => x.weight); long priceSum = data.Sum(x => x.price); var rate = priceSum / sum * 4.3318; string message = persianDate + " \n جمع کل: " + sum + " گرم " + " \n جمع قیمت: " + Core.ToSeparator(priceSum) + " ریال " + " \n میانگین مظنه: " + Core.ToSeparator(rate) + " ریال " + "\n"; foreach (var item in data) { message += "شعبه " + item.branch + ": " + item.weight + " گرم " + Core.ToSeparator(item.price) + " ریال \n"; } var managerNumber = new List <string>() { "09124516569", "09126304190", "09124254257", "09123430339", "09128069061", "09127799048", "09359120525", "09354047788" }; //var managerNumber = new List<string>() { "09354047788" }; NikSmsWebServiceClient.SendSmsNik(message.Trim(), managerNumber); } Console.WriteLine("Job Done!"); }
public JsonResult GetCount() { Response response; var currentUser = GetAuthenticatedUser(); try { using (var db = new KiaGalleryContext()) { var query = db.BranchGold.Select(x => x); if (!User.IsInRole("admin") || User.IsInRole("soldGoldManage") || User.IsInRole("soldGold")) { query = query.Where(x => x.BranchId == currentUser.BranchId); } var list = query.GroupBy(x => new { Date = DbFunctions.TruncateTime(x.Date) }).Select(x => new BranchGoldSearchViewModel() { date = x.Key.Date, count = x.Count(), lastWeight = x.OrderByDescending(y => y.Id).FirstOrDefault().Weight, }).ToList(); list.ForEach(x => { x.stringDate = DateUtility.GetPersianDate(x.date); }); response = new Response() { status = 200, data = new { list = list } }; } } catch (Exception ex) { response = Core.GetExceptionResponse(ex); } return(Json(response, JsonRequestBehavior.AllowGet)); }
/// <summary> /// چاپ برگه فاکتور سفارش به صورت html /// </summary> /// <param name="id"></param> /// <returns></returns> public ActionResult PrintOrderPage(int id) { using (var db = new KiaGalleryContext()) { var user = GetAuthenticatedUser(); var entity = db.OrderUsableProductDetail.Where(x => x.OrderUsableProductId == id && x.UsableProduct.PrintingHouseId == user.PrintingHouseId); var list = entity.Select(item => new ShowOrderUsableProductViewModel { name = item.UsableProduct.Name, code = item.UsableProduct.Code, unit = item.UsableProduct.Unit, category = item.UsableProduct.CategoryUsableProduct.Title, createDate = item.CreateDate, productCount = item.Count, officeInventory = item.OfficeInventory.Value, remain = item.Remain.Value, delivered = item.Delivered, printingHouseInventory = item.PrintingHouseInventory, remainFinal = item.RemainFinal, readyForDelivery = item.ReadyForDelivery, specification = item.Specification, }).ToList(); list.ForEach(x => { x.orderUsableProductStatusTitle = Enums.GetTitle(x.orderUsableProductStatus); x.persianDate = DateUtility.GetPersianDate(x.createDate); }); ViewBag.OrderUsableProductDetailList = list; ViewBag.Branch = entity.Select(x => x.OrderUsableProduct.Branch.Name).FirstOrDefault(); ViewBag.BranchPhone = entity.Select(x => x.OrderUsableProduct.Branch.Phone).FirstOrDefault(); ViewBag.Order = entity.Select(x => x.OrderUsableProduct.Branch.Alias + "-" + x.OrderUsableProduct.Id).FirstOrDefault(); ViewBag.Address = entity.Select(x => x.OrderUsableProduct.Branch.Address).FirstOrDefault(); ViewBag.PrintingHouseOrderTitle = entity.Select(x => x.UsableProduct.PrintingHouse.Name).FirstOrDefault(); var date = entity.Select(x => x.CreateDate).FirstOrDefault(); var finaldate = DateUtility.GetPersianDate(date); ViewBag.Date = finaldate; ViewBag.NowTime = DateUtility.GetPersianDate(DateTime.Now); } return(View()); }