public void PersianDateTimeTests()
{
//PersianDateTime is utility data type for GregorianDateTime to/from PersianDateTime conversions.
var pNow = PersianDateTime.Now;
var clrDate = DateTime.Now;
//Convert an instance of CLR-DateTime to PersianDateTime
PersianDateTime faDateTime = clrDate.ToPersianDateTime();
//Convert an instance of PersianDateTime to CLR-DateTime
clrDate = faDateTime.ToDateTime();
Debug.WriteLine(faDateTime.Hour12); // Hour based on 12Hours
Debug.WriteLine(faDateTime.IsAfternoon); // ...
//Convert persian date time string to PersianDateTime
faDateTime = PersianDateTime.Parse("1395/10/1 5:1 ب.ظ");
//writes name of week day
Debug.WriteLine("MonthName: {0}\nDayName: {1}", faDateTime.MonthName, faDateTime.DayName);
//well form date time display :-)
Debug.WriteLine(PersianDateTime.Parse("1395/10/19").ToString("dddd d MMMM yyyy")); // یکشنبه 19 دی 1395
Debugger.Break();
}
private DateTime FromOldExcelDateTime(string InDate)
{
string persianDate = InDate;
string[] userDateParts = persianDate.Split(new[] { "/" }, System.StringSplitOptions.None);
int Year = int.Parse(userDateParts[2]);
int Month = int.Parse(userDateParts[1]);
int Day = int.Parse(userDateParts[0]);
var persianDateTime = new PersianDateTime(Year, Month, Day);
return(persianDateTime.ToDateTime());
}
public async Task <RepResult <MonthVM> > GetMonthData(int personnelId, string shamsiMonthDate)
{
if (dbContext != null)
{
var monthVm = new MonthVM();
monthVm.PersonnelId = personnelId;
PersianDateTime perDt = PersianDateTime.Parse((shamsiMonthDate + "-01").Replace("-", "/"));
DateTime firstDayDt = perDt.ToDateTime();
PersianCalendar pc = new PersianCalendar();
monthVm.Year = pc.GetYear(firstDayDt).ToString();
monthVm.MonthName = getMonthName(pc.GetMonth(firstDayDt));
var lenDays = pc.GetDaysInMonth(perDt.Year, perDt.Month);
monthVm.Days = new List <DayVM>();
monthVm.Duration = new DurationVM();
for (int i = 1; i < lenDays; i++)
{
var dayDate = new DateTime(firstDayDt.Year, firstDayDt.Month, firstDayDt.Day);
if (i > 1)
{
dayDate = dayDate.AddDays(i);
}
var dayVm = (await dayRep.GetDayData(personnelId, dayDate)).ResultObject;
monthVm.Days.Add(dayVm);
monthVm.Duration.DurationOfWorkSecends += dayVm.Duration.DurationOfWorkSecends;
monthVm.Duration.DurationOfLeaveSecends += dayVm.Duration.DurationOfLeaveSecends;
monthVm.Duration.DurationOfMisiionSecends += dayVm.Duration.DurationOfMisiionSecends;
monthVm.Duration.DurationOfOverTimeSecends += dayVm.Duration.DurationOfOverTimeSecends;
}
monthVm.Duration.DurationOfWork = Environment.Convert.TimeSpanToReadableString(TimeSpan.FromSeconds(monthVm.Duration.DurationOfWorkSecends));
monthVm.Duration.DurationOfLeave = Environment.Convert.TimeSpanToReadableString(TimeSpan.FromSeconds(monthVm.Duration.DurationOfLeaveSecends));
monthVm.Duration.DurationOfMisiion = Environment.Convert.TimeSpanToReadableString(TimeSpan.FromSeconds(monthVm.Duration.DurationOfMisiionSecends));
monthVm.Duration.DurationOfOverTime = Environment.Convert.TimeSpanToReadableString(TimeSpan.FromSeconds(monthVm.Duration.DurationOfOverTimeSecends));
return(new RepResult <MonthVM> {
Successed = true, ResultObject = monthVm
});
}
return(new RepResult <MonthVM>());
}
public static DateTime ToGeorgianDateTime(this string dateTime)
{
var date = (dateTime.Split('/')).Select(s => int.Parse(s)).ToArray();
try
{
PersianDateTime persianDate = new PersianDateTime(date[0], date[1], date[2]);
var x = persianDate.ToDateTime();
return(x);
}
catch (Exception ex)
{
throw new Exception(ex.Message);
}
}
public ActionResult AddAuction(AuctionAddViewModel model)
{
TimeSpan tooBig = new TimeSpan(2, 8, 8, 8);
//yourDbEntity.timeValue = temp;
PersianDateTime persianDate = new PersianDateTime();
var dd = model.Date.Split('-');
persianDate = new PersianDateTime(int.Parse(dd[0]), int.Parse(dd[1]), int.Parse(dd[2]), model.Auction_Time.Hours, model.Auction_Time.Minutes, 0);
var dateMi = persianDate.ToDateTime(); //convert datetime Persian to miladi
var cur = DateTime.Now.AddSeconds(-DateTime.Now.Second); //datetime without seconde
var def = dateMi.Subtract(cur); //get def
var auction_Time = new TimeSpan(def.Days, def.Hours, def.Minutes, 0, 0);
var h = auction_Time.Days * 24;
var hh = h + auction_Time.Hours;
var timestring = auction_Time.TotalHours;
//to database
Int64 tooBigBits = auction_Time.Ticks;
Int64 truncated = tooBigBits >> 24;
TimeSpan temp = TimeSpan.FromTicks(truncated);
//from database
//Int64 truncated1 = temp.Ticks;
//Int64 adjusted = truncated1 << 24;
//TimeSpan actual = TimeSpan.FromTicks(adjusted);
model.Auction_Time = temp;
var result = repo.AddAuction(model);
if (result)
{
return(RedirectToAction("Index"));
}
else
{
var allProduct = ProRepo.GetProForDop();
return(View(allProduct));
}
}
public ActionResult UsersSellInfoList(int?i, string FromDate, string ToDate)
{
if (Session["UserId"] != null)
{
Dictionary <char, char> LettersDictionary = new Dictionary <char, char>
{
['/'] = '/', ['۰'] = '0', ['۱'] = '1', ['۲'] = '2', ['۳'] = '3', ['۴'] = '4', ['۵'] = '5', ['۶'] = '6', ['۷'] = '7', ['۸'] = '8', ['۹'] = '9', ['0'] = '0', ['1'] = '1', ['2'] = '2', ['3'] = '3', ['4'] = '4', ['5'] = '5', ['6'] = '6', ['7'] = '7', ['8'] = '8', ['9'] = '9'
};
foreach (var item in FromDate)
{
FromDate = FromDate.Replace(item, LettersDictionary[item]);
}
foreach (var item in ToDate)
{
ToDate = ToDate.Replace(item, LettersDictionary[item]);
}
PersianDateTime FromD = PersianDateTime.Parse(FromDate);
DateTime miladiFromD = FromD.ToDateTime();
PersianDateTime ToD = PersianDateTime.Parse(ToDate);
DateTime miladiToD = ToD.ToDateTime();
List <UserShopingInfo> UserList = (_context.Database.SqlQuery <UserShopingInfo>(@"select Tbl_User.Name , Tbl_User.Id , Tbl_User.BIZCode ,sum(CAST(Tbl_SirjanPurchase.Price AS bigint)) AS [TotalPurchase] from Tbl_User inner join Tbl_SirjanPurchase on Tbl_User.Id = Tbl_SirjanPurchase.UserId WHERE Tbl_SirjanPurchase.PurchaseId = 1 and Tbl_SirjanPurchase.MiladiDate > '" + miladiFromD + "' and Tbl_SirjanPurchase.MiladiDate< '" + miladiToD + "' group by Tbl_User.Name,Tbl_User.Id,Tbl_User.BIZCode")).ToList();
string TotalPrice = (_context.Database.SqlQuery <string>(@"SELECT CAST(sum(CAST(Tbl_SirjanPurchase.Price AS int))AS varchar) AS [TotalPrice] from Tbl_User inner join Tbl_SirjanPurchase on Tbl_User.Id = Tbl_SirjanPurchase.UserId WHERE Tbl_SirjanPurchase.PurchaseId = 1 and Tbl_SirjanPurchase.MiladiDate > '" + miladiFromD + "' and Tbl_SirjanPurchase.MiladiDate< '" + miladiToD + "'")).FirstOrDefault <string>();
ViewBag.TotalPrice = TotalPrice;
var viewmodel = new UserInformationsIpagedList
{
IpagedListUserInfo = UserList.ToList().ToPagedList(i ?? 1, 100000)
};
return(View(viewmodel));
}
else
{
return(RedirectToAction("Login", "Home"));
}
}
public async Task <IActionResult> GetDayData(int personnelId, string shamsiDayDate)
{
try
{
PersianDateTime prsDt = PersianDateTime.Parse(shamsiDayDate.Replace("-", "/"));
var obj = (await dayRep.GetDayData(personnelId, prsDt.ToDateTime()));
if (obj.Successed)
{
return(Ok(obj.ResultObject));
}
else
{
return(NotFound(obj));
}
}
catch (Exception)
{
return(BadRequest());
}
}
public JsonResult GetVaredeAndSadere(ProductInStockpileModelView SenderObj)
{
if (ModelState.IsValid)
{
if (SenderObj != null)
{
int id_Mpc = 0;
if (Int32.TryParse(SenderObj.InOutStructures.id_Mpc, out id_Mpc))
{
string id_CreatedByAdmin = "0";
if (Session["AdministratorRegistery"] != null)
{
id_CreatedByAdmin = ((Administrator)Session["AdministratorRegistery"]).id_Admin;
}
else
{
var coockie = HttpContext.Request.Cookies.Get(ProjectProperies.AuthCoockieCode());
Administrator administratorobj = CoockieController.SayMyName(coockie.Value);
id_CreatedByAdmin = administratorobj.id_Admin;
}
PDBC db = new PDBC();
db.Connect();
using (DataTable dt = db.Select("SELECT [id_PQT] ,[PriceModule] FROM [tlb_Product_MainProductConnector] WHERE [id_MPC] = " + id_Mpc))
{
using (DataTable dtStockpile = db.Select("SELECT [id_Stockpile] FROM [tbl_Modules_StockpileMainTable] WHERE [id_MPC] = " + id_Mpc))
{
db.DC();
if (dtStockpile.Rows.Count > 0)
{
if (dt.Rows.Count > 0)
{
List <ExcParameters> allpars = new List <ExcParameters>();
ExcParameters par = new ExcParameters()
{
_KEY = "@id_TransactionType",
_VALUE = SenderObj.InOutStructures.Whichone
};
allpars.Add(par);
par = new ExcParameters()
{
_KEY = "@id_Stockpile",
_VALUE = dtStockpile.Rows[0]["id_Stockpile"].ToString()
};
allpars.Add(par);
if (SenderObj.InOutStructures.Whichone == "1")
{
par = new ExcParameters()
{
_KEY = "@shop_id",
_VALUE = SenderObj.InOutStructures.Shopid1
};
allpars.Add(par);
}
else
{
par = new ExcParameters()
{
_KEY = "@shop_id",
_VALUE = SenderObj.InOutStructures.shopid2
};
allpars.Add(par);
}
string[] dates = SenderObj.InOutStructures.ActionDate.Split('/');
string[] times = SenderObj.InOutStructures.Time.Split(':');
PersianDateTime persianDateTime = new PersianDateTime(Convert.ToInt32(dates[0]), Convert.ToInt32(dates[1]), Convert.ToInt32(dates[2]), Convert.ToInt32(times[0]), Convert.ToInt32(times[1]), 0);
par = new ExcParameters()
{
_KEY = "@StockpileDate_Transaction",
_VALUE = persianDateTime.ToDateTime()
};
allpars.Add(par);
par = new ExcParameters()
{
_KEY = "@StockpileTime_Transaction",
_VALUE = SenderObj.InOutStructures.Time
};
allpars.Add(par);
par = new ExcParameters()
{
_KEY = "@id_PQT",
_VALUE = dt.Rows[0]["id_PQT"].ToString()
};
allpars.Add(par);
par = new ExcParameters()
{
_KEY = "@MoneyId",
_VALUE = dt.Rows[0]["PriceModule"].ToString()
};
allpars.Add(par);
par = new ExcParameters()
{
_KEY = "@PriceOf_Transaction",
_VALUE = SenderObj.InOutStructures.INOUTPrice
};
allpars.Add(par);
par = new ExcParameters()
{
_KEY = "@PQTValueOf_Transaction",
_VALUE = SenderObj.InOutStructures.INOUTValue
};
allpars.Add(par);
if (!string.IsNullOrEmpty(SenderObj.InOutStructures.Description))
{
par = new ExcParameters()
{
_KEY = "@Description_Transaction",
_VALUE = SenderObj.InOutStructures.Description
};
allpars.Add(par);
}
else
{
par = new ExcParameters()
{
_KEY = "@Description_Transaction",
_VALUE = ""
};
allpars.Add(par);
}
par = new ExcParameters()
{
_KEY = "@id_SubmiterAdmin",
_VALUE = id_CreatedByAdmin
};
allpars.Add(par);
db.Connect();
string result = db.Script("INSERT INTO [tbl_Modules_StockpileTransactionMainTable]([id_TransactionType],[id_Stockpile],[shop_id],[StockpileDate_Transaction],[StockpileTime_Transaction],[id_PQT],[MoneyId],[PriceOf_Transaction],[PQTValueOf_Transaction],[Description_Transaction],[id_SubmiterAdmin]) VALUES(@id_TransactionType,@id_Stockpile,@shop_id,@StockpileDate_Transaction,@StockpileTime_Transaction,@id_PQT,@MoneyId,@PriceOf_Transaction,@PQTValueOf_Transaction,@Description_Transaction,@id_SubmiterAdmin)", allpars);
db.DC();
if (result == "1")
{
var ModelSender = new ErrorReporterModel
{
ErrorID = "SX1645605",
Errormessage = $"اطلاعات با موفقیت ثبت شد!",
Errortype = "Success"
};
return(Json(ModelSender));
}
else
{
PPBugReporter rep = new PPBugReporter(BugTypeFrom.SQL, "IN Controller : {AdministratorStockpileController}\nMethod : {public JsonResult GetVarede(ProductInStockpileModelView senderObj) Script : INSERT INTO [tbl_Modules_StockpileTransactionMainTable]([id_TransactionType],[id_Stockpile],[shop_id],[Submitdate_Transaction],[StockpileDate_Transaction],[StockpileTime_Transaction],[id_PQT],[MoneyId],[PriceOf_Transaction],[PQTValueOf_Transaction],[Description_Transaction],[id_SubmiterAdmin]) VALUES(@id_TransactionType,@id_Stockpile,@shop_id,@Submitdate_Transaction,@StockpileDate_Transaction,@StockpileTime_Transaction,@id_PQT,@MoneyId,@PriceOf_Transaction,@PQTValueOf_Transaction,@Description_Transaction,@id_SubmiterAdmin) ||| Result :" + result);
var ModelSender = new ErrorReporterModel
{
ErrorID = "EX1186781",
Errormessage = $"عدم توانایی در ثبت اطلاعات",
Errortype = "Error"
};
return(Json(ModelSender));
}
}
else
{
var ModelSender = new ErrorReporterModel
{
ErrorID = "EX645756697",
Errormessage = $"محصول مورد نظر یافت نشد",
Errortype = "Error"
};
return(Json(ModelSender));
}
}
else
{
var ModelSender = new ErrorReporterModel
{
ErrorID = "EX645697",
Errormessage = $"محصول مورد نظر یافت نشد",
Errortype = "Error"
};
return(Json(ModelSender));
}
}
}
}
else
{
var ModelSender = new ErrorReporterModel
{
ErrorID = "EX1897",
Errormessage = $"اطلاعات وارده خلاف متغیر های قانونی میباشد!",
Errortype = "Error"
};
return(Json(ModelSender));
}
}
else
{
PPBugReporter rep = new PPBugReporter(BugTypeFrom.SQL, "IN Controller : {AdministratorStockpileController}\nMethod : {public JsonResult GetVarede(ProductInStockpileModelView senderObj) (senderObj == null)");
var ModelSender = new ErrorReporterModel
{
ErrorID = "EX111",
Errormessage = $"ورود متغیر خلاف پروتکل های امنیتی",
Errortype = "Error"
};
return(Json(ModelSender));
}
}
else
{
List <ModelErrorReporter> allErrors = new List <ModelErrorReporter>();
//foreach (ModelError error in ModelState.Values.)
var AllValues = ModelState.Values.ToList();
var AllKeys = ModelState.Keys.ToList();
int errorsCount = AllValues.Count;
for (int i = 0; i < errorsCount; i++)
{
if (AllValues[i].Errors.Count > 0)
{
ModelErrorReporter er = new ModelErrorReporter()
{
IdOfProperty = AllKeys[i].Replace("InOutStructures.", "InOutStructures_"),
ErrorMessage = AllValues[i].Errors[0].ErrorMessage
};
allErrors.Add(er);
}
}
var ModelSender = new ErrorReporterModel
{
ErrorID = "EX115",
Errormessage = $"عدم رعایت استاندارد ها!",
Errortype = "ErrorWithList",
AllErrors = allErrors
};
return(Json(ModelSender));
}
return(Json(""));
}
public static DateTime ConvertShamsiToMiladi(this string date)
{
PersianDateTime persianDateTime = PersianDateTime.Parse(date);
return(persianDateTime.ToDateTime());
}
public static string ToPersianRelativeDate(this PersianDateTime date)
{
var gDate = date.ToDateTime();
return(gDate.ToPersianRelativeDate());
}
public DateTime ConvertShamsiToMiladi(string Date)
{
PersianDateTime persianDateTime = PersianDateTime.Parse(Date);
return(persianDateTime.ToDateTime());
}
public static DateTime ConvertPersianToGeorgian(this string date)
{
PersianDateTime persianDateTime = PersianDateTime.Parse(date);
return(persianDateTime.ToDateTime());
}
public DateTime ShamsiToMilade(string date)
{
PersianDateTime persianDateTime = PersianDateTime.Parse(date);
return(persianDateTime.ToDateTime());
}
/// <summary>
/// تبدیل تاریخ شمسی به میلادی
/// </summary>
/// <param name="dt">تاریخ شمسی</param>
/// <returns> 9/3/2017 3:16:29 PM </returns>
public static DateTime ToDateTime(this PersianDateTime dt)
{
return(dt.ToDateTime());
}
/// <summary>
/// تبدیل تاریخ شمسی به میلادی
/// </summary>
/// <param name="dt">تاریخ شمسی</param>
/// <returns>Sunday 3 September 2017 </returns>
public static string ToDateString(this PersianDateTime dt)
{
return(dt.ToDateTime().ToString("dddd d MMMM yyyy"));
}
public static string MakeCalender(int year)
{
if (year == 0)
{
year = new PersianDateTime(DateTime.Now).Year;
}
var persiandate = new PersianDateTime(year, 1, 1);
string res = "";
for (int i = 1; i < 5; i++)
{
res += "<div class='row'>";
for (int j = 1; j < 4; j++)
{
res += "<div class='col-md-4' style='text-align: center'>";
res += "<div class='cal'>";
res += " <table class='cal-table'>";
res += "<caption class='cal-caption'>";
res += persiandate.GetLongMonthName;
//res += monthCounter.ToString();
res += "</caption>";
res += "<tbody class='cal-body'>";
int emptyCells = ((int)persiandate.DayOfWeek + 7 - 6) % 7;
int days = persiandate.GetMonthDays;
for (int k = 0; k != 42; k++)
{
if (k % 7 == 0)
{
res += "<tr>";
if (k > 0) res += "</tr>";
}
if (k < emptyCells || k >= emptyCells + days)
{
res += "<td class='cal-off'><a href='#'>";
res += "-";
res += "</a></td>";
}
else
{
if (!string.IsNullOrWhiteSpace(TodayVM.GetPersianEvent(persiandate.Month, persiandate.Day)))
res += "<td title='" + TodayVM.GetPersianEvent(persiandate.Month, persiandate.Day)
+ "'" + " class='cal-check'>";
else
{
if (persiandate.ToDateTime().Date == DateTime.Now.Date)
res += "<td class='cal-today'>";
else
res += "<td >";
}
if (persiandate.DayOfWeek == DayOfWeek.Friday)
res += "<a style='color:red;'>";
else
res += "<a>";
var dayNo = "12";
res += TodayVM.ToPersianDigit(persiandate.Day.ToString());
res += "</a></td>";
persiandate = persiandate.AddDays(1);
}
}
res += "</tbody>";
res += "</table>";
res += "</div>";
res += "</div>";
persiandate.AddMonths(1);
}
res += "</div>";
}
return res;
}