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