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());
}
