private void DatePicker_DateChanged(object sender, FarsiDatePickerEventArgs e)
{
var datePicker = (FarsiCalendar)sender;
var mes = string.Format("Old FarsiDate: {0}New FarsiDate: {1}DatePicker Format: {2}Persian SelectedDate: {3}Gregorian SelectedDate: {4}" +
"Number Of Days In Persian SelectedMonth: {5}Persian Year: {6}Persian Month: {7}Persian Day: {8}Persian selectedDate In Long Format: {9}Is Holiday: {10}",
e.OldFarsiDate + Environment.NewLine,
e.NewFarsiDate + Environment.NewLine,
datePicker.Value.Format + Environment.NewLine,
datePicker.Value.FarsiSelectedDate + Environment.NewLine,
datePicker.Value.GregorianSelectedDate.ToShortDateString() + Environment.NewLine,
datePicker.Value.NumberOfDaysInFarsiSelectedMonth + Environment.NewLine,
datePicker.Value.FarsiYear + Environment.NewLine,
datePicker.Value.FarsiMonth + Environment.NewLine,
datePicker.Value.FarsiDay + Environment.NewLine,
FarsiDateHelper.GetLongFarsiDate(datePicker.Value.GregorianSelectedDate) + Environment.NewLine,
FarsiDateHelper.IsHolidayFarsiDate(datePicker.Value.FarsiSelectedDate) ? "تعطیل" : "غیر تعطیل");
//MessageBox.Show(mes);
}
private void farsiCalendar1_DateChanged_1(object sender, FarsiDatePickerEventArgs e)
{
var datePicker = (FarsiCalendar)sender;
SqlParameter[] param;
param = new SqlParameter[3];
int index = 0;
param[index++] = new SqlParameter("@Month", datePicker.Value.FarsiSelectedDate.Split('/')[1]);
param[index++] = new SqlParameter("@Day", datePicker.Value.FarsiSelectedDate.Split('/')[2]);
param[index++] = new SqlParameter("@SectionID", SID);
bool IsHoliday;
string eventlog = "GetHolidays for SectionID=" + SID + "Month=" + datePicker.Value.FarsiSelectedDate.Split('/')[1] + "Day=" + datePicker.Value.FarsiSelectedDate.Split('/')[2];
try
{
IsHoliday = Convert.ToBoolean(da.ExecuteSP("GetHolidays", param).Tables[0].Rows[0][0]);
}
catch
{
NewMethod_eventlog(eventlog, 16011);
throw;
}
var mes = string.Format("روز:" + "{0}" +
" {1}", datePicker.Value.FarsiSelectedDate
, FarsiDateHelper.GetLongFarsiDate(datePicker.Value.GregorianSelectedDate),
"این روز تعطیل است. آیا غیر تعطیل باشد؟");
if (!IsHoliday)
{
SqlParameter[] p;
p = new SqlParameter[2];
int i = 0;
p[i++] = new SqlParameter("@DayOfWeek", (FarsiDateHelper.DayOfWeeknum(datePicker.Value.GregorianSelectedDate)));
p [i++] = new SqlParameter("@DepID", SID);
int z = (int)(datePicker.Value.GregorianSelectedDate.DayOfWeek);
DataTable shifts = da.ExecuteSP("checkForHolidays", p).Tables[0];
var mess = "";
if (shifts.Rows.Count != 0)
{
mess = string.Format("این روز دارای:" + "{0}" + "شیفت فعال است. آیا این روز تعطیل باشد؟", shifts.Rows.Count);
foreach (DataRow dr in shifts.Rows)
{
mess = mess + string.Format(" {0}:" + "از" + " {1} " + "تا" + " {2} ", dr["ShiftName"], dr["StartTime"], dr["EndTime"] + Environment.NewLine);
}
MessageFormResult r = MessageForm.Show(mess, "", MessageFormIcons.Question, MessageFormButtons.YesNo, color);
if (r == MessageFormResult.Yes)
{
SqlParameter[] pa;
pa = new SqlParameter[3];
int ind = 0;
pa[ind++] = new SqlParameter("@SectionID", SID);
pa[ind++] = new SqlParameter("@Month", datePicker.Value.FarsiSelectedDate.Split('/')[1]);
pa[ind++] = new SqlParameter("@Day", datePicker.Value.FarsiSelectedDate.Split('/')[2]);
string eventlog1 = "SetHolidays for SectionID=" + SID + "Month=" + datePicker.Value.FarsiSelectedDate.Split('/')[1] + "Day=" + datePicker.Value.FarsiSelectedDate.Split('/')[2];
try
{
da.ExecuteSP("SetHolidays", pa);
}
catch
{
NewMethod_eventlog(eventlog1, 16012);
throw;
}
}
}
else
{
MessageFormResult r = MessageForm.Show(mes, "", MessageFormIcons.Question, MessageFormButtons.YesNo, color);
if (r == MessageFormResult.Yes)
{
SqlParameter[] pa;
pa = new SqlParameter[3];
int ind = 0;
pa[ind++] = new SqlParameter("@SectionID", SID);
pa[ind++] = new SqlParameter("@Month", datePicker.Value.FarsiSelectedDate.Split('/')[1]);
pa[ind++] = new SqlParameter("@Day", datePicker.Value.FarsiSelectedDate.Split('/')[2]);
string eventlog1 = "DeleteHolidays for SectionID=" + SID + "Month=" + datePicker.Value.FarsiSelectedDate.Split('/')[1] + "Day=" + datePicker.Value.FarsiSelectedDate.Split('/')[2];
try
{
da.ExecuteSP("DelHolidays", pa);
}
catch
{
NewMethod_eventlog(eventlog1, 16013);
throw;
}
}
}
}
else
{
var notH = string.Format("روز:" + "{0}" +
" {1}",
// e.NewFarsiDate + Environment.NewLine,
datePicker.Value.FarsiSelectedDate + Environment.NewLine,
// datePicker.Value.GregorianSelectedDate.ToShortDateString() + Environment.NewLine,
//datePicker.Value.NumberOfDaysInFarsiSelectedMonth + Environment.NewLine,
//FarsiDateHelper.GetLongFarsiDate(datePicker.Value.GregorianSelectedDate) + Environment.NewLine,
IsHoliday ? "این روز تعطیل است. آیا غیر تعطیل باشد؟" : "این روز غیرتعطیل است. آیا تعطیل باشد؟");
MessageFormResult r = MessageForm.Show(notH, "", MessageFormIcons.Question, MessageFormButtons.YesNo, color);
if (r == MessageFormResult.Yes)
{
SqlParameter[] par;
par = new SqlParameter[3];
int ind = 0;
par[ind++] = new SqlParameter("@SectionID", SID);
par[ind++] = new SqlParameter("@Month", datePicker.Value.FarsiSelectedDate.Split('/')[1]);
par[ind++] = new SqlParameter("@Day", datePicker.Value.FarsiSelectedDate.Split('/')[2]);
string eventlog1 = "DeleteHolidays for SectionID=" + SID + "Month=" + datePicker.Value.FarsiSelectedDate.Split('/')[1] + "Day=" + datePicker.Value.FarsiSelectedDate.Split('/')[2];
try
{
da.ExecuteSP("DelHolidays", par);
}
catch
{
NewMethod_eventlog(eventlog1, 16013);
throw;
}
}
}
}
void BirthDate_CellDateChanged(DataGridViewFarsiDatePickerCell cell, FarsiDatePickerEventArgs e)
{
MessageBox.Show(string.Format(" Cell[{0},{1}] \r\n Old FarsiDate: {2} \r\n New FarsiDate: {3}", cell.RowIndex,
cell.ColumnIndex, e.OldFarsiDate, e.NewFarsiDate));
}
private void farsiCalendar1_DateChanged_1(object sender, FarsiDatePickerEventArgs e)
{
var datePicker = (FarsiCalendar)sender;
SqlParameter[] param;
param = new SqlParameter[3];
int index = 0;
param[index++] = new SqlParameter("@SectionID", -1);
param[index++] = new SqlParameter("@Month", datePicker.Value.FarsiSelectedDate.Split('/')[1]);
param[index++] = new SqlParameter("@Day", datePicker.Value.FarsiSelectedDate.Split('/')[2]);
bool IsHoliday;
string eventlog = "GetHolidays for SectionID=" + -1 + "Month=" + datePicker.Value.FarsiSelectedDate.Split('/')[1] + "Day=" + datePicker.Value.FarsiSelectedDate.Split('/')[2];
try
{
IsHoliday = Convert.ToBoolean(da.ExecuteSP("GetHolidays", param).Tables[0].Rows[0][0]);
}
catch
{
NewMethod_eventlog(eventlog, 16011);
throw;
}
if (CalenderEnable)
{
var mes = string.Format("روز:" +
"{0}",
// e.NewFarsiDate + Environment.NewLine,
// datePicker.Value.GregorianSelectedDate.ToShortDateString() + Environment.NewLine,
//datePicker.Value.NumberOfDaysInFarsiSelectedMonth + Environment.NewLine,
FarsiDateHelper.GetLongFarsiDate(datePicker.Value.GregorianSelectedDate) +
"این روز تعطیل است. آیا غیر تعطیل باشد؟");
if (!IsHoliday)
{
string mess;
mess = string.Format("این روز کاری است. آیا تعطیل باشد؟");
MessageFormResult r = MessageForm.Show(mess, "", MessageFormIcons.Question, MessageFormButtons.YesNo, color);
if (r == MessageFormResult.Yes)
{
SqlParameter[] pa;
pa = new SqlParameter[3];
int ind = 0;
pa[ind++] = new SqlParameter("@SectionID", -1);
pa[ind++] = new SqlParameter("@Month", datePicker.Value.FarsiSelectedDate.Split('/')[1]);
pa[ind++] = new SqlParameter("@Day", datePicker.Value.FarsiSelectedDate.Split('/')[2]);
string eventlog1 = "SetHolidays for SectionID=" + -1 + "Month=" + datePicker.Value.FarsiSelectedDate.Split('/')[1] + "Day=" + datePicker.Value.FarsiSelectedDate.Split('/')[2];
try
{
da.ExecuteSP("SetHolidays", pa);
}
catch
{
NewMethod_eventlog(eventlog1, 16012);
throw;
}
}
}
else
{
MessageFormResult r = MessageForm.Show(mes, "", MessageFormIcons.Question, MessageFormButtons.YesNo, color);
if (r == MessageFormResult.Yes)
{
SqlParameter[] pa;
pa = new SqlParameter[3];
int ind = 0;
pa[ind++] = new SqlParameter("@SectionID", -1);
pa[ind++] = new SqlParameter("@Month", datePicker.Value.FarsiSelectedDate.Split('/')[1]);
pa[ind++] = new SqlParameter("@Day", datePicker.Value.FarsiSelectedDate.Split('/')[2]);
string eventlog1 = "DeleteHolidays for SectionID=" + -1 + "Month=" + datePicker.Value.FarsiSelectedDate.Split('/')[1] + "Day=" + datePicker.Value.FarsiSelectedDate.Split('/')[2];
try
{
da.ExecuteSP("DelHolidays", pa);
}
catch
{
NewMethod_eventlog(eventlog1, 16013);
throw;
}
}
}
}
else
{
var mes = string.Format("روز:" +
" {0}",
// e.NewFarsiDate + Environment.NewLine,
// datePicker.Value.GregorianSelectedDate.ToShortDateString() + Environment.NewLine,
//datePicker.Value.NumberOfDaysInFarsiSelectedMonth + Environment.NewLine,
FarsiDateHelper.GetLongFarsiDate(datePicker.Value.GregorianSelectedDate) +
"این روز تعطیل است.");
if (!IsHoliday)
{
string mess;
mess = string.Format("روز:" + " {0}",
FarsiDateHelper.GetLongFarsiDate(datePicker.Value.GregorianSelectedDate) +
"این روز کاری است.");
MessageForm.Show(mess, "", MessageFormIcons.Question, MessageFormButtons.Ok, color);
}
else
{
MessageForm.Show(mes, "", MessageFormIcons.Question, MessageFormButtons.Ok, color);
}
}
}
