static void Main(string[] args)
{
TIME_ZONE_INFORMATION tz = new TIME_ZONE_INFORMATION();
GetTimeZoneInformation(ref tz);
string s = args[0];
System.Globalization.DateTimeFormatInfo dtfi =
new System.Globalization.DateTimeFormatInfo();
dtfi.FullDateTimePattern = "dd/MM/yyyy HH:mm:ss zz";
dtfi.DateSeparator = "/";
dtfi.TimeSeparator = ":";
DateTime dt =
DateTime.Parse(s, dtfi);
SYSTEMTIME time = new SYSTEMTIME(dt);
//time.wDay = (ushort)dt.Day;
//time.wHour = (ushort)dt.Hour;
//time.wDayOfWeek = (ushort)dt.DayOfWeek;
//time.wMilliseconds = (ushort)dt.Millisecond;
//time.wMinute = (ushort)dt.Minute;
//time.wMonth = (ushort)dt.Month;
//time.wSecond = (ushort)dt.Second;
//time.wYear = (ushort)dt.Year;
SetSystemTime(ref time);
}
/// <summary>
/// Weeks the of year.
/// </summary>
/// <param name="datetime">The datetime.</param>
/// <returns></returns>
public static int WeekOfYear(this DateTime datetime)
{
var dateinf = new System.Globalization.DateTimeFormatInfo();
System.Globalization.CalendarWeekRule weekrule = dateinf.CalendarWeekRule;
DayOfWeek firstDayOfWeek = dateinf.FirstDayOfWeek;
return WeekOfYear(datetime, weekrule, firstDayOfWeek);
}
public string CheckDateBeforeAdd(string date)
{
System.Globalization.DateTimeFormatInfo dtfi = new System.Globalization.DateTimeFormatInfo();
System.Globalization.CultureInfo gro = System.Globalization.CultureInfo.GetCultureInfo("en-US");
dtfi.ShortDatePattern = "yyy/MM/dd";
dtfi.DateSeparator = "/";
//convert string to date
//DateTime oldDate = Convert.ToDateTime(date, dtfi);
DateTime oldDate;
try{
oldDate = Convert.ToDateTime(date, dtfi);
newDate = oldDate.ToString("yyyy/MM/dd",dtfi);
}catch{
try{
day=Regex.Split(date,"/");
day[2]=getLastDayOfMonth(day[1]);
oldDate = Convert.ToDateTime(day[0]+@"/"+day[1]+@"/"+day[2], dtfi);
newDate = oldDate.ToString("yyyy/MM/dd",dtfi);
// System.Windows.Forms.MessageBox.Show(day[1]);
}catch(Exception daa){
System.Windows.Forms.MessageBox.Show(daa.Message);
}
}
return newDate;
}
/// @author = KhoaHT
/// @description : Return first or the last day of the current year of the application depend on the param
/// @Create Date = 10/09/2007
public static void GetFirstAndLastDayOfYear(ref DateTime pdteFirstDay, ref DateTime pdteLastDay, int pintYear)
{
System.Globalization.DateTimeFormatInfo info = new System.Globalization.DateTimeFormatInfo();
info.DateSeparator = "/";
info.ShortDatePattern = "ddMMyyyy";
pdteFirstDay = System.Convert.ToDateTime("01/01/" + pintYear, info);
pdteLastDay = System.Convert.ToDateTime("31/12/" + pintYear, info);
}
protected void DaytimeCalendar_SelectionChanged(object sender, EventArgs e)
{
System.Globalization.DateTimeFormatInfo mfi = new System.Globalization.DateTimeFormatInfo();
string monthName = mfi.GetMonthName(DaytimeCalendar.SelectedDate.Month).ToString();
DaySelectedLabel.Text = "You Have Selected: " + DaytimeCalendar.SelectedDate.DayOfWeek.ToString() + ", " + monthName + " " + DaytimeCalendar.SelectedDate.Day.ToString() + ", for a daytime photography appointment.";
Session["PhotoType"] = "7";
ContinueButton.Enabled = true;
//TwilightCalendar.SelectedDates.Clear();
}
/// <summary>
/// Constructor
/// </summary>
/// <param name="format"></param>
public DateViewer(string format)
{
if (!formatDates.ContainsKey(format))
{
System.Globalization.DateTimeFormatInfo formatDate = new System.Globalization.DateTimeFormatInfo();
formatDate.ShortDatePattern = format;
// "yy-MM-dd"; "HH:mm"; "yy-MM-dd HH:mm"; "MM-dd HH:mm";
formatDates.Add(format, formatDate);
}
m_format = formatDates[format];
}
/// <summary>
/// This method initates a recursive Depth-First-Search
/// </summary>
/// <param name="person">Person node</param>
/// <param name="descendantName">Requested person</param>
/// <returns>Person's Birthday property as string. If null, returns Null string object.</returns>
public string GetBirthMonth(Person person, string descendantName)
{
try
{
System.Globalization.DateTimeFormatInfo mfi = new System.Globalization.DateTimeFormatInfo();
// Find person using recursive function
return mfi.GetMonthName(GetDescendant(person, descendantName).Birthday.Month).ToString();
}
// If person is not in list of descendants, GetDescendant will return the empty string
catch (NullReferenceException e)
{
Trace.Write("\n\n" + e.Message + "\n" + e.StackTrace + "\n\n");
return "";
}
}
static void Main(string[] args)
{
string s = args[0];
System.Globalization.DateTimeFormatInfo dtfi =
new System.Globalization.DateTimeFormatInfo();
dtfi.FullDateTimePattern = "dd/MM/yyyy HH:mm:ss";
dtfi.ShortDatePattern = "dd/MM/yyyy";
dtfi.ShortTimePattern = "HH:mm:ss";
dtfi.DateSeparator = "/";
dtfi.TimeSeparator = ":";
string s1 = DateTime.Now.ToString("dd/MM/yyyy HH:mm:ss",dtfi);
string s2 = s.Remove(s.Length - 4,4);
string s3 = s.Substring(s.Length - 4, 4);
DateTime dt =
DateTime.Parse(s2, dtfi);
SYSTEMTIME time = new SYSTEMTIME(dt);
//time.wDay = (ushort)dt.Day;
//time.wHour = (ushort)dt.Hour;
//time.wDayOfWeek = (ushort)dt.DayOfWeek;
//time.wMilliseconds = (ushort)dt.Millisecond;
//time.wMinute = (ushort)dt.Minute;
//time.wMonth = (ushort)dt.Month;
//time.wSecond = (ushort)dt.Second;
//time.wYear = (ushort)dt.Year;
SetLocalTime(ref time);
TIME_ZONE_INFORMATION tzI = new TIME_ZONE_INFORMATION();
GetTimeZoneInformation(ref tzI);
tzI.Bias = int.Parse(s3)*60;
tzI.StandardBias = 0;
//tzI.DaylightBias = 0;
//tzI.StandardName = "Moscow";
//tzI.DaylightName = "Moscow";
//tzI.DaylightDate = time;
//tzI.StandardDate = time;
SetTimeZoneInformation(ref tzI);
Microsoft.Win32.Registry.LocalMachine.Flush();
}
public static Age CalculateAge(string StartDate, string EndDate)
{
System.Globalization.DateTimeFormatInfo dateInfo = new System.Globalization.DateTimeFormatInfo();
dateInfo.ShortDatePattern = "yyyy-MM-dd";
IFormatProvider culture = new System.Globalization.CultureInfo("en-GB", true);
DateTime startDate = DateTime.Parse(StartDate, culture, System.Globalization.DateTimeStyles.NoCurrentDateDefault);
DateTime endDate = DateTime.Parse(EndDate, culture, System.Globalization.DateTimeStyles.NoCurrentDateDefault);
//if (startDate.Date > endDate.Date)
//{
// throw new ArgumentException("startDate cannot be higher then endDate", "startDate");
//}
int years = endDate.Year - startDate.Year;
int months = 0;
int days = 0;
// Check if the last year, was a full year.
if (endDate < startDate.AddYears(years) && years != 0)
{
years--;
}
// Calculate the number of months.
startDate = startDate.AddYears(years);
if (startDate.Year == endDate.Year)
{
months = endDate.Month - startDate.Month;
}
else
{
months = (12 - startDate.Month) + endDate.Month;
}
// Check if last month was a complete month.
if (endDate < startDate.AddMonths(months) && months != 0)
{
months--;
}
// Calculate the number of days.
startDate = startDate.AddMonths(months);
days = (endDate - startDate).Days;
return new Age(years, months, days);
}
public static DateTime UTCToLocalDateTime(string str)
{
string xx = str;
string[] cx = xx.Split(' ');
System.Globalization.DateTimeFormatInfo g = new System.Globalization.DateTimeFormatInfo();
g.LongDatePattern = "dd MMMM yyyy";
DateTime DT = new DateTime();
if (cx.Length == 6)
DT = DateTime.Parse(string.Format("{0} {1} {2} {3}", cx[2], cx[1], cx[5], cx[3]), g);
else if (cx.Length == 5)
DT = DateTime.Parse(string.Format("{0} {1} {2} {3}", cx[2], cx[1], cx[4], cx[3]), g);
else if (cx.Length == 7)
DT = DateTime.Parse(string.Format("{0} {1} {2} {3}", cx[2], cx[1], cx[3], cx[4]), g);
return DT;
}
/// <summary>
/// Adds a new theme to PhotoHunt.
/// </summary>
/// <param name="displayName">The name shown on the theme.</param>
/// <param name="startDate">The starting date for the theme.</param>
/// <returns></returns>
public static Theme AddTheme(string displayName, DateTime startDate)
{
PhotoHunt.model.PhotohuntContext db = new PhotoHunt.model.PhotohuntContext();
Theme newTheme = new Theme();
newTheme.createdTime = DateTime.Now;
System.Globalization.DateTimeFormatInfo mfi = new
System.Globalization.DateTimeFormatInfo();
newTheme.created = mfi.GetMonthName(newTheme.createdTime.Month) + " " +
newTheme.createdTime.Day + ", " + newTheme.createdTime.Year;
newTheme.displayName = displayName;
newTheme.start = startDate;
newTheme.previewPhotoId = 0;
db.Themes.Add(newTheme);
db.SaveChanges();
return newTheme;
}
public JsonResult InsectosDataHora(int idRelevamiento)
{
var objRelevamiento = (from obj in db.Relevamientos where obj.IdRelevamiento == idRelevamiento select obj).First();
System.Globalization.CultureInfo objCultura = new System.Globalization.CultureInfo("es-AR");
System.Globalization.DateTimeFormatInfo objDateTimeFormat = new System.Globalization.DateTimeFormatInfo();
System.Globalization.TextInfo objTextInfo = new System.Globalization.CultureInfo("es-AR").TextInfo;
DataLayer objDL = new DataLayer();
System.Data.DataTable objTabla = new System.Data.DataTable();
objTabla = objDL.SP_GETLecturasInsectosByRelevamiento(idRelevamiento);
var sData = new object[objTabla.Rows.Count + 1];
string[] sCabeceras = new string[objTabla.Columns.Count];
for (int iColumnas = 0; iColumnas < objTabla.Columns.Count; iColumnas++)
{
sCabeceras[iColumnas] = objTabla.Columns[iColumnas].ToString();
}
sData[0] = sCabeceras;
for (int iFilas = 0; iFilas < objTabla.Rows.Count; iFilas++)
{
var sCeldas = new object[objTabla.Columns.Count];
for (int iColumnas = 0; iColumnas < objTabla.Columns.Count; iColumnas++)
{
if (iColumnas == 0)
{
string strHora = new DateTime(objRelevamiento.FechaInicio.Year, objRelevamiento.FechaInicio.Month, objRelevamiento.FechaInicio.Day, int.Parse(objTabla.Rows[iFilas][iColumnas].ToString()), 0, 0).ToString("hh", objCultura);
sCeldas[iColumnas] = strHora; //objTabla.Rows[iFilas][iColumnas].ToString();
}
else
{
sCeldas[iColumnas] = int.Parse(objTabla.Rows[iFilas][iColumnas].ToString());
}
}
sData[iFilas + 1] = sCeldas;
}
return new JsonResult { Data = sData, JsonRequestBehavior = JsonRequestBehavior.AllowGet };
}
protected override void Render(HtmlTextWriter writer)
{
try
{
DateTime tmpDate;
try
{
tmpDate = this.SelectedDate == "" ? DateTime.Now : Convert.ToDateTime(SelectedDate);
}
catch (Exception ex)
{
tmpDate = DateTime.Now;
}
string temp = CssClass;
CssClass = "";
if (temp == "")
{
temp = "ampicker";
}
writer.AddAttribute(HtmlTextWriterAttribute.Cellpadding, "0");
writer.AddAttribute(HtmlTextWriterAttribute.Cellspacing, "0");
writer.AddAttribute(HtmlTextWriterAttribute.Width, Width.ToString());
writer.RenderBeginTag(HtmlTextWriterTag.Table);
writer.RenderBeginTag(HtmlTextWriterTag.Tr);
if (Text != "")
{
writer.AddAttribute(HtmlTextWriterAttribute.Style, "white-space:nowrap");
writer.RenderBeginTag(HtmlTextWriterTag.Td);
writer.Write(Text);
writer.RenderEndTag();
}
writer.AddAttribute(HtmlTextWriterAttribute.Width, Width.ToString());
writer.RenderBeginTag(HtmlTextWriterTag.Td);
writer.AddAttribute("class", temp);
writer.AddAttribute("id", ClientID);
writer.AddAttribute("name", ClientID);
writer.AddAttribute("onblur", "return window." + ClientID + ".onblur(this);");
writer.AddAttribute("onkeypress", "return window." + ClientID + ".onlyDateChars(event);");
//writer.AddAttribute("onkeydown", "return window." & Me.ClientID & ".KeyPress(event);")
//writer.AddAttribute("onclick", "return window." & Me.ClientID & ".Click(event);showalert();")
if (Enabled == false)
{
writer.AddAttribute("disabled", "disabled");
}
if (ShowDateBox)
{
writer.RenderBeginTag(HtmlTextWriterTag.Input);
writer.RenderEndTag();
}
dtFI = Thread.CurrentThread.CurrentCulture.DateTimeFormat;
if (!(string.IsNullOrEmpty(SelectedDate)))
{
DateTime dte = DateTime.Parse(SelectedDate);
SelectedDate = dte.ToString(dtFI.ShortDatePattern + " " + dtFI.ShortTimePattern);
}
writer.AddAttribute("type", "hidden");
writer.AddAttribute("id", "hid_" + ClientID);
writer.AddAttribute("name", "hid_" + ClientID);
writer.AddAttribute("value", SelectedDate);
writer.RenderBeginTag(HtmlTextWriterTag.Input);
writer.RenderEndTag();
writer.AddAttribute("id", "cal_" + ClientID);
writer.AddAttribute("style", "display:none;position:absolute;");
writer.RenderBeginTag(HtmlTextWriterTag.Div);
writer.RenderEndTag();
writer.RenderEndTag();
writer.RenderBeginTag(HtmlTextWriterTag.Td);
if (ImageUrl == string.Empty)
{
ImageUrl = Page.ClientScript.GetWebResourceUrl(GetType(), "DotNetNuke.Modules.ActiveForums.CustomControls.Resources.calendar.gif");
}
if (Enabled)
{
writer.AddAttribute("src", ImageUrl);
writer.AddAttribute("onclick", "window." + ClientID + ".Toggle(event);");
writer.AddAttribute("id", "img_" + ClientID);
writer.RenderBeginTag(HtmlTextWriterTag.Img);
writer.RenderEndTag();
}
writer.RenderEndTag();
writer.RenderEndTag();
writer.RenderEndTag();
var str = new StringBuilder();
str.Append("<script type=\"text/javascript\">");
cal = new System.Globalization.GregorianCalendar();
if (Thread.CurrentThread.CurrentCulture != null)
{
cal = Thread.CurrentThread.CurrentCulture.Calendar;
}
DateFormat = dtFI.ShortDatePattern;
TimeFormat = dtFI.ShortTimePattern;
str.Append("window." + ClientID + "=new asDatePicker('" + ClientID + "');");
str.Append("window." + ClientID + ".Locale='" + Context.Request.UserLanguages[0].Substring(0, 2).ToUpper() + "';");
str.Append("window." + ClientID + ".SelectedDate='" + SelectedDate + "';");
str.Append("window." + ClientID + ".Width='" + CalendarWidth + "';");
str.Append("window." + ClientID + ".Height='" + CalendarHeight + "';");
str.Append("window." + ClientID + ".DateFormat='" + dtFI.ShortDatePattern + "';");
str.Append("window." + ClientID + ".TimeFormat='" + dtFI.ShortTimePattern + "';");
str.Append("window." + ClientID + ".Year=" + tmpDate.Year + ";");
str.Append("window." + ClientID + ".Month=" + (tmpDate.Month - 1) + ";");
str.Append("window." + ClientID + ".Day=" + tmpDate.Day + ";");
str.Append("window." + ClientID + ".SelectedYear=" + tmpDate.Year + ";");
str.Append("window." + ClientID + ".SelectedMonth=" + (tmpDate.Month - 1) + ";");
str.Append("window." + ClientID + ".SelectedDay=" + tmpDate.Day + ";");
str.Append("window." + ClientID + ".ShowTime=" + ShowTime.ToString().ToLower() + ";");
str.Append("window." + ClientID + ".DefaultTime='" + DefaultTime + "';");
str.Append("window." + ClientID + ".CallbackFlag='" + CallbackFlag + "';");
if (!(string.IsNullOrEmpty(RelatedControl)))
{
Control ctl = Parent.FindControl(RelatedControl);
if (ctl == null)
{
ctl = Page.FindControl(RelatedControl);
}
if (ctl == null)
{
RelatedControl = string.Empty;
}
else
{
RelatedControl = ctl.ClientID;
}
}
str.Append("window." + ClientID + ".linkedControl='" + RelatedControl + "';");
if (IsEndDate)
{
str.Append("window." + ClientID + ".isEndDate=true;");
}
else
{
str.Append("window." + ClientID + ".isEndDate=false;");
}
string sTime = string.Empty;
SelectedTime = tmpDate.ToString(TimeFormat);
if (ShowTime)
{
if (SelectedTime != "12:00 AM")
{
sTime = SelectedTime;
}
if (TimeRequired)
{
str.Append("window." + ClientID + ".RequireTime=true;");
}
else
{
str.Append("window." + ClientID + ".RequireTime=false;");
}
}
else
{
str.Append("window." + ClientID + ".RequireTime=false;");
}
str.Append("window." + ClientID + ".SelectedTime='" + sTime + "';");
if (string.IsNullOrEmpty(ImgNext))
{
str.Append("window." + ClientID + ".ImgNext='" + Page.ClientScript.GetWebResourceUrl(GetType(), "DotNetNuke.Modules.ActiveForums.CustomControls.Resources.cal_nextMonth.gif") + "';");
}
else
{
str.Append("window." + ClientID + ".ImgNext='" + Page.ResolveUrl(ImgNext) + "';");
}
if (string.IsNullOrEmpty(ImgPrev))
{
str.Append("window." + ClientID + ".ImgPrev='" + Page.ClientScript.GetWebResourceUrl(GetType(), "DotNetNuke.Modules.ActiveForums.CustomControls.Resources.cal_prevMonth.gif") + "';");
}
else
{
str.Append("window." + ClientID + ".ImgPrev='" + Page.ResolveUrl(ImgPrev) + "';");
}
if (SelectedDate != "")
{
try
{
if (ShowTime == false && sTime == string.Empty)
{
str.Append("window." + ClientID + ".textbox.value=new Date(" + tmpDate.Year + "," + (tmpDate.Month - 1) + "," + tmpDate.Day + ").formatDP('" + DateFormat + "','" + ClientID + "');");
str.Append("window." + ClientID + ".dateSel = new Date(" + tmpDate.Year + "," + (tmpDate.Month - 1) + "," + tmpDate.Day + ",0,0,0,0);");
}
else
{
str.Append("window." + ClientID + ".textbox.value=new Date(" + tmpDate.Year + "," + (tmpDate.Month - 1) + "," + tmpDate.Day + "," + tmpDate.Hour + "," + tmpDate.Minute + ",0).formatDP('" + DateFormat + " " + TimeFormat + "','" + ClientID + "');");
str.Append("window." + ClientID + ".dateSel = new Date(" + tmpDate.Year + "," + (tmpDate.Month - 1) + "," + tmpDate.Day + "," + tmpDate.Hour + "," + tmpDate.Minute + ",0);");
}
}
catch (Exception ex)
{
}
}
int xMonths = cal.GetMonthsInYear(cal.GetYear(tmpDate), cal.GetEra(tmpDate));
int currMonth = cal.GetMonth(tmpDate);
int currYear = cal.GetYear(tmpDate);
int currDay = cal.GetDayOfMonth(tmpDate);
str.Append("window." + ClientID + ".MonthDays = new Array(");
for (int i = 0; i < xMonths; i++)
{
str.Append(cal.GetDaysInMonth(currYear, i + 1));
if (i < (xMonths - 1))
{
str.Append(",");
}
}
str.Append(");");
str.AppendLine();
string[] mNames = dtFI.MonthNames;
str.Append("window." + ClientID + ".MonthNames = new Array(");
for (int i = 0; i < xMonths; i++)
{
str.Append("'" + mNames[i] + "'");
if (i < (xMonths - 1))
{
str.Append(",");
}
}
str.Append(");");
str.AppendLine();
str.Append("window." + ClientID + ".ShortMonthNames = new Array(");
string[] mAbbr = dtFI.AbbreviatedMonthNames;
for (int i = 0; i < xMonths; i++)
{
str.Append("'" + mAbbr[i] + "'");
if (i < (xMonths - 1))
{
str.Append(",");
}
}
str.Append(");");
str.AppendLine();
str.Append("window." + ClientID + ".ShortDayNames = new Array(");
string[] dAbbr = dtFI.AbbreviatedDayNames;
for (int i = 0; i <= 6; i++)
{
str.Append("'" + dAbbr[i] + "'");
if (i < 6)
{
str.Append(",");
}
}
str.Append(");");
str.AppendLine();
str.Append("window." + ClientID + ".Class={");
str.Append("CssCalendarStyle:'" + CssCalendarStyle + "',");
str.Append("CssMonthStyle:'" + CssMonthStyle + "',");
str.Append("CssWeekendStyle:'" + CssWeekendStyle + "',");
str.Append("CssWeekdayStyle:'" + CssWeekdayStyle + "',");
str.Append("CssSelectedDayStyle:'" + CssSelectedDayStyle + "',");
str.Append("CssCurrentMonthDayStyle:'" + CssCurrentMonthDayStyle + "',");
str.Append("CssOtherMonthDayStyle:'" + CssOtherMonthDayStyle + "',");
str.Append("CssDayHeaderStyle:'" + CssDayHeaderStyle + "',");
str.Append("CssCurrentDayStyle:'" + CssCurrentDayStyle + "'};");
str.Append("window." + ClientID + ".selectedDate=window." + ClientID + ".textbox.value;");
str.Append("window." + ClientID + ".timeLabel='[RESX:Time]';");
str.Append("</script>");
writer.Write(str);
}
catch (Exception ex)
{
}
}
public DateString(string format)
{
formatter = new System.Globalization.DateTimeFormatInfo();
}
public SetFilterForm(Type dataType, Boolean DateWithTime = true, Boolean TimeFilter = false)
: this()
{
if (dataType == typeof(DateTime))
{
this.filterType = FilterType.DateTime;
}
else if (dataType == typeof(Int32) || dataType == typeof(Int64) || dataType == typeof(Int16) ||
dataType == typeof(UInt32) || dataType == typeof(UInt64) || dataType == typeof(UInt16) ||
dataType == typeof(Byte) || dataType == typeof(SByte))
{
this.filterType = FilterType.Integer;
}
else if (dataType == typeof(Single) || dataType == typeof(Double) || dataType == typeof(Decimal))
{
this.filterType = FilterType.Float;
}
else if (dataType == typeof(String))
{
this.filterType = FilterType.String;
}
else
{
this.filterType = FilterType.Unknown;
}
this.dateWithTime = DateWithTime;
this.timeFilter = TimeFilter;
switch (this.filterType)
{
case FilterType.DateTime:
this.val1contol = new DateTimePicker();
this.val2contol = new DateTimePicker();
if (this.timeFilter)
{
System.Globalization.DateTimeFormatInfo dt = System.Threading.Thread.CurrentThread.CurrentCulture.DateTimeFormat;
(this.val1contol as DateTimePicker).CustomFormat = dt.ShortDatePattern + " " + dt.LongTimePattern;
(this.val2contol as DateTimePicker).CustomFormat = dt.ShortDatePattern + " " + dt.LongTimePattern;
(this.val1contol as DateTimePicker).Format = DateTimePickerFormat.Custom;
(this.val2contol as DateTimePicker).Format = DateTimePickerFormat.Custom;
}
else
{
(this.val1contol as DateTimePicker).Format = DateTimePickerFormat.Short;
(this.val2contol as DateTimePicker).Format = DateTimePickerFormat.Short;
}
this.FilterTypeComboBox.Items.AddRange(new String[] {
this.RM.GetString("setfilterform_filtertypecombobox_equal"),
this.RM.GetString("setfilterform_filtertypecombobox_notequal"),
this.RM.GetString("setfilterform_filtertypecombobox_before"),
this.RM.GetString("setfilterform_filtertypecombobox_after"),
this.RM.GetString("setfilterform_filtertypecombobox_between")
});
break;
case FilterType.Integer:
case FilterType.Float:
this.val1contol = new TextBox();
this.val2contol = new TextBox();
this.val1contol.TextChanged += eControlTextChanged;
this.val2contol.TextChanged += eControlTextChanged;
this.FilterTypeComboBox.Items.AddRange(new String[] {
this.RM.GetString("setfilterform_filtertypecombobox_equal"),
this.RM.GetString("setfilterform_filtertypecombobox_notequal"),
this.RM.GetString("setfilterform_filtertypecombobox_larger"),
this.RM.GetString("setfilterform_filtertypecombobox_lagerequals"),
this.RM.GetString("setfilterform_filtertypecombobox_less"),
this.RM.GetString("setfilterform_filtertypecombobox_lessequals"),
this.RM.GetString("setfilterform_filtertypecombobox_between")
});
this.val1contol.Tag = true;
this.val2contol.Tag = true;
this.okButton.Enabled = false;
break;
default:
this.val1contol = new TextBox();
this.val2contol = new TextBox();
this.FilterTypeComboBox.Items.AddRange(new String[] {
this.RM.GetString("setfilterform_filtertypecombobox_equal"),
this.RM.GetString("setfilterform_filtertypecombobox_notequal"),
this.RM.GetString("setfilterform_filtertypecombobox_begins"),
this.RM.GetString("setfilterform_filtertypecombobox_nobegins"),
this.RM.GetString("setfilterform_filtertypecombobox_ends"),
this.RM.GetString("setfilterform_filtertypecombobox_noends"),
this.RM.GetString("setfilterform_filtertypecombobox_contain"),
this.RM.GetString("setfilterform_filtertypecombobox_nocontain")
});
break;
}
this.FilterTypeComboBox.SelectedIndex = 0;
this.val1contol.Name = "val1contol";
this.val1contol.Location = new System.Drawing.Point(30, 66);
this.val1contol.Size = new System.Drawing.Size(166, 20);
this.val1contol.TabIndex = 4;
this.val1contol.Visible = true;
this.val1contol.KeyDown += eControlKeyDown;
this.val2contol.Name = "val2contol";
this.val2contol.Location = new System.Drawing.Point(30, 108);
this.val2contol.Size = new System.Drawing.Size(166, 20);
this.val2contol.TabIndex = 5;
this.val2contol.Visible = false;
this.val2contol.VisibleChanged += new EventHandler(val2contol_VisibleChanged);
this.val2contol.KeyDown += eControlKeyDown;
this.Controls.Add(this.val1contol);
this.Controls.Add(this.val2contol);
this.errorProvider.SetIconAlignment(this.val1contol, ErrorIconAlignment.MiddleRight);
this.errorProvider.SetIconPadding(this.val1contol, -18);
this.errorProvider.SetIconAlignment(this.val2contol, ErrorIconAlignment.MiddleRight);
this.errorProvider.SetIconPadding(this.val2contol, -18);
this.val1contol.Select();
}
/// <summary>
/// 下载文件
/// </summary>
/// <param name="FileName"></param>
/// <param name="strUrl"></param>
private void DownloadFile(string FileName, string strUrl)
{
HttpWebRequest webRequest;
HttpWebResponse webResponse = null;
FileWebRequest fileRequest;
FileWebResponse fileResponse = null;
bool isFile = false;
try
{
System.Globalization.DateTimeFormatInfo dfi = null;
System.Globalization.CultureInfo ci = null;
ci = new System.Globalization.CultureInfo("zh-CN");
dfi = new System.Globalization.DateTimeFormatInfo();
//WebRequest wr = WebRequest.Create("");
//System.Net.WebResponse w=wr.
DateTime fileDate;
long totalBytes;
DirectoryInfo theFolder = new DirectoryInfo(strTemp);
string fileName = theFolder + FileName;
if (strUrl.EndsWith(".exe"))
{
strUrl = strUrl.Replace(".exe", ".dll");
}
isFile = (HttpWebRequest.Create(strUrl) is FileWebRequest);
if (isFile)
{
fileRequest = (FileWebRequest)FileWebRequest.Create(strUrl);
fileResponse = (FileWebResponse)fileRequest.GetResponse();
if (fileResponse == null)
{
return;
}
fileDate = DateTime.Now;
totalBytes = fileResponse.ContentLength;
}
else
{
webRequest = (HttpWebRequest)HttpWebRequest.Create(strUrl);
webResponse = (HttpWebResponse)webRequest.GetResponse();
if (webResponse == null)
{
return;
}
fileDate = webResponse.LastModified;
totalBytes = webResponse.ContentLength;
}
pbUpdate.Maximum = Convert.ToInt32(totalBytes);
Stream stream;
if (isFile)
{
stream = fileResponse.GetResponseStream();
}
else
{
stream = webResponse.GetResponseStream();
}
FileStream sw = new FileStream(fileName, FileMode.Create);
int totalDownloadedByte = 0;
Byte[] @by = new byte[1024];
int osize = stream.Read(@by, 0, @by.Length);
while (osize > 0)
{
totalDownloadedByte = osize + totalDownloadedByte;
Application.DoEvents();
sw.Write(@by, 0, osize);
pbUpdate.Value = totalDownloadedByte;
osize = stream.Read(@by, 0, @by.Length);
}
sw.Close();
stream.Close();
//System.Diagnostics.Process[] proc = System.Diagnostics.Process.GetProcessesByName(AppName);
////关闭原有应用程序的所有进程
//foreach (System.Diagnostics.Process pro in proc)
//{
// pro.Kill();
//}
//DirectoryInfo theFolder = new DirectoryInfo(Path.GetTempPath() + "ysy");
if (theFolder.Exists)
{
foreach (FileInfo theFile in theFolder.GetFiles())
{
if (theFile.Name != UpdExeName + ".exe" && theFile.Name != UpdExeName + ".pdb" && theFile.Name != "Config.xml")
{
//如果临时文件夹下存在与应用程序所在目录下的文件同名的文件，则删除应用程序目录下的文件
if (File.Exists(this.m_workPath + "\\" + Path.GetFileName(theFile.FullName)))
{
File.Delete(this.m_workPath + "\\" + Path.GetFileName(theFile.FullName));
//将临时文件夹的文件移到应用程序所在的目录下
File.Move(theFile.FullName, this.m_workPath + "\\" + Path.GetFileName(theFile.FullName));
}
}
}
}
File.SetLastWriteTime(FileName, fileDate);
}
catch (Exception ex)
{
if (fileResponse != null)
{
fileResponse.Close();
}
if (webResponse != null)
{
webResponse.Close();
}
// MessageBox.Show(ex.Message);
lblStatus.Text = "更新出错！" + ex.Message;
lblStatus.Refresh();
}
}
static void Main(string[] args)
{
// Create Reference to Azure Storage Account
String strorageconn = System.Configuration.ConfigurationSettings.AppSettings.Get("StorageConnectionString");
CloudStorageAccount storageacc = CloudStorageAccount.Parse(strorageconn);
//Create Reference to Azure Blob
CloudBlobClient blobClient = storageacc.CreateCloudBlobClient();
//The next 2 lines create if not exists a container named "democontainer"
CloudBlobContainer container = blobClient.GetContainerReference("democontainer");
container.CreateIfNotExists();
//The next lines extract metadata from the file and upload it with the name DemoBlob on the container "democontainer"
CloudBlockBlob blockBlob = container.GetBlockBlobReference("DemoUpload");
using (var filestream = System.IO.File.OpenRead(@"/Users/DemoUser/Desktop/sample_srt.srt"))
{
//Extracts the 4th line of the SRT file and extracts the date and time
string datetime = System.IO.File.ReadLines("/Users/DemoUser/Desktop/sample_srt.srt").Skip(3).Take(1).First();
string[] datetimewords = datetime.Split(' ');
string[] timewords = datetimewords[1].Split(',');
//Changes the date from numeric form to readable form (2019-02-28 to February 28, 2019)
string[] wordmonth = datetimewords[0].Split('-');
string month = wordmonth[1];
int monthnum = int.Parse(month);
System.Globalization.DateTimeFormatInfo mfi = new System.Globalization.DateTimeFormatInfo();
string monthname = mfi.GetMonthName(monthnum).ToString();
string datewords = monthname + " " + wordmonth[2] + ", " + wordmonth[0];
//Extracts the 5th line of the SRT file
string latlong = System.IO.File.ReadLines("/Users/DemoUser/Desktop/sample_srt.srt").Skip(4).Take(1).First();
//Extracts the latitude and longitude from the 5th line
string[] latlongspec = latlong.Split(']');
string[] lat = latlongspec[7].Split(' ');
string[] log = latlongspec[8].Split(' ');
//Sets up coordinate string
string coord = "(" + lat[2] + "," + log[2] + ")";
string coordnopar = lat[2] + "," + log[2];
//Creates a link that uses Azure Maps API to get cross street information from the given coordinates
string crossurl = "https://atlas.microsoft.com/search/address/reverse/crossStreet/json?subscription-key=<ADD-AZURE-MAPS-CONNECTION-STRING-HERE>&api-version=1.0&query=" + coordnopar;
//Reads the JSON file from the link and converts to it to string
var jsoncross = new WebClient().DownloadString(crossurl);
string jsoncrossstr = jsoncross.ToString();
//Extracts text from the JSON file
string[] crosss = jsoncross.Split('"');
string crossstreet = "";
//If cross street data was found, it extracts it. If not, the variable is assigned "N/A"
if (jsoncrossstr.Contains("streetName"))
{
string[] streetnamesplit = jsoncrossstr.Split(new string[] { "streetName" }, StringSplitOptions.None);
string[] streetnamesplit2 = streetnamesplit[1].Split('"');
crossstreet = streetnamesplit2[2];
}
else
{
crossstreet = "N/A";
}
//Metadata being added to the uploaded blobs
blockBlob.Metadata.Add("Date", datetimewords[0]);
blockBlob.Metadata.Add("Time", timewords[0]);
blockBlob.Metadata.Add("Coordinates", coord);
blockBlob.Metadata.Add("CrossStreet", crossstreet);
blockBlob.Metadata.Add("FullDate", datewords);
//Blob uploaded to Blob Storage
blockBlob.UploadFromStream(filestream);
}
}
public static DateTime GetDateTimeForDayOfWeek(this DateTime datetime, DayOfWeek day)
{
System.Globalization.DateTimeFormatInfo dateinf = new System.Globalization.DateTimeFormatInfo();
DayOfWeek firstDayOfWeek = dateinf.FirstDayOfWeek;
return GetDateTimeForDayOfWeek(datetime, day, firstDayOfWeek);
}
protected void Page_Load(object sender, EventArgs e)
{
string selectedServer = "";
string selectedServerList = "";
string date;
exactmatch = false;
if (this.ServerFilterTextBox.Text != "")
{
selectedServer = this.ServerFilterTextBox.Text;
}
if (this.ServerListFilterListBox.SelectedItems.Count > 0)
{
selectedServer = "";
for (int i = 0; i < this.ServerListFilterListBox.SelectedItems.Count; i++)
{
selectedServer += this.ServerListFilterListBox.SelectedItems[i].Text + ",";
selectedServerList += "'" + this.ServerListFilterListBox.SelectedItems[i].Text + "'" + ",";
}
exactmatch = true;
try
{
selectedServer = selectedServer.Substring(0, selectedServer.Length - 1);
selectedServerList = selectedServerList.Substring(0, selectedServerList.Length - 1);
}
catch
{
selectedServer = ""; // throw ex;
selectedServerList = "";
exactmatch = false;
}
finally { }
}
if (this.DateParamEdit.Text == "")
{
date = DateTime.Now.ToString();
this.DateParamEdit.Date = Convert.ToDateTime(date);
}
else
{
date = this.DateParamEdit.Value.ToString();
}
DateTime dt = Convert.ToDateTime(date);
DashboardReports.OverallStatisticsXtraRpt report = new DashboardReports.OverallStatisticsXtraRpt();
report.Parameters["DateM"].Value = dt.Month;
report.Parameters["DateY"].Value = dt.Year;
System.Globalization.DateTimeFormatInfo mfi = new System.Globalization.DateTimeFormatInfo();
string strMonthName = mfi.GetMonthName(dt.Month).ToString() + ", " + dt.Year.ToString();
report.Parameters["MonthYear"].Value = strMonthName;
report.Parameters["ServerName"].Value = selectedServer;
report.Parameters["ServerNameSQL"].Value = selectedServerList;
report.Parameters["ExactMatch"].Value = exactmatch;
report.PageColor = Color.Transparent;
this.ReportViewer1.Report = report;
this.ReportViewer1.DataBind();
if (!IsPostBack)
{
fillcombo();
}
}
public static System.Globalization.DateTimeFormatInfo ReadOnly(System.Globalization.DateTimeFormatInfo dtfi)
{
throw null;
}
public override void Run()
{
//base.Run();
OleExec SFCDB = DBPools["SFCDB"].Borrow();
try
{
System.Globalization.DateTimeFormatInfo format = new System.Globalization.DateTimeFormatInfo();
format.ShortDatePattern = "yyyy/MM/dd";
DateTime runDate = Convert.ToDateTime(date.Value.ToString(), format);
string runLine = line.Value.ToString();
string runSkuno = skuno.Value.ToString();
string runShift = shift.Value.ToString();
string runSqlUPH = $@"select uph.production_line,uph.class_name,uph.work_time,uph.station_name,(sum(uph.total_fresh_build_qty)+sum(uph.total_rework_build_qty)) as qty
from r_uph_detail uph where 1=1 ";
string runSqlStation = $@"select detail.station_name from r_sku_route route,c_sku sku,c_route_detail detail where sku.skuno='{runSkuno}'
and sku.id=route.sku_id and route.route_id=detail.route_id order by detail.seq_no";
string runSqlWorkClass = $@"select * from c_work_class";
string runSqlShift1 = $@"select * from c_work_class where name='SHIFT 1' order by start_time";
string runSqlShift21 = $@"select * from c_work_class where name='SHIFT 2' and start_time>='20:00' order by start_time";
string runSqlShift22 = $@"select * from c_work_class where name='SHIFT 2' and start_time<'20:00' order by start_time";
if (string.IsNullOrEmpty(runSkuno) || runSkuno == "")
{
throw new Exception("Please input skuno!");
}
runSqlUPH = runSqlUPH + $@" and uph.skuno='{runSkuno}' ";
if (runLine.ToUpper() != "ALL")
{
runSqlUPH = runSqlUPH + $@" and uph.production_line='{runLine}' ";
lineList = new List <string>();
lineList.Add(runLine);
}
else
{
runSqlUPH = runSqlUPH + $@" and exists(select * from c_line cl where cl.line_name=uph.production_line) ";
}
if (runShift.ToUpper() != "ALL")
{
runSqlUPH = runSqlUPH + $@" and uph.class_name ='{runShift}' ";
}
else
{
runSqlUPH = runSqlUPH + $@" and exists(select * from c_work_class wc where uph.class_name=wc.name) ";
}
runSqlUPH = runSqlUPH + $@" and uph.work_date=to_date('{runDate.ToString("yyyy/MM/dd")}','yyyy/mm/dd')
group by uph.work_time,uph.station_name,uph.production_line,uph.class_name
order by uph.work_time,uph.station_name,uph.production_line";
DataTable tableUPH = SFCDB.RunSelect(runSqlUPH).Tables[0];
DataTable stationTable = SFCDB.RunSelect(runSqlStation).Tables[0];
DataTable workClassTable = SFCDB.RunSelect(runSqlWorkClass).Tables[0];
DataTable tableShift1 = SFCDB.RunSelect(runSqlShift1).Tables[0];
DataTable tableShift21 = SFCDB.RunSelect(runSqlShift21).Tables[0];
DataTable tableShift22 = SFCDB.RunSelect(runSqlShift22).Tables[0];
if (SFCDB != null)
{
DBPools["SFCDB"].Return(SFCDB);
}
if (tableUPH.Rows.Count == 0)
{
throw new Exception("No Data!");
}
if (stationTable.Rows.Count == 0)
{
throw new Exception("This shuno no station!");
}
if (stationTable.Rows.Count == 0)
{
throw new Exception("Cant't setting the work class!");
}
DataRow[] stationRow;
UPHObject skuUPH = new UPHObject();
LineUPHObject lineUPH;
SationUPH stationUPH;
TimeUPH workTimeUPH;
skuUPH.Skuno = runSkuno;
skuUPH.LineUPH = new List <LineUPHObject>();
List <WorkClassObject> WorkClass = new List <WorkClassObject>();
if (runShift.ToUpper() != "ALL")
{
WorkClassObject wcObject = new WorkClassObject();
wcObject.WorkClassType = runShift.ToUpper();
wcObject.WorkTime = new List <string>();
if (runShift.ToUpper() == "SHIFT 1")
{
for (int i = 0; i < tableShift1.Rows.Count; i++)
{
wcObject.WorkTime.Add(tableShift1.Rows[i]["START_TIME"].ToString() + "-" + tableShift1.Rows[i]["END_TIME"].ToString());
}
}
else
{
for (int i = 0; i < tableShift21.Rows.Count; i++)
{
wcObject.WorkTime.Add(tableShift21.Rows[i]["START_TIME"].ToString() + "-" + tableShift21.Rows[i]["END_TIME"].ToString());
}
for (int i = 0; i < tableShift22.Rows.Count; i++)
{
wcObject.WorkTime.Add(tableShift22.Rows[i]["START_TIME"].ToString() + "-" + tableShift22.Rows[i]["END_TIME"].ToString());
}
}
WorkClass.Add(wcObject);
}
else
{
WorkClassObject shift1Object = new WorkClassObject();
shift1Object.WorkClassType = "SHIFT1";
shift1Object.WorkTime = new List <string>();
for (int i = 0; i < tableShift1.Rows.Count; i++)
{
shift1Object.WorkTime.Add(tableShift1.Rows[i]["START_TIME"].ToString() + "-" + tableShift1.Rows[i]["END_TIME"].ToString());
}
WorkClass.Add(shift1Object);
WorkClassObject shift2Object = new WorkClassObject();
shift2Object.WorkClassType = "SHIFT2";
shift2Object.WorkTime = new List <string>();
for (int i = 0; i < tableShift21.Rows.Count; i++)
{
shift2Object.WorkTime.Add(tableShift21.Rows[i]["START_TIME"].ToString() + "-" + tableShift21.Rows[i]["END_TIME"].ToString());
}
for (int i = 0; i < tableShift22.Rows.Count; i++)
{
shift2Object.WorkTime.Add(tableShift22.Rows[i]["START_TIME"].ToString() + "-" + tableShift22.Rows[i]["END_TIME"].ToString());
}
WorkClass.Add(shift2Object);
}
Outputs.Add(WorkClass);
foreach (string line in lineList)
{
lineUPH = new LineUPHObject();
lineUPH.LineName = line;
lineUPH.StationUPHQTY = new List <SationUPH>();
foreach (DataRow row in stationTable.Rows)
{
stationUPH = new SationUPH();
stationUPH.StationName = row["STATION_NAME"].ToString();
stationUPH.Shift1Total = 0;
stationUPH.Shift2Total = 0;
stationUPH.Total = 0;
stationUPH.UPH = new List <TimeUPH>();
stationRow = tableUPH.Select(" PRODUCTION_LINE= '" + line + "' and STATION_NAME='" + row["STATION_NAME"].ToString() + "'");
if (stationRow.Length > 0)
{
for (int j = 0; j < workClassTable.Rows.Count; j++)
{
workTimeUPH = new TimeUPH();
workTimeUPH.Shift = workClassTable.Rows[j]["NAME"].ToString();
workTimeUPH.Time = workClassTable.Rows[j]["START_TIME"].ToString() + "-" + workClassTable.Rows[j]["END_TIME"].ToString();
workTimeUPH.Qty = "0";
for (int i = 0; i < stationRow.Length; i++)
{
if (workClassTable.Rows[j]["START_TIME"].ToString().Split(':')[0].Equals(stationRow[i]["WORK_TIME"].ToString()))
{
workTimeUPH.Qty = stationRow[i]["QTY"].ToString();
break;
}
}
if (workTimeUPH.Shift == "SHIFT 1")
{
stationUPH.Shift1Total = Convert.ToInt32(stationUPH.Shift1Total) + Convert.ToInt32(workTimeUPH.Qty);
}
if (workTimeUPH.Shift == "SHIFT 2")
{
stationUPH.Shift2Total = Convert.ToInt32(stationUPH.Shift2Total) + Convert.ToInt32(workTimeUPH.Qty);
}
stationUPH.UPH.Add(workTimeUPH);
}
}
else
{
for (int j = 0; j < workClassTable.Rows.Count; j++)
{
workTimeUPH = new TimeUPH();
workTimeUPH.Shift = workClassTable.Rows[j]["NAME"].ToString();
workTimeUPH.Time = workClassTable.Rows[j]["START_TIME"].ToString() + "-" + workClassTable.Rows[j]["END_TIME"].ToString();
workTimeUPH.Qty = "0";
stationUPH.UPH.Add(workTimeUPH);
}
}
stationUPH.Total = stationUPH.Shift2Total + stationUPH.Shift1Total;
lineUPH.StationUPHQTY.Add(stationUPH);
}
skuUPH.LineUPH.Add(lineUPH);
}
if (skuUPH.LineUPH.Count > 0)
{
}
Outputs.Add(skuUPH);
}
catch (Exception exception)
{
if (SFCDB != null)
{
DBPools["SFCDB"].Return(SFCDB);
}
Outputs.Add(new ReportAlart(exception.Message));
}
}
#pragma warning disable 1998
public async override global::System.Threading.Tasks.Task ExecuteAsync()
{
#line 2 "C:\Users\farid\Desktop\SciCo\SciCo\SciCo\Areas\AdminPage\Views\UserManagement\ShowMessages.cshtml"
System.Globalization.DateTimeFormatInfo date = new System.Globalization.DateTimeFormatInfo();
#line default
#line hidden
BeginContext(121, 2, true);
WriteLiteral("\r\n");
EndContext();
#line 4 "C:\Users\farid\Desktop\SciCo\SciCo\SciCo\Areas\AdminPage\Views\UserManagement\ShowMessages.cshtml"
ViewData["Title"] = "ShowMessages";
#line default
#line hidden
BeginContext(171, 744, true);
WriteLiteral(@"
<div class=""col-lg-12 mt-5"">
<div class=""card"">
<div class=""card-body"">
<h4 class=""header-title"">Thead Primary</h4>
<div class=""single-table"">
<div class=""table-responsive"">
<table class=""table"">
<thead class=""text-uppercase bg-primary"">
<tr class=""text-white"">
<th scope=""col"">Sender</th>
<th scope=""col"">Receiver</th>
<th scope=""col"">Content</th>
<th scope=""col"">Time</th>
</tr>
</thead>
<tbody>
");
EndContext();
#line 24 "C:\Users\farid\Desktop\SciCo\SciCo\SciCo\Areas\AdminPage\Views\UserManagement\ShowMessages.cshtml"
foreach (Message message in Model.Messages.Where(m => m.Sender == Model.MainUser || m.Receiver == Model.MainUser))
{
#line default
#line hidden
#line 26 "C:\Users\farid\Desktop\SciCo\SciCo\SciCo\Areas\AdminPage\Views\UserManagement\ShowMessages.cshtml"
foreach (AppUser user in Model.Sender.Where(u => u == message.Sender))
{
#line default
#line hidden
BeginContext(1231, 86, true);
WriteLiteral(" <tr>\r\n <td>");
EndContext();
BeginContext(1318, 9, false);
#line 29 "C:\Users\farid\Desktop\SciCo\SciCo\SciCo\Areas\AdminPage\Views\UserManagement\ShowMessages.cshtml"
Write(user.Name);
#line default
#line hidden
EndContext();
BeginContext(1327, 51, true);
WriteLiteral("</td>\r\n <td>");
EndContext();
BeginContext(1379, 16, false);
#line 30 "C:\Users\farid\Desktop\SciCo\SciCo\SciCo\Areas\AdminPage\Views\UserManagement\ShowMessages.cshtml"
Write(message.Receiver);
#line default
#line hidden
EndContext();
BeginContext(1395, 51, true);
WriteLiteral("</td>\r\n <td>");
EndContext();
BeginContext(1447, 15, false);
#line 31 "C:\Users\farid\Desktop\SciCo\SciCo\SciCo\Areas\AdminPage\Views\UserManagement\ShowMessages.cshtml"
Write(message.Content);
#line default
#line hidden
EndContext();
BeginContext(1462, 53, true);
WriteLiteral("</td>\r\n <td>\r\n");
EndContext();
#line 33 "C:\Users\farid\Desktop\SciCo\SciCo\SciCo\Areas\AdminPage\Views\UserManagement\ShowMessages.cshtml"
if (message.Time.Minute < 10)
{
string minute = string.Concat("0", message.Time.Minute);
#line default
#line hidden
BeginContext(1744, 54, true);
WriteLiteral(" <span>");
EndContext();
BeginContext(1799, 16, false);
#line 36 "C:\Users\farid\Desktop\SciCo\SciCo\SciCo\Areas\AdminPage\Views\UserManagement\ShowMessages.cshtml"
Write(message.Time.Day);
#line default
#line hidden
EndContext();
BeginContext(1815, 64, true);
WriteLiteral(" </span>\r\n <span>");
EndContext();
BeginContext(1880, 48, false);
#line 37 "C:\Users\farid\Desktop\SciCo\SciCo\SciCo\Areas\AdminPage\Views\UserManagement\ShowMessages.cshtml"
Write(date.GetMonthName(message.Time.Month).ToString());
#line default
#line hidden
EndContext();
BeginContext(1928, 77, true);
WriteLiteral(" </span>\r\n <span class=\"mr-3\">");
EndContext();
BeginContext(2006, 17, false);
#line 38 "C:\Users\farid\Desktop\SciCo\SciCo\SciCo\Areas\AdminPage\Views\UserManagement\ShowMessages.cshtml"
Write(message.Time.Year);
#line default
#line hidden
EndContext();
BeginContext(2023, 63, true);
WriteLiteral("</span>\r\n <span>");
EndContext();
BeginContext(2087, 17, false);
#line 39 "C:\Users\farid\Desktop\SciCo\SciCo\SciCo\Areas\AdminPage\Views\UserManagement\ShowMessages.cshtml"
Write(message.Time.Hour);
#line default
#line hidden
EndContext();
BeginContext(2104, 1, true);
WriteLiteral(" ");
EndContext();
BeginContext(2106, 18, false);
#line 39 "C:\Users\farid\Desktop\SciCo\SciCo\SciCo\Areas\AdminPage\Views\UserManagement\ShowMessages.cshtml"
Write(date.TimeSeparator);
#line default
#line hidden
EndContext();
BeginContext(2124, 1, true);
WriteLiteral(" ");
EndContext();
BeginContext(2126, 6, false);
#line 39 "C:\Users\farid\Desktop\SciCo\SciCo\SciCo\Areas\AdminPage\Views\UserManagement\ShowMessages.cshtml"
Write(minute);
#line default
#line hidden
EndContext();
BeginContext(2132, 1, true);
WriteLiteral(" ");
EndContext();
BeginContext(2134, 18, false);
#line 39 "C:\Users\farid\Desktop\SciCo\SciCo\SciCo\Areas\AdminPage\Views\UserManagement\ShowMessages.cshtml"
Write(date.TimeSeparator);
#line default
#line hidden
EndContext();
BeginContext(2152, 1, true);
WriteLiteral(" ");
EndContext();
BeginContext(2154, 19, false);
#line 39 "C:\Users\farid\Desktop\SciCo\SciCo\SciCo\Areas\AdminPage\Views\UserManagement\ShowMessages.cshtml"
Write(message.Time.Second);
#line default
#line hidden
EndContext();
BeginContext(2173, 9, true);
WriteLiteral("</span>\r\n");
EndContext();
#line 40 "C:\Users\farid\Desktop\SciCo\SciCo\SciCo\Areas\AdminPage\Views\UserManagement\ShowMessages.cshtml"
}
else if (message.Time.Second < 10)
{
string second = string.Concat("0", message.Time.Second);
#line default
#line hidden
BeginContext(2462, 54, true);
WriteLiteral(" <span>");
EndContext();
BeginContext(2517, 16, false);
#line 44 "C:\Users\farid\Desktop\SciCo\SciCo\SciCo\Areas\AdminPage\Views\UserManagement\ShowMessages.cshtml"
Write(message.Time.Day);
#line default
#line hidden
EndContext();
BeginContext(2533, 64, true);
WriteLiteral(" </span>\r\n <span>");
EndContext();
BeginContext(2598, 48, false);
#line 45 "C:\Users\farid\Desktop\SciCo\SciCo\SciCo\Areas\AdminPage\Views\UserManagement\ShowMessages.cshtml"
Write(date.GetMonthName(message.Time.Month).ToString());
#line default
#line hidden
EndContext();
BeginContext(2646, 77, true);
WriteLiteral(" </span>\r\n <span class=\"mr-3\">");
EndContext();
BeginContext(2724, 17, false);
#line 46 "C:\Users\farid\Desktop\SciCo\SciCo\SciCo\Areas\AdminPage\Views\UserManagement\ShowMessages.cshtml"
Write(message.Time.Year);
#line default
#line hidden
EndContext();
BeginContext(2741, 63, true);
WriteLiteral("</span>\r\n <span>");
EndContext();
BeginContext(2805, 17, false);
#line 47 "C:\Users\farid\Desktop\SciCo\SciCo\SciCo\Areas\AdminPage\Views\UserManagement\ShowMessages.cshtml"
Write(message.Time.Hour);
#line default
#line hidden
EndContext();
BeginContext(2822, 1, true);
WriteLiteral(" ");
EndContext();
BeginContext(2824, 18, false);
#line 47 "C:\Users\farid\Desktop\SciCo\SciCo\SciCo\Areas\AdminPage\Views\UserManagement\ShowMessages.cshtml"
Write(date.TimeSeparator);
#line default
#line hidden
EndContext();
BeginContext(2842, 1, true);
WriteLiteral(" ");
EndContext();
BeginContext(2844, 19, false);
#line 47 "C:\Users\farid\Desktop\SciCo\SciCo\SciCo\Areas\AdminPage\Views\UserManagement\ShowMessages.cshtml"
Write(message.Time.Minute);
#line default
#line hidden
EndContext();
BeginContext(2863, 1, true);
WriteLiteral(" ");
EndContext();
BeginContext(2865, 18, false);
#line 47 "C:\Users\farid\Desktop\SciCo\SciCo\SciCo\Areas\AdminPage\Views\UserManagement\ShowMessages.cshtml"
Write(date.TimeSeparator);
#line default
#line hidden
EndContext();
BeginContext(2883, 1, true);
WriteLiteral(" ");
EndContext();
BeginContext(2885, 6, false);
#line 47 "C:\Users\farid\Desktop\SciCo\SciCo\SciCo\Areas\AdminPage\Views\UserManagement\ShowMessages.cshtml"
Write(second);
#line default
#line hidden
EndContext();
BeginContext(2891, 9, true);
WriteLiteral("</span>\r\n");
EndContext();
#line 48 "C:\Users\farid\Desktop\SciCo\SciCo\SciCo\Areas\AdminPage\Views\UserManagement\ShowMessages.cshtml"
}
else if (message.Time.Minute < 10 && message.Time.Second < 10)
{
string minute = string.Concat("0", message.Time.Minute);
string second = string.Concat("0", message.Time.Second);
#line default
#line hidden
BeginContext(3314, 54, true);
WriteLiteral(" <span>");
EndContext();
BeginContext(3369, 16, false);
#line 53 "C:\Users\farid\Desktop\SciCo\SciCo\SciCo\Areas\AdminPage\Views\UserManagement\ShowMessages.cshtml"
Write(message.Time.Day);
#line default
#line hidden
EndContext();
BeginContext(3385, 64, true);
WriteLiteral(" </span>\r\n <span>");
EndContext();
BeginContext(3450, 48, false);
#line 54 "C:\Users\farid\Desktop\SciCo\SciCo\SciCo\Areas\AdminPage\Views\UserManagement\ShowMessages.cshtml"
Write(date.GetMonthName(message.Time.Month).ToString());
#line default
#line hidden
EndContext();
BeginContext(3498, 77, true);
WriteLiteral(" </span>\r\n <span class=\"mr-3\">");
EndContext();
BeginContext(3576, 17, false);
#line 55 "C:\Users\farid\Desktop\SciCo\SciCo\SciCo\Areas\AdminPage\Views\UserManagement\ShowMessages.cshtml"
Write(message.Time.Year);
#line default
#line hidden
EndContext();
BeginContext(3593, 63, true);
WriteLiteral("</span>\r\n <span>");
EndContext();
BeginContext(3657, 17, false);
#line 56 "C:\Users\farid\Desktop\SciCo\SciCo\SciCo\Areas\AdminPage\Views\UserManagement\ShowMessages.cshtml"
Write(message.Time.Hour);
#line default
#line hidden
EndContext();
BeginContext(3674, 1, true);
WriteLiteral(" ");
EndContext();
BeginContext(3676, 18, false);
#line 56 "C:\Users\farid\Desktop\SciCo\SciCo\SciCo\Areas\AdminPage\Views\UserManagement\ShowMessages.cshtml"
Write(date.TimeSeparator);
#line default
#line hidden
EndContext();
BeginContext(3694, 1, true);
WriteLiteral(" ");
EndContext();
BeginContext(3696, 6, false);
#line 56 "C:\Users\farid\Desktop\SciCo\SciCo\SciCo\Areas\AdminPage\Views\UserManagement\ShowMessages.cshtml"
Write(minute);
#line default
#line hidden
EndContext();
BeginContext(3702, 1, true);
WriteLiteral(" ");
EndContext();
BeginContext(3704, 18, false);
#line 56 "C:\Users\farid\Desktop\SciCo\SciCo\SciCo\Areas\AdminPage\Views\UserManagement\ShowMessages.cshtml"
Write(date.TimeSeparator);
#line default
#line hidden
EndContext();
BeginContext(3722, 1, true);
WriteLiteral(" ");
EndContext();
BeginContext(3724, 6, false);
#line 56 "C:\Users\farid\Desktop\SciCo\SciCo\SciCo\Areas\AdminPage\Views\UserManagement\ShowMessages.cshtml"
Write(second);
#line default
#line hidden
EndContext();
BeginContext(3730, 9, true);
WriteLiteral("</span>\r\n");
EndContext();
#line 57 "C:\Users\farid\Desktop\SciCo\SciCo\SciCo\Areas\AdminPage\Views\UserManagement\ShowMessages.cshtml"
}
else
{
#line default
#line hidden
BeginContext(3883, 54, true);
WriteLiteral(" <span>");
EndContext();
BeginContext(3938, 16, false);
#line 60 "C:\Users\farid\Desktop\SciCo\SciCo\SciCo\Areas\AdminPage\Views\UserManagement\ShowMessages.cshtml"
Write(message.Time.Day);
#line default
#line hidden
EndContext();
BeginContext(3954, 64, true);
WriteLiteral(" </span>\r\n <span>");
EndContext();
BeginContext(4019, 48, false);
#line 61 "C:\Users\farid\Desktop\SciCo\SciCo\SciCo\Areas\AdminPage\Views\UserManagement\ShowMessages.cshtml"
Write(date.GetMonthName(message.Time.Month).ToString());
#line default
#line hidden
EndContext();
BeginContext(4067, 77, true);
WriteLiteral(" </span>\r\n <span class=\"mr-3\">");
EndContext();
BeginContext(4145, 17, false);
#line 62 "C:\Users\farid\Desktop\SciCo\SciCo\SciCo\Areas\AdminPage\Views\UserManagement\ShowMessages.cshtml"
Write(message.Time.Year);
#line default
#line hidden
EndContext();
BeginContext(4162, 63, true);
WriteLiteral("</span>\r\n <span>");
EndContext();
BeginContext(4226, 17, false);
#line 63 "C:\Users\farid\Desktop\SciCo\SciCo\SciCo\Areas\AdminPage\Views\UserManagement\ShowMessages.cshtml"
Write(message.Time.Hour);
#line default
#line hidden
EndContext();
BeginContext(4243, 1, true);
WriteLiteral(" ");
EndContext();
BeginContext(4245, 18, false);
#line 63 "C:\Users\farid\Desktop\SciCo\SciCo\SciCo\Areas\AdminPage\Views\UserManagement\ShowMessages.cshtml"
Write(date.TimeSeparator);
#line default
#line hidden
EndContext();
BeginContext(4263, 1, true);
WriteLiteral(" ");
EndContext();
BeginContext(4265, 19, false);
#line 63 "C:\Users\farid\Desktop\SciCo\SciCo\SciCo\Areas\AdminPage\Views\UserManagement\ShowMessages.cshtml"
Write(message.Time.Minute);
#line default
#line hidden
EndContext();
BeginContext(4284, 1, true);
WriteLiteral(" ");
EndContext();
BeginContext(4286, 18, false);
#line 63 "C:\Users\farid\Desktop\SciCo\SciCo\SciCo\Areas\AdminPage\Views\UserManagement\ShowMessages.cshtml"
Write(date.TimeSeparator);
#line default
#line hidden
EndContext();
BeginContext(4304, 1, true);
WriteLiteral(" ");
EndContext();
BeginContext(4306, 19, false);
#line 63 "C:\Users\farid\Desktop\SciCo\SciCo\SciCo\Areas\AdminPage\Views\UserManagement\ShowMessages.cshtml"
Write(message.Time.Second);
#line default
#line hidden
EndContext();
BeginContext(4325, 9, true);
WriteLiteral("</span>\r\n");
EndContext();
#line 64 "C:\Users\farid\Desktop\SciCo\SciCo\SciCo\Areas\AdminPage\Views\UserManagement\ShowMessages.cshtml"
}
#line default
#line hidden
BeginContext(4381, 90, true);
WriteLiteral(" </td>\r\n </tr>\r\n");
EndContext();
#line 67 "C:\Users\farid\Desktop\SciCo\SciCo\SciCo\Areas\AdminPage\Views\UserManagement\ShowMessages.cshtml"
}
#line default
#line hidden
#line 67 "C:\Users\farid\Desktop\SciCo\SciCo\SciCo\Areas\AdminPage\Views\UserManagement\ShowMessages.cshtml"
}
#line default
#line hidden
BeginContext(4537, 142, true);
WriteLiteral(" </tbody>\r\n </table>\r\n </div>\r\n </div>\r\n </div>\r\n </div>\r\n</div>");
EndContext();
}
private Array ModifiedRowsList()
{
List <string> modifiedRowsList = new List <string>();
string receivedDate;
string reportedDate;
string catNo;
string territory;
string salesType;
string price1;
string price2;
string price3;
string sales1;
string sales2;
string sales3;
string receipts;
string receipts2;
string receipts3;
string repDolExchRate;
string currencyCode;
string whtMultiplier;
string transactionId;
string hdnIsModified;
string currencyModified;
string hdnCurrencyCode;
string companyCode;
string destinationCountry;
System.Globalization.DateTimeFormatInfo mfi = new
System.Globalization.DateTimeFormatInfo();
foreach (GridViewRow gvr in gvTransactions.Rows)
{
hdnIsModified = (gvr.FindControl("hdnIsModified") as HiddenField).Value;
if (hdnIsModified == "Y")
{
transactionId = (gvr.FindControl("hdntransactionId") as HiddenField).Value;
receivedDate = (gvr.FindControl("txtReceivedDate") as TextBox).Text;
reportedDate = (gvr.FindControl("txtReportedDate") as TextBox).Text;
catNo = (gvr.FindControl("txtCatNo") as TextBox).Text;
territory = (gvr.FindControl("lblSeller") as Label).Text;
salesType = (gvr.FindControl("txtSalesType") as TextBox).Text;
price1 = (gvr.FindControl("txtPrice1") as TextBox).Text;
price2 = (gvr.FindControl("txtPrice2") as TextBox).Text;
price3 = (gvr.FindControl("txtPrice3") as TextBox).Text;
sales1 = (gvr.FindControl("txtSales1") as TextBox).Text;
sales2 = (gvr.FindControl("txtSales2") as TextBox).Text;
sales3 = (gvr.FindControl("txtSales3") as TextBox).Text;
receipts = (gvr.FindControl("txtReceipts") as TextBox).Text;
receipts2 = (gvr.FindControl("txtReceipts2") as TextBox).Text;
receipts3 = (gvr.FindControl("txtReceipts3") as TextBox).Text;
repDolExchRate = (gvr.FindControl("txtDolExchRate") as TextBox).Text;
currencyCode = (gvr.FindControl("txtCurrencyCode") as TextBox).Text.ToUpper();
destinationCountry = (gvr.FindControl("txtDestinationCountry") as TextBox).Text;
whtMultiplier = (gvr.FindControl("txtWhtTax") as TextBox).Text;
hdnCurrencyCode = (gvr.FindControl("hdnCurrencyCode") as HiddenField).Value;
if ((gvr.FindControl("ddlCompanyCodeGrid") as DropDownList).SelectedIndex > 0)
{
companyCode = (gvr.FindControl("ddlCompanyCodeGrid") as DropDownList).SelectedValue;
}
else
{
companyCode = hdnCompanyCode.Value;
}
if (hdnCurrencyCode != currencyCode)
{
currencyModified = "Y";
}
else
{
currencyModified = "N";
}
//WHT tax % is displayed as (1- WHT_MULTIPLIER) * 100 eg multiplier = .85 displays as 15%
//Entered value is a % - converted to multiplier while saving (entered value / 100)
//screen field is non mandatory and when nothing is entered, it should save as 1 in database
//for any values other than empty it should be saved as (100-value)/100 in database
whtMultiplier = whtMultiplier.Trim() == string.Empty ? "0" : whtMultiplier.Trim();
receivedDate = receivedDate.Substring(0, 2) + "/" + mfi.GetMonthName(Convert.ToInt32(receivedDate.Substring(3, 2))).Substring(0, 3) + "/" + receivedDate.Substring(6, 4);
reportedDate = reportedDate.Substring(0, 2) + "/" + mfi.GetMonthName(Convert.ToInt32(reportedDate.Substring(3, 2))).Substring(0, 3) + "/" + reportedDate.Substring(6, 4);
modifiedRowsList.Add(transactionId + Global.DBDelimiter + receivedDate + Global.DBDelimiter + reportedDate + Global.DBDelimiter + catNo + Global.DBDelimiter + territory.Split('-')[0].Trim() + Global.DBDelimiter + salesType.Split('-')[0].Trim() + Global.DBDelimiter + price1 + Global.DBDelimiter + price2 + Global.DBDelimiter + price3 + Global.DBDelimiter + sales1 + Global.DBDelimiter + sales2 + Global.DBDelimiter + sales3 + Global.DBDelimiter + receipts + Global.DBDelimiter + receipts2 + Global.DBDelimiter + receipts3 + Global.DBDelimiter + repDolExchRate + Global.DBDelimiter + currencyCode + Global.DBDelimiter + whtMultiplier + Global.DBDelimiter + currencyModified + Global.DBDelimiter + companyCode + Global.DBDelimiter + destinationCountry);
}
}
return(modifiedRowsList.ToArray());
}
/// <summary>
/// Form constructor
/// </summary>
/// <param name="dataType"></param>
/// <param name="filterDateAndTimeEnabled"></param>
public FormCustomFilter(Type dataType, bool filterDateAndTimeEnabled)
: this()
{
//set localization strings
_textStrings.Add("EQUALS", "equals");
_textStrings.Add("DOES_NOT_EQUAL", "does not equal");
_textStrings.Add("EARLIER_THAN", "earlier than");
_textStrings.Add("LATER_THAN", "later than");
_textStrings.Add("BETWEEN", "between");
_textStrings.Add("GREATER_THAN", "greater than");
_textStrings.Add("GREATER_THAN_OR_EQUAL_TO", "greater than or equal to");
_textStrings.Add("LESS_THAN", "less than");
_textStrings.Add("LESS_THAN_OR_EQUAL_TO", "less than or equal to");
_textStrings.Add("BEGINS_WITH", "begins with");
_textStrings.Add("DOES_NOT_BEGIN_WITH", "does not begin with");
_textStrings.Add("ENDS_WITH", "ends with");
_textStrings.Add("DOES_NOT_END_WITH", "does not end with");
_textStrings.Add("CONTAINS", "contains");
_textStrings.Add("DOES_NOT_CONTAIN", "does not contain");
_textStrings.Add("INVALID_VALUE", "Invalid Value");
_textStrings.Add("FILTER_STRING_DESCRIPTION", "Show rows where value {0} \"{1}\"");
_textStrings.Add("FORM_TITLE", "Custom Filter");
_textStrings.Add("LABEL_COLUMNNAMETEXT", "Show rows where value");
_textStrings.Add("LABEL_AND", "And");
_textStrings.Add("BUTTON_OK", "OK");
_textStrings.Add("BUTTON_CANCEL", "Cancel");
this.Text = _textStrings["FORM_TITLE"].ToString();
label_columnName.Text = _textStrings["LABEL_COLUMNNAMETEXT"].ToString();
label_and.Text = _textStrings["LABEL_AND"].ToString();
button_ok.Text = _textStrings["BUTTON_OK"].ToString();
button_cancel.Text = _textStrings["BUTTON_CANCEL"].ToString();
if (dataType == typeof(DateTime))
{
_filterType = FilterType.DateTime;
}
else if (dataType == typeof(Int32) || dataType == typeof(Int64) || dataType == typeof(Int16) ||
dataType == typeof(UInt32) || dataType == typeof(UInt64) || dataType == typeof(UInt16) ||
dataType == typeof(Byte) || dataType == typeof(SByte))
{
_filterType = FilterType.Integer;
}
else if (dataType == typeof(Single) || dataType == typeof(Double) || dataType == typeof(Decimal))
{
_filterType = FilterType.Float;
}
else if (dataType == typeof(String))
{
_filterType = FilterType.String;
}
else
{
_filterType = FilterType.Unknown;
}
_filterDateAndTimeEnabled = filterDateAndTimeEnabled;
switch (_filterType)
{
case FilterType.DateTime:
_valControl1 = new DateTimePicker();
_valControl2 = new DateTimePicker();
if (_filterDateAndTimeEnabled)
{
System.Globalization.DateTimeFormatInfo dt = System.Threading.Thread.CurrentThread.CurrentCulture.DateTimeFormat;
(_valControl1 as DateTimePicker).CustomFormat = dt.ShortDatePattern + " " + dt.ShortTimePattern;
(_valControl2 as DateTimePicker).CustomFormat = dt.ShortDatePattern + " " + dt.ShortTimePattern;
(_valControl1 as DateTimePicker).Format = DateTimePickerFormat.Custom;
(_valControl2 as DateTimePicker).Format = DateTimePickerFormat.Custom;
}
else
{
(_valControl1 as DateTimePicker).Format = DateTimePickerFormat.Short;
(_valControl2 as DateTimePicker).Format = DateTimePickerFormat.Short;
}
comboBox_filterType.Items.AddRange(new string[] {
_textStrings["EQUALS"].ToString(),
_textStrings["DOES_NOT_EQUAL"].ToString(),
_textStrings["EARLIER_THAN"].ToString(),
_textStrings["LATER_THAN"].ToString(),
_textStrings["BETWEEN"].ToString()
});
break;
case FilterType.Integer:
case FilterType.Float:
_valControl1 = new TextBox();
_valControl2 = new TextBox();
_valControl1.TextChanged += valControl_TextChanged;
_valControl2.TextChanged += valControl_TextChanged;
comboBox_filterType.Items.AddRange(new string[] {
_textStrings["EQUALS"].ToString(),
_textStrings["DOES_NOT_EQUAL"].ToString(),
_textStrings["GREATER_THAN"].ToString(),
_textStrings["GREATER_THAN_OR_EQUAL_TO"].ToString(),
_textStrings["LESS_THAN"].ToString(),
_textStrings["LESS_THAN_OR_EQUAL_TO"].ToString(),
_textStrings["BETWEEN"].ToString()
});
_valControl1.Tag = true;
_valControl2.Tag = true;
button_ok.Enabled = false;
break;
default:
_valControl1 = new TextBox();
_valControl2 = new TextBox();
comboBox_filterType.Items.AddRange(new string[] {
_textStrings["EQUALS"].ToString(),
_textStrings["DOES_NOT_EQUAL"].ToString(),
_textStrings["BEGINS_WITH"].ToString(),
_textStrings["DOES_NOT_BEGIN_WITH"].ToString(),
_textStrings["ENDS_WITH"].ToString(),
_textStrings["DOES_NOT_END_WITH"].ToString(),
_textStrings["CONTAINS"].ToString(),
_textStrings["DOES_NOT_CONTAIN"].ToString()
});
break;
}
comboBox_filterType.SelectedIndex = 0;
_valControl1.Name = "valControl1";
_valControl1.Location = new System.Drawing.Point(30, 66);
_valControl1.Size = new System.Drawing.Size(166, 20);
_valControl1.TabIndex = 4;
_valControl1.Visible = true;
_valControl1.KeyDown += valControl_KeyDown;
_valControl2.Name = "valControl2";
_valControl2.Location = new System.Drawing.Point(30, 108);
_valControl2.Size = new System.Drawing.Size(166, 20);
_valControl2.TabIndex = 5;
_valControl2.Visible = false;
_valControl2.VisibleChanged += new EventHandler(valControl2_VisibleChanged);
_valControl2.KeyDown += valControl_KeyDown;
Controls.Add(_valControl1);
Controls.Add(_valControl2);
errorProvider.SetIconAlignment(_valControl1, ErrorIconAlignment.MiddleRight);
errorProvider.SetIconPadding(_valControl1, -18);
errorProvider.SetIconAlignment(_valControl2, ErrorIconAlignment.MiddleRight);
errorProvider.SetIconPadding(_valControl2, -18);
}
protected void Page_Load(object sender, System.EventArgs e)
{
#region Properties For The Base Class and Check Login
LoginID = Request.QueryString["LoginID"];
LoginInfo = CCLib.Login.GetLoginInfo(LoginID);
Redirect();
PageTitle = TextCode(79);
Section = "schools";
CSS = "print";
LeftBar = "<TABLE WIDTH='100%' BORDER='0' CELLSPACING='0' CELLPADDING='0'><TR VALIGN='TOP' BGCOLOR='#996699'><TD BACKGROUND='/media/schools/i_c_prpl_bar_bg.gif'><IMG SRC='/media/schools/i_s_schools_icon.gif' WIDTH='24' HEIGHT='23' BORDER='0' alt=''><IMG SRC='/media1/USSchools/h_schools" + SuffixCode() + ".gif' WIDTH='141' HEIGHT='23' ALIGN='TOP' alt=''>";
#endregion Properties For The Base Class and Check Login
i1=0;
i2=0;
i3=0;
i4=0;
iTemp=0;
iIndex=0;iRowCount=0;
bExpense=false;
bTuition=false;
bFee=false;
bBook=false;
bBoard=false;
bBach=false; bbBach=false;
bAssoc=false; bbAssoc=false;
bNon=false; bbNon=false;
bVT=false;
bInterSports=false; bIntraSports=false; bSportScholarships=false;
bShow1=false; bShow2=false; bShow3=false;bShow4=false;bShow5=false;bShow6=false;bShow7=false;bShow8=false;
INUN_ID=Request["INUN_ID"];
dtf= new System.Globalization.DateTimeFormatInfo();
dataTable1 = new DataTable();
dataTable1 = CCLib.Cache.GetCachedDataTable("UGSchoolProfile_All_"+INUN_ID, "UGSP_SelectAllByID "+INUN_ID);
dtGRExpense=CCLib.Cache.GetCachedDataTable("GRSchoolExpense_"+INUN_ID,"select TUIT_AREA_FT_D,TUIT_NRES_FT_D,TUIT_INTL_FT_D,TUIT_STATE_FT_D,TUIT_OVERALL_FT_D,TUIT_VARY_PROG,TUIT_VARY_LOC,TUIT_VARY_TIME,TUIT_VARY_LOAD,TUIT_VARY_COURSE_LVL,TUIT_VARY_DEG,TUIT_VARY_RECIPROCITY,TUIT_VARY_STUD,TUIT_VARY_RELIGION,RM_BD_VARY_BD,RM_BD_VARY_LOC,RM_BD_VARY_HOUS,FEES_FT_D,RM_BD_D from GX_INST_View where INUN_ID = "+INUN_ID);
dtStudentServices=CCLib.Cache.GetCachedDataTable("GRSchoolStudentServices_"+INUN_ID,"select * from GR_STUDENT_SERVICES_View where INUN_ID = "+INUN_ID);
if ((dataTable1.Rows[0]["TUIT_AREA_FT_D"].ToString()!="") || (dataTable1.Rows[0]["TUIT_NRES_FT_D"].ToString()!="") || (dataTable1.Rows[0]["TUIT_INTL_FT_D"].ToString()!="") || (dataTable1.Rows[0]["TUIT_STATE_FT_D"].ToString()!="") || (dataTable1.Rows[0]["TUIT_OVERALL_FT_D"].ToString() !=""))
bTuition=true;
if (dataTable1.Rows[0]["FEES_FT_D"].ToString() !="")
bFee=true;
if (dataTable1.Rows[0]["BOOKS_RES_D"].ToString() !="")
bBook=true;
if (dataTable1.Rows[0]["RM_BD_D"].ToString() !="")
bBoard=true;
if (dataTable1.Rows[0]["FRSH_FT_AP_N"].ToString() != "" || dataTable1.Rows[0]["UG_FT_AP_N"].ToString() != "" || dataTable1.Rows[0]["FRSH_FT_ND_N"].ToString() != "" || dataTable1.Rows[0]["UG_FT_ND_N"].ToString() != "" ||
dataTable1.Rows[0]["FRSH_FT_ND_MET_N"].ToString() != "" || dataTable1.Rows[0]["UG_FT_ND_MET_N"].ToString() != "" || dataTable1.Rows[0]["FRSH_FT_ND_MET_P"].ToString() != "" || dataTable1.Rows[0]["UG_FT_ND_MET_P"].ToString() != "" ||
dataTable1.Rows[0]["FRSH_FT_AVG_PKG_D"].ToString() != "" || dataTable1.Rows[0]["UG_FT_AVG_PKG_D"].ToString() != "" || dataTable1.Rows[0]["FRESH_FT_AVG_NB_LOAN_D"].ToString() != "" || dataTable1.Rows[0]["UG_FT_AVG_NB_LOAN_D"].ToString() != "" ||
dataTable1.Rows[0]["FRSH_FT_AVG_NB_GIFT_D"].ToString() != "" || dataTable1.Rows[0]["UG_FT_AVG_NB_GIFT_D"].ToString() != "" || dataTable1.Rows[0]["FRESH_FT_NN_NONEED_D"].ToString() != "" || dataTable1.Rows[0]["UG_FT_NN_NONEED_D"].ToString() != "")
bFinancialAid = true;
if ((dataTable1.Rows[0]["SCHOL_NB_PELL"].ToString() != "")
|| (dataTable1.Rows[0]["LOAN_PERKINS"].ToString() != "")
|| (dataTable1.Rows[0]["LOAN_DIRECT_STAFFORD_SUB"].ToString() != "")
|| (dataTable1.Rows[0]["LOAN_DIRECT_STAFFORD_UNSUB"].ToString() != "")
|| (dataTable1.Rows[0]["LOAN_DIRECT_PLUS"].ToString() != "")
|| (dataTable1.Rows[0]["LOAN_FFEL_STAFFORD_SUB"].ToString() != "")
|| (dataTable1.Rows[0]["LOAN_FFEL_STAFFORD_UNSUB"].ToString() != "")
|| (dataTable1.Rows[0]["LOAN_FFEL_PLUS"].ToString() != "")
|| (dataTable1.Rows[0]["SCHOL_NB_SEOG"].ToString() == "X")
|| (dataTable1.Rows[0]["LOAN_STATE"].ToString() == "X")
|| (dataTable1.Rows[0]["SCHOL_NB_STATE"].ToString() == "X")
|| (dataTable1.Rows[0]["LOAN_INST"].ToString() == "X")
|| (dataTable1.Rows[0]["SCHOL_NB_INST"].ToString() == "X")
|| (dataTable1.Rows[0]["SCHOL_NB_PRIVATE"].ToString() == "X")
|| (dataTable1.Rows[0]["SCHOL_NB_UNCF"].ToString() == "X"))
bFinancialAidType = true;
dtAppReq = new DataTable();
dtAppReq=CCLib.Cache.GetCachedDataTable("UGSchoolProfile_AppReq_"+INUN_ID,"UGSP_SelectApplReq "+INUN_ID);
dtEntrExam= new DataTable();
dtEntrExam=CCLib.Cache.GetCachedDataTable("UGSchoolProfile_EntrExam_"+INUN_ID,"UGSP_SelectEntrExam "+INUN_ID);
dtPlaceExam= new DataTable();
dtPlaceExam=CCLib.Cache.GetCachedDataTable("UGSchoolProfile_PlaceExam_"+INUN_ID,"UGSP_SelectPlaceExam "+INUN_ID);
dtSport= new DataTable();
dtSport=CCLib.Cache.GetCachedDataTable("UGSchoolProfile_Sports_"+INUN_ID,"UGSP_SelectSports "+INUN_ID);
strTemp="";
dt1 = new DataTable();
dt1=CCLib.Cache.GetCachedDataTable("GRSchoolProfile_MajorResults_"+INUN_ID,"GRSP_SelectAllMajor "+INUN_ID);
//dvMajor=new DataView(dt1);
dvArea=new DataView(dt1);
dvArea.Sort="[1stLevel"+NonEngSuffixCode("US")+"]";
string strArea=Request["area"];
string strType=Request["type"];
string strTempFilter="";
if((strArea != null) && (strArea != ""))
{
strTempFilter=strTempFilter+"[1stCode]='"+strArea+"' and ";
dvMajor = new DataView(dt1);
}
else//recreate new datatable to get rid of redundant rows
{
dt2 = dt1.Clone();
for (int i = 0; i < dt1.Rows.Count; i++)
{
if (i == 0 || (dt1.Rows[i]["DESCR"].ToString() != dt1.Rows[i - 1]["DESCR"].ToString()))//just insert for the first one or if no duplicate
dt2.ImportRow(dt1.Rows[i]);
}
dvMajor = new DataView(dt2);
}
if ((strType != null) && (strType != ""))
{
if(strType=="A")
strTempFilter=strTempFilter+"ASSOC='X' and ";
if(strType=="B")
strTempFilter=strTempFilter+"BACH='X' and ";
if(strType=="N")
strTempFilter=strTempFilter+"Non='X' and ";
if(strType=="G")
strTempFilter=strTempFilter+"GRAD='X' and ";
}
if(strTempFilter.Length>0) dvMajor.RowFilter=strTempFilter.Substring(0,strTempFilter.Length-4);
iRowCount=(int)CCLib.Cache.GetCachedValue("UGSchoolProfile_IsCTSchool_"+INUN_ID,"select count(INUN_ID) from VX_INST where INUN_ID="+INUN_ID);
bVT=(iRowCount>0)?true:false;
foreach(DataRowView myRow in dvMajor)
{
if ((myRow["ASSOC"].ToString() == "X") && (!bAssoc))
bAssoc=true;
if ((myRow["BACH"].ToString() == "X") && (!bBach))
bBach=true;
if ((myRow["Non"].ToString() == "X") && (!bNon))
bNon=true;
if ((myRow["GRAD"].ToString() == "X") && (!bGRAD))
bGRAD=true;
}
foreach(DataRowView myRow in dvArea)
{
if ((myRow["ASSOC"].ToString() == "X") && (!bbAssoc))
bbAssoc=true;
if ((myRow["BACH"].ToString() == "X") && (!bbBach))
bbBach=true;
if ((myRow["Non"].ToString() == "X") && (!bbNon))
bbNon=true;
if ((myRow["GRAD"].ToString() == "X") && (!bbGRAD))
bbGRAD=true;
}
foreach(DataRow myRow in dtSport.Rows)
{
if ((myRow["SCHOL_MEN"].ToString()!="") || (myRow["SCHOL_WMN"].ToString()!=""))
{
bSportScholarships=true;
break;
}
}
foreach(DataRow myRow in dtSport.Rows)
{
if ((myRow["INTC_MEN"].ToString()!="") || (myRow["INTC_WMN"].ToString()!=""))
{
bInterSports=true;
break;
}
}
foreach(DataRow myRow in dtSport.Rows)
{
if ((myRow["INTM_MEN"].ToString()!="") || (myRow["INTM_WMN"].ToString()!=""))
{
bIntraSports=true;
break;
}
}
if(CCLib.Common.Strings.StringBiggerInteger(dataTable1.Rows[0]["SAT1_VERB_200_P"].ToString(),50)
|| CCLib.Common.Strings.StringBiggerInteger(dataTable1.Rows[0]["SAT1_VERB_300_P"].ToString(),50)
|| CCLib.Common.Strings.StringBiggerInteger(dataTable1.Rows[0]["SAT1_VERB_400_P"].ToString(),50)
|| CCLib.Common.Strings.StringBiggerInteger(dataTable1.Rows[0]["SAT1_VERB_500_P"].ToString(),50)
|| CCLib.Common.Strings.StringBiggerInteger(dataTable1.Rows[0]["SAT1_VERB_600_P"].ToString(),50)
|| CCLib.Common.Strings.StringBiggerInteger(dataTable1.Rows[0]["SAT1_VERB_700_P"].ToString(),50))
strSATVerbal="<td valign=bottom><img src='../media/shared/ugsp_sat_chart_left2.gif' alt='Chart: 0%, 10%, 20%, 30%, 40%, 50%, 60%, 70%, 80%, 90%, 100%'width=72 height=340></td>";
else
strSATVerbal="<td><img src='../media/shared/ugsp_sat_chart_left.gif' alt='Chart: 0%, 10%, 20%, 30%, 40%, 50%, 60%' width=72 height=220></td>";
if(CCLib.Common.Strings.StringBiggerInteger(dataTable1.Rows[0]["SAT1_MATH_200_P"].ToString(),50)
|| CCLib.Common.Strings.StringBiggerInteger(dataTable1.Rows[0]["SAT1_MATH_300_P"].ToString(),50)
|| CCLib.Common.Strings.StringBiggerInteger(dataTable1.Rows[0]["SAT1_MATH_400_P"].ToString(),50)
|| CCLib.Common.Strings.StringBiggerInteger(dataTable1.Rows[0]["SAT1_MATH_500_P"].ToString(),50)
|| CCLib.Common.Strings.StringBiggerInteger(dataTable1.Rows[0]["SAT1_MATH_600_P"].ToString(),50)
|| CCLib.Common.Strings.StringBiggerInteger(dataTable1.Rows[0]["SAT1_MATH_700_P"].ToString(),50))
strSATMath="<td valign=bottom><img src='../media/shared/ugsp_sat_chart_left2.gif' alt='Chart: 0%, 10%, 20%, 30%, 40%, 50%, 60%, 70%, 80%, 90%, 100%'width=72 height=340></td>";
else
strSATMath="<td><img src='../media/shared/ugsp_sat_chart_left.gif' alt='Chart: 0%, 10%, 20%, 30%, 40%, 50%, 60%' width=72 height=220></td>";
if (CCLib.Common.Strings.StringBiggerInteger(dataTable1.Rows[0]["SAT1_Writing_200_P"].ToString(), 50)
|| CCLib.Common.Strings.StringBiggerInteger(dataTable1.Rows[0]["SAT1_Writing_300_P"].ToString(), 50)
|| CCLib.Common.Strings.StringBiggerInteger(dataTable1.Rows[0]["SAT1_Writing_400_P"].ToString(), 50)
|| CCLib.Common.Strings.StringBiggerInteger(dataTable1.Rows[0]["SAT1_Writing_500_P"].ToString(), 50)
|| CCLib.Common.Strings.StringBiggerInteger(dataTable1.Rows[0]["SAT1_Writing_600_P"].ToString(), 50)
|| CCLib.Common.Strings.StringBiggerInteger(dataTable1.Rows[0]["SAT1_Writing_700_P"].ToString(), 50))
strSATWriting = "<td valign=bottom><img src=../media/shared/ugsp_sat_chart_left2.gif width=72 height=340 alt='Chart: 0%, 10%, 20%, 30%, 40%, 50%, 60%, 70%, 80%, 90%, 100%'></td>";
else
strSATWriting = "<td><img src=../media/shared/ugsp_sat_chart_left.gif width=72 height=220 alt='Chart: 0%, 10%, 20%, 30%, 40%, 50%, 60%'></td>";
if(CCLib.Common.Strings.StringBiggerInteger(dataTable1.Rows[0]["ACT_1_P"].ToString(),50)
|| CCLib.Common.Strings.StringBiggerInteger(dataTable1.Rows[0]["ACT_2_P"].ToString(),50)
|| CCLib.Common.Strings.StringBiggerInteger(dataTable1.Rows[0]["ACT_3_P"].ToString(),50)
|| CCLib.Common.Strings.StringBiggerInteger(dataTable1.Rows[0]["ACT_4_P"].ToString(),50)
|| CCLib.Common.Strings.StringBiggerInteger(dataTable1.Rows[0]["ACT_5_P"].ToString(),50)
|| CCLib.Common.Strings.StringBiggerInteger(dataTable1.Rows[0]["ACT_6_P"].ToString(),50))
strACT="<td valign=bottom><img src='../media/shared/ugsp_sat_chart_left2.gif' alt='Chart: 0%, 10%, 20%, 30%, 40%, 50%, 60%, 70%, 80%, 90%, 100%'width=72 height=340></td>";
else
strACT="<td><img src='../media/shared/ugsp_sat_chart_left.gif' alt='Chart: 0%, 10%, 20%, 30%, 40%, 50%, 60%' width=72 height=220></td>";
if((dataTable1.Rows[0]["instate_area_code"].ToString() !="") || (dataTable1.Rows[0]["outstate_area_code"].ToString() !="")
|| (dataTable1.Rows[0]["fax_area_code"].ToString() !="")
|| (dataTable1.Rows[0]["ap_recd_1st_n"].ToString() !="") || (dataTable1.Rows[0]["ap_admt_1st_n"].ToString() !="")
|| (dataTable1.Rows[0]["ad_open"].ToString() !="") || (dataTable1.Rows[0]["ad_open_T"].ToString() !="") || (dataTable1.Rows[0]["ad_pref"].ToString() !="") || (dataTable1.Rows[0]["ad_pref_t"].ToString() !="")
|| (dataTable1.Rows[0]["ad_open"].ToString() !="") || (dataTable1.Rows[0]["ad_open_T"].ToString() !="") || (dataTable1.Rows[0]["ad_pref"].ToString() !="") || (dataTable1.Rows[0]["ad_pref_t"].ToString() !="")
|| (dtAppReq.Rows.Count!=0) || (dtEntrExam.Rows.Count!=0) || (dtPlaceExam.Rows.Count!=0)
|| (dataTable1.Rows[0]["AP_electronic"].ToString() !="")
)
bShow2=true;
if ((dataTable1.Rows[0]["TUIT_AREA_FT_D"].ToString()!="")
|| (dataTable1.Rows[0]["TUIT_NRES_FT_D"].ToString()!="")
|| (dataTable1.Rows[0]["TUIT_INTL_FT_D"].ToString()!="")
|| (dataTable1.Rows[0]["TUIT_STATE_FT_D"].ToString()!="")
|| (dataTable1.Rows[0]["TUIT_OVERALL_FT_D"].ToString() !="")
|| (dataTable1.Rows[0]["TUIT_VARY_PROG"].ToString()!="")
|| (dataTable1.Rows[0]["TUIT_VARY_LOC"].ToString()!="")
|| (dataTable1.Rows[0]["TUIT_VARY_TIME"].ToString()!="")
|| (dataTable1.Rows[0]["TUIT_VARY_LOAD"].ToString()!="")
|| (dataTable1.Rows[0]["TUIT_VARY_COURSE_LVL"].ToString()!="")
|| (dataTable1.Rows[0]["TUIT_VARY_DEG"].ToString()!="")
|| (dataTable1.Rows[0]["TUIT_VARY_RECIPROCITY"].ToString() !="")
|| (dataTable1.Rows[0]["TUIT_VARY_STUD"].ToString()!="")
|| (dataTable1.Rows[0]["RM_BD_VARY_BD"].ToString()=="X")
|| (dataTable1.Rows[0]["RM_BD_VARY_LOC"].ToString()=="X")
|| (dataTable1.Rows[0]["RM_BD_VARY_GENDER"].ToString()=="X")
|| (dataTable1.Rows[0]["RM_BD_VARY_HOUS"].ToString()=="X")
|| (dataTable1.Rows[0]["TUIT_PLAN_GUAR"].ToString()=="Y")
|| (dataTable1.Rows[0]["TUIT_PLAN_PREPAY"].ToString()=="Y")
|| (dataTable1.Rows[0]["TUIT_PLAN_INSTALL"].ToString()=="X")
|| (dataTable1.Rows[0]["TUIT_PLAN_DEFER"].ToString()=="X"))
bShow4=true;
if((dataTable1.Rows[0]["certif"].ToString() == "X")
|| (dataTable1.Rows[0]["diploma"].ToString() == "X")
|| (dataTable1.Rows[0]["deg_assoc_tfer"].ToString() == "X")
|| (dataTable1.Rows[0]["deg_assoc_term"].ToString() == "X")
|| (dataTable1.Rows[0]["deg_bach"].ToString() != "")
|| (dataTable1.Rows[0]["certif_fp"].ToString() == "X")
|| (dataTable1.Rows[0]["deg_fp"].ToString() == "X")
|| (dataTable1.Rows[0]["deg_master"].ToString() != "")
|| (dataTable1.Rows[0]["certif_post_master"].ToString() == "X")
|| (dataTable1.Rows[0]["deg_Doctor"].ToString() != "")
|| (dataTable1.Rows[0]["award_t"].ToString() != "")
|| (dataTable1.Rows[0]["assoc_t"].ToString() !="") || (dataTable1.Rows[0]["bach_t"].ToString() !="")
|| (dataTable1.Rows[0]["acad_core"].ToString() == "Y") || (dataTable1.Rows[0]["LANG"].ToString() == "Y")
|| (dataTable1.Rows[0]["MATH_SCI"].ToString() == "Y") || (dataTable1.Rows[0]["CMPTR"].ToString() == "Y")
|| (dataTable1.Rows[0]["INTERN_ALL"].ToString() == "Y") || (dataTable1.Rows[0]["INTERN_SOME"].ToString() == "Y")
|| (dataTable1.Rows[0]["SR_PROJ_ALL"].ToString() == "Y") || (dataTable1.Rows[0]["SR_PROJ_SOME_MAJ"].ToString() == "Y")
|| (dataTable1.Rows[0]["SR_PROJ_SOME_HON"].ToString() == "Y"))
bShow3=true;
if ((dataTable1.Rows[0]["EN_TOT_UG_N"].ToString()!="")
|| (dataTable1.Rows[0]["EN_GRAD_FT_MEN_N"].ToString()!="")
|| (dataTable1.Rows[0]["EN_GRAD_FT_WMN_N"].ToString()!="")
|| (dataTable1.Rows[0]["EN_GRAD_PT_MEN"].ToString()!="")
|| (dataTable1.Rows[0]["EN_GRAD_FT_WMN_N"].ToString()!="")
|| (dataTable1.Rows[0]["EN_TOT_FT_MEN_N"].ToString()!="")
|| (dataTable1.Rows[0]["EN_TOT_FT_WMN_N"].ToString()!="")
|| (dataTable1.Rows[0]["EN_TOT_PT_MEN_N"].ToString()!="")
|| (dataTable1.Rows[0]["EN_TOT_PT_WMN_N"].ToString()!="")
|| (dataTable1.Rows[0]["FRSH_HS_RANK_50_P"].ToString()!="")
|| (dataTable1.Rows[0]["FRSH_HS_RANK_25_P"].ToString()!="")
|| (dataTable1.Rows[0]["FRSH_HS_RANK_10_P"].ToString()!="")
|| (dataTable1.Rows[0]["FRSH_GPA"].ToString()!="")
|| (dataTable1.Rows[0]["SAT1_VERB_200_P"].ToString() !="")
|| (dataTable1.Rows[0]["SAT1_VERB_300_P"].ToString() !="")
|| (dataTable1.Rows[0]["SAT1_VERB_400_P"].ToString() !="")
|| (dataTable1.Rows[0]["SAT1_VERB_500_P"].ToString() !="")
|| (dataTable1.Rows[0]["SAT1_VERB_600_P"].ToString() !="")
|| (dataTable1.Rows[0]["SAT1_VERB_700_P"].ToString() !="")
|| (dataTable1.Rows[0]["SAT1_MATH_200_P"].ToString() !="")
|| (dataTable1.Rows[0]["SAT1_MATH_300_P"].ToString() !="")
|| (dataTable1.Rows[0]["SAT1_MATH_400_P"].ToString() !="")
|| (dataTable1.Rows[0]["SAT1_MATH_500_P"].ToString() !="")
|| (dataTable1.Rows[0]["SAT1_MATH_600_P"].ToString() !="")
|| (dataTable1.Rows[0]["SAT1_MATH_700_P"].ToString() !="")
|| (dataTable1.Rows[0]["ACT_1_P"].ToString() !="")
|| (dataTable1.Rows[0]["ACT_2_P"].ToString() !="")
|| (dataTable1.Rows[0]["ACT_3_P"].ToString() !="")
|| (dataTable1.Rows[0]["ACT_4_P"].ToString() !="")
|| (dataTable1.Rows[0]["ACT_5_P"].ToString() !="")
|| (dataTable1.Rows[0]["ACT_6_P"].ToString() !="")
)
bShow5=true;
if((dataTable1.Rows[0]["lib_main_name"].ToString() != "")
|| (dataTable1.Rows[0]["lib_vol_n"].ToString() != "")
|| (dataTable1.Rows[0]["lib_serials_n"].ToString() != "")
|| (dataTable1.Rows[0]["lib_micro_n"].ToString() != "")
|| (dataTable1.Rows[0]["lib_av_n"].ToString() != "")
|| (dataTable1.Rows[0]["lib_vol_n"].ToString() != "")
|| (dataTable1.Rows[0]["cmptr_n"].ToString() != "")
|| (dataTable1.Rows[0]["www"].ToString() == "X")
|| (dataTable1.Rows[0]["lab"].ToString() == "Y")
|| (dataTable1.Rows[0]["net"].ToString() == "Y")
|| (dataTable1.Rows[0]["net_stud_rm"].ToString() == "Y")
|| (dataTable1.Rows[0]["NET_OFFCMPS"].ToString() == "Y")
|| (dataTable1.Rows[0]["career_counsel_indv"].ToString() != "")
|| (dataTable1.Rows[0]["career_counsel_grp"].ToString() != "")
|| (dataTable1.Rows[0]["career_place"].ToString() != "")
|| (dataTable1.Rows[0]["career_recruit"].ToString() != "")
|| (dataTable1.Rows[0]["career_job_bank"].ToString() == "X")
|| (dataTable1.Rows[0]["career_job_fairs"].ToString() == "X")
|| (dataTable1.Rows[0]["career_job_iview"].ToString() == "X")
|| (dataTable1.Rows[0]["career_lib"].ToString() == "X")
|| (dataTable1.Rows[0]["career_resume_prep"].ToString() == "X")
|| (dataTable1.Rows[0]["career_resume_refer"].ToString() == "X")
|| (dataTable1.Rows[0]["career_testing"].ToString() == "X")
|| (dataTable1.Rows[0]["career_iview_wrkshp"].ToString() == "X")
|| (dataTable1.Rows[0]["career_oth_t"].ToString() != "")
|| (dataTable1.Rows[0]["SRVC_LEGAL"].ToString() == "Y")
|| (dataTable1.Rows[0]["SRVC_HEALTH"].ToString() == "Y")
|| (dataTable1.Rows[0]["SRVC_PSYCH"].ToString() == "Y")
|| (dataTable1.Rows[0]["SRVC_WMN_CTR"].ToString() == "Y")
)
bShow6=true;
if (((dataTable1.Rows[0]["hous"].ToString() == "Y")
&& ((dataTable1.Rows[0]["hous_coed"].ToString() == "X")
|| (dataTable1.Rows[0]["hous_men"].ToString() == "X")
|| (dataTable1.Rows[0]["hous_wmn"].ToString() == "X")))
|| (dataTable1.Rows[0]["hous_req_yr"].ToString() != "")
|| (dataTable1.Rows[0]["life_frat_nat"].ToString() == "Y")
|| (dataTable1.Rows[0]["life_frat_local"].ToString() == "Y")
|| (dataTable1.Rows[0]["life_sor_nat"].ToString() == "Y")
|| (dataTable1.Rows[0]["life_sor_local"].ToString() == "Y")
|| (dataTable1.Rows[0]["life_chorus"].ToString() == "Y")
|| (dataTable1.Rows[0]["life_drama"].ToString() == "Y")
|| (dataTable1.Rows[0]["life_band"].ToString() == "Y")
|| (dataTable1.Rows[0]["life_news"].ToString() == "Y")
|| (dataTable1.Rows[0]["life_radio"].ToString() == "Y")
|| (dataTable1.Rows[0]["life_television"].ToString() == "Y")
|| (dataTable1.Rows[0]["life_pbk"].ToString() == "Y")
|| (dataTable1.Rows[0]["life_sx"].ToString() == "Y")
|| (dataTable1.Rows[0]["life_org_1_t"].ToString() != "")
|| (dataTable1.Rows[0]["life_org_2_t"].ToString() != "")
|| (dataTable1.Rows[0]["life_org_3_t"].ToString() != "")
|| (dataTable1.Rows[0]["life_org_4_t"].ToString() != "")
|| (dataTable1.Rows[0]["life_org_5_t"].ToString() != "")
|| (dataTable1.Rows[0]["life_event_1_t"].ToString() != "")
|| (dataTable1.Rows[0]["life_event_2_t"].ToString() != "")
|| (dataTable1.Rows[0]["life_event_3_t"].ToString() != ""))
bShow7=true;
if ((bSportScholarships)
|| (bIntraSports)
|| (bInterSports)
|| (dataTable1.Rows[0]["assn_athl_ncaa"].ToString() !="")
|| (dataTable1.Rows[0]["assn_athl_naia"].ToString()=="X")
|| (dataTable1.Rows[0]["assn_athl_nccaa"].ToString()=="X")
|| (dataTable1.Rows[0]["assn_athl_nscaa"].ToString()=="X")
|| (dataTable1.Rows[0]["assn_athl_njcaa"].ToString()=="X"))
bShow8=true;
}
/// <summary>
/// 显示所有请假记录
/// </summary>
/// <returns>请假单信息</returns>
public ListResult <OrderModel> List(int pageNo, int pageSize, SortModel sort, FilterModel filter)
{
using (var dbContext = new MissionskyOAEntities())
{
var list = dbContext.Orders.Where(it => ((it.OrderType != (int)OrderType.Overtime))).AsEnumerable();
if (filter != null && filter.Member == "UserName")
{
var userList = dbContext.Users.Where(it => it.EnglishName == filter.Value);
switch (filter.Operator)
{
case "IsEqualTo":
userList = dbContext.Users.Where(it => it.EnglishName == filter.Value);
break;
case "IsNotEqualTo":
userList = dbContext.Users.Where(it => it.EnglishName != filter.Value);
break;
case "StartsWith":
userList =
dbContext.Users.Where(
it =>
it.EnglishName != null &&
it.EnglishName.ToLower().StartsWith(filter.Value.ToLower()));
break;
case "Contains":
userList =
dbContext.Users.Where(
it =>
it.EnglishName != null &&
it.EnglishName.ToLower().Contains(filter.Value.ToLower()));
break;
case "DoesNotContain":
userList =
dbContext.Users.Where(
it =>
it.EnglishName != null &&
!it.EnglishName.ToLower().Contains(filter.Value.ToLower()));
break;
case "EndsWith":
userList =
dbContext.Users.Where(
it =>
it.EnglishName != null &&
it.EnglishName.ToLower().EndsWith(filter.Value.ToLower()));
break;
}
List <int> userIds = new List <int>();
userList.ToList().ForEach(item =>
{
userIds.Add(item.Id);
});
list = list.Where(it => userIds.Contains(it.UserId));
}
if (filter != null && filter.Member == "CreatedTime")
{
var dtFormat = new System.Globalization.DateTimeFormatInfo()
{
ShortDatePattern = "yyyy-MM-dd"
};
var dt = Convert.ToDateTime(filter.Value, dtFormat);
switch (filter.Operator)
{
case "IsEqualTo":
list = list.Where(it => it.CreatedTime.Value.Date == dt);
break;
case "IsNotEqualTo":
list = list.Where(it => it.CreatedTime.Value.Date != dt);
break;
case "IsGreaterThan":
list = list.Where(it => it.CreatedTime.Value.Date > dt);
break;
case "IsLessThan":
list = list.Where(it => it.CreatedTime.Value.Date < dt);
break;
case "IsGreaterThanOrEqualTo":
list = list.Where(it => it.CreatedTime.Value.Date >= dt);
break;
case "IsLessThanOrEqualTo":
list = list.Where(it => it.CreatedTime.Value.Date >= dt);
break;
}
}
if (sort != null)
{
switch (sort.Member)
{
case "CreatedTime":
if (sort.Direction == SortDirection.Ascending)
{
list = list.OrderBy(item => item.CreatedTime);
}
else
{
list = list.OrderByDescending(item => item.CreatedTime);
}
break;
default:
break;
}
}
var count = list.Count();
list = list.Skip((pageNo - 1) * pageSize).Take(pageSize).ToList();
var result = new ListResult <OrderModel>()
{
Data = new List <OrderModel>()
};
list.ToList().ForEach(item =>
{
var order = item.ToModel();
if (result.Data.Any(it => it.OrderNo == order.OrderNo) == false) //过滤批量申请，重复的申请单
{
OrderService.DoFill(dbContext, order);
result.Data.Add(order);
}
});
result.Total = count;
return(result);
}
}
public void Report()
{
string selectedServer = "";
string selectedServerList = "";
string date;
//12/24/2013 NS added
string downMin = "";
exactmatch = false;
//1/30/2015 NS added for VSPLUS-1370
string selectedType = "";
selectedTypeList = "";
if (this.ServerFilterTextBox.Text != "")
{
selectedServer = this.ServerFilterTextBox.Text;
}
if (this.ServerListFilterListBox.SelectedItems.Count > 0)
{
selectedServer = "";
for (int i = 0; i < this.ServerListFilterListBox.SelectedItems.Count; i++)
{
selectedServer += this.ServerListFilterListBox.SelectedItems[i].Text + ",";
selectedServerList += "'" + this.ServerListFilterListBox.SelectedItems[i].Text + "'" + ",";
}
exactmatch = true;
try
{
selectedServer = selectedServer.Substring(0, selectedServer.Length - 1);
selectedServerList = selectedServerList.Substring(0, selectedServerList.Length - 1);
}
catch
{
selectedServer = ""; // throw ex;
selectedServerList = "";
exactmatch = false;
}
finally { }
}
//12/24/2013 NS added
//downMin = DownFilterTextBox.Text;
//10/23/2013 NS modified - added jQuery month/year control
/*
* if (this.DateParamEdit.Text == "")
* {
* date = DateTime.Now.ToString();
* this.DateParamEdit.Date = Convert.ToDateTime(date);
* }
* else
* {
* date = this.DateParamEdit.Value.ToString();
* }
*/
if (startDate.Value.ToString() == "")
{
date = DateTime.Now.ToString();
}
else
{
date = startDate.Value.ToString();
}
//1/30/2015 NS added for VSPLUS-1370
if (this.ServerTypeFilterListBox.SelectedItems.Count > 0)
{
selectedType = "";
for (int i = 0; i < this.ServerTypeFilterListBox.SelectedItems.Count; i++)
{
selectedType += this.ServerTypeFilterListBox.SelectedItems[i].Text + ",";
selectedTypeList += "'" + this.ServerTypeFilterListBox.SelectedItems[i].Text + "'" + ",";
}
try
{
selectedType = selectedType.Substring(0, selectedType.Length - 1);
selectedTypeList = selectedTypeList.Substring(0, selectedTypeList.Length - 1);
}
catch
{
selectedType = ""; // throw ex;
selectedTypeList = "";
}
finally { }
}
DateTime dt = Convert.ToDateTime(date);
//11/11/2015 NS added for VSPLUS-2023
if (dt.Month == DateTime.Now.Month && dt.Year == DateTime.Now.Year)
{
dt = DateTime.Now;
}
DashboardReports.ServerUpTimeXtraRpt report = new DashboardReports.ServerUpTimeXtraRpt();
report.Parameters["DateM"].Value = dt.Month;
report.Parameters["DateY"].Value = dt.Year;
System.Globalization.DateTimeFormatInfo mfi = new System.Globalization.DateTimeFormatInfo();
string strMonthName = mfi.GetMonthName(dt.Month).ToString() + ", " + dt.Year.ToString();
report.Parameters["MonthYear"].Value = strMonthName;
report.Parameters["ServerName"].Value = selectedServer;
report.Parameters["ServerNameSQL"].Value = selectedServerList;
report.Parameters["ExactMatch"].Value = exactmatch;
//12/24/2013 NS added
report.Parameters["DownMin"].Value = downMin;
//1/30/2015 NS added for VSPLUS-1370
report.Parameters["ServerType"].Value = selectedType;
report.Parameters["ServerTypeSQL"].Value = selectedTypeList;
report.Parameters["RptType"].Value = this.MinPctRadioButtonList.SelectedItem.Value;
report.Parameters["DateD"].Value = dt.Day;
report.PageColor = Color.Transparent;
report.CreateDocument();
ASPxDocumentViewer1.Report = report;
ASPxDocumentViewer1.DataBind();
}
/* This method returns the month name according to the month id
* @param id : integer value which represents a month
* @returns strMonthName : String name of the month for given id
*/
public String getMonthByID(int id)
{
// Create a object to format the month id given
System.Globalization.DateTimeFormatInfo mfi = new System.Globalization.DateTimeFormatInfo();
string strMonthName = mfi.GetMonthName(id).ToString(); // Convert month id to month name
return strMonthName;
}
public Calculo(int Cliente)
{
_Cliente = Cliente;
System.Globalization.DateTimeFormatInfo x = new System.Globalization.DateTimeFormatInfo();
x.FirstDayOfWeek = DayOfWeek.Monday;
int DiaDeLaSemana = (int)(DateTime.Now.DayOfWeek);
DateTime SourceDate = DateTime.MinValue;
string strCalculo = "";
Programacion oProg;
oProg = new Programacion(_Cliente);
int _TotalRegistros = oProg.ProgramacionesAsignadas.Count;
if (_TotalRegistros <= 0)
{
throw new ApplicationException("El cliente " + _Cliente.ToString() + " no tiene programaciones asignadas.");
}
//Carga de los ultimos 5 pedidos de gas del cliente, ordenados cronológicamente
SqlDataReader dr;
////Dim cn As New SqlConnection(SigaMetClasses.LeeInfoConexion(False))
SqlConnection cn = SigaMetClasses.DataLayer.Conexion;
SqlCommand cmd = new SqlCommand("spCCConsultaUltimos5PedidosCliente", cn);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Clear();
cmd.Parameters.Add("@Cliente", SqlDbType.Int);
cmd.Parameters[0].Value = _Cliente;
try
{
cn.Open();
dr = cmd.ExecuteReader(CommandBehavior.CloseConnection);
}
catch (Exception ex)
{
throw new Exception("No se pudo conectar a la base de datos.", ex);
}
//Exit Sub
// //**CALCULO PARA LA FECHA ORÍGEN
////Leo el primer registro
dr.Read();
try
{
// //Checo cuál es el status de ese pedido
switch (((String)(dr["Status"])).Trim())
{
case "SURTIDO": ////Si está surtido...
SourceDate = ((DateTime)(dr["FSuministro"])).Date; ////Tomo en cuenta su fecha de suministro
strCalculo += "SURTIDO - Pedido: " + dr["PedidoReferencia"].ToString().Trim() + "// Fecha Orígen: " + SourceDate.ToShortDateString();
break;
case "CANCELADO": //Si está cancelado...
strCalculo += " ***EL ULTIMO PEDIDO FUE CANCELADO*** ";
if (((byte)(dr["TipoPedido"]) == 2)) //Si era programado...
{
SourceDate = ((DateTime)(dr["FCancelacion"])).Date; //Tomo en cuenta su fecha de cancelación (REGLA)
strCalculo += "CANCELADO - Pedido: " + dr["PedidoReferencia"].ToString().Trim() + "/ Fecha Orígen: " + SourceDate.ToShortDateString();
}
else //De lo contrario tomo en cuenta la fecha del último pedido suministrado (REGLA)
{
strCalculo += " //Leyendo el histórico.../// ";
while (dr.Read())
{
if (((String)(dr["Status"])).Trim() == "SURTIDO")
{
SourceDate = (((DateTime)(dr["FSuministro"]))).Date;
strCalculo += "SURTIDO - Pedido: " + dr["PedidoReferencia"].ToString().Trim() + "/ Fecha Orígen: " + SourceDate.ToShortDateString();
}
else
{
//De plano si no tiene un pedido surtido en su historial, lo programo para mañana!
SourceDate = FechaServidor.AddDays(1);
strCalculo += "El cliente no tiene histórico pedidos surtidos. Se programará para el día de mañana " + SourceDate.ToShortDateString();
}
}
}
break;
case "ACTIVO": //Si está activo
SourceDate = (((DateTime)(dr["FCompromiso"]))).Date;
strCalculo += " [El último pedido está activo. Se tomará en cuenta la fecha de compromiso de éste [" + SourceDate.ToShortDateString() + "]";
break;
}
}
catch (Exception ex)
{
throw new Exception("Error fatal!", ex);
}
//De plano... DE PLANO si no se pudo determinar la fecha orígen... entonces hay un error!
if (SourceDate == DateTime.MinValue)
{
throw new Exception("No se pudo determinar la fecha orígen para la programación.");
}
_Calculo = strCalculo;
if (cn.State == ConnectionState.Open)
{
cn.Close();
}
_FProximoPedido = SiguienteFecha(_FOrigen, _Cliente);
}
protected override void InitForm()
{
Pub.SetFormAppIcon(this);
System.Globalization.DateTimeFormatInfo fmtInfo = System.Threading.Thread.CurrentThread.CurrentUICulture.DateTimeFormat;
LocalFormat = "dddd " + fmtInfo.LongDatePattern + " " + fmtInfo.LongTimePattern;
Rectangle rect = Screen.PrimaryScreen.WorkingArea;
formCode = "Main";
base.InitForm();
MDICaption = SystemInfo.AppTitle + " " + SystemInfo.AppVersion;
if (SystemInfo.CustomerName != "")
{
MDICaption = MDICaption + "[" + SystemInfo.CustomerName + "]";
}
this.Left = rect.Left;
this.Top = rect.Top;
this.Width = rect.Width;
this.Height = rect.Height;
this.WindowState = FormWindowState.Maximized;
this.Text = SystemInfo.AppTitle;
SystemInfo.SystemIsExit = false;
SystemInfo.MainHandle = this.Handle;
lblUser.Text = lblUser.Text + OprtInfo.OprtNoAndName;
lblAcc.Text = lblAcc.Text + SystemInfo.AccDBName;
if (SystemInfo.AccDBName != SystemInfo.DatabaseName)
{
lblAcc.Text = lblAcc.Text + "[" + SystemInfo.DatabaseName + "]";
}
SystemInfo.funcList.Clear();
int itemIndex = 1;
LoadDll(ref objRS, ref tpRS, "ECard.RS.dll", ref itemIndex, mnuRS_Click);
LoadDll(ref objKQ, ref tpKQ, "ECard.KQ.dll", ref itemIndex, mnuKQ_Click);
LoadDll(ref objMJ, ref tpMJ, "ECard.MJNew.dll", ref itemIndex, mnuMJ_Click);
if (objMJ == null || tpMJ == null)
{
LoadDll(ref objMJ, ref tpMJ, "ECard.MJ.dll", ref itemIndex, mnuMJ_Click);
}
SystemInfo.IsNewMJ = MJIsNew(objMJ, tpMJ);
LoadDll(ref objSF, ref tpSF, "ECard.SF.dll", ref itemIndex, mnuSF_Click);
LoadDll(ref objSK, ref tpSK, "ECard.SK.dll", ref itemIndex, mnuSK_Click);
SystemInfo.HasRS = (objRS != null) && (tpRS != null);
SystemInfo.HasKQ = (objKQ != null) && (tpKQ != null);
SystemInfo.HasMJ = (objMJ != null) && (tpMJ != null);
SystemInfo.HasSF = (objSF != null) && (tpSF != null);
SystemInfo.HasSK = (objSK != null) && (tpSK != null);
SystemInfo.KQFlag = KQFlag(objKQ, tpKQ);
if (SystemInfo.HasRS)
{
LoadDll(ref objRSReport, ref tpRSReport, "RSReport.dll", ref itemIndex, mnuRSReport_Click, false);
}
if (SystemInfo.HasKQ)
{
LoadDll(ref objKQReport, ref tpKQReport, "KQReport.dll", ref itemIndex, mnuKQReport_Click, false);
}
if (SystemInfo.HasMJ)
{
LoadDll(ref objMJReport, ref tpMJReport, "MJReport.dll", ref itemIndex, mnuMJReport_Click, false);
}
if (SystemInfo.HasSF)
{
LoadDll(ref objSFReport, ref tpSFReport, "SFReport.dll", ref itemIndex, mnuSFReport_Click, false);
}
if (SystemInfo.HasSK)
{
LoadDll(ref objSKReport, ref tpSKReport, "SKReport.dll", ref itemIndex, mnuSKReport_Click, false);
}
SystemInfo.HasFaCard = false;
if ((SystemInfo.HasKQ && ((SystemInfo.KQFlag == 0) || (SystemInfo.KQFlag == 2))) || SystemInfo.HasSF || SystemInfo.HasSK)
{
SystemInfo.HasFaCard = true;
}
ToolBar.Items.Clear();
AddToolbarButton(mnuWindowClose.Text, mnuWindowClose.Image, mnuWindowClose_Click);
AddToolbarSeparator();
AddToolbarButton(mnuSYClose.Text, mnuSYClose.Image, mnuSYClose_Click);
string dllName = "";
System.Collections.ArrayList objList = new System.Collections.ArrayList();
System.Collections.ArrayList tpList = new System.Collections.ArrayList();
System.Collections.ArrayList naList = new System.Collections.ArrayList();
Assembly obj;
Type tp;
string na;
for (int i = 1; i <= 10; i++)
{
dllName = SystemInfo.ini.ReadIni("ExtDll", i.ToString(), "");
if (dllName == "")
{
continue;
}
if (!File.Exists(SystemInfo.AppPath + dllName))
{
continue;
}
obj = null;
tp = null;
LoadDll(ref obj, ref tp, dllName, ref itemIndex, mnuExt_Click);
na = GetDllName(obj, tp);
objList.Add(obj);
tpList.Add(tp);
naList.Add(na);
}
ExtModuleInfo.objDll = new Assembly[objList.Count];
ExtModuleInfo.tpDll = new Type[objList.Count];
ExtModuleInfo.homeName = new string[objList.Count];
for (int i = 0; i < objList.Count; i++)
{
ExtModuleInfo.objDll[i] = (Assembly)objList[i];
ExtModuleInfo.tpDll[i] = (Type)tpList[i];
ExtModuleInfo.homeName[i] = (string)naList[i];
}
ShowMDIForm(new frmMainHome());
db.SetConnStr(SystemInfo.ConnStr);
RegisterInfo.Serial = db.GetRegSerial();
RegisterInfo.EmpCount = db.GetEmpCount();
RegisterInfo.ModuleCount = 0;
if (SystemInfo.HasKQ)
{
RegisterInfo.ModuleCount += 1;
}
if (SystemInfo.HasMJ)
{
RegisterInfo.ModuleCount += 1;
}
if (SystemInfo.HasSF)
{
RegisterInfo.ModuleCount += 1;
}
if (SystemInfo.HasSK)
{
RegisterInfo.ModuleCount += 1;
}
if (ExtModuleInfo.objDll != null)
{
RegisterInfo.ModuleCount += ExtModuleInfo.objDll.Length;
}
RegisterInfo.MustReg = db.ReadConfig("SystemRegister", "MustReg", false);
if (SystemInfo.DBType == 1)
{
Database dbSerial = new Database(GetConnStrSystem());
try
{
if (!dbSerial.IsOpen)
{
dbSerial.Open();
}
string tmpSerial = dbSerial.GetDBServerSerial();
if (tmpSerial != "")
{
RegisterInfo.Serial = tmpSerial;
}
}
finally
{
dbSerial.Close();
}
}
db.IsRegister(true, "", "");
RegisterInfo.AllowReg = (RegisterInfo.EmpCount >= 300) || (RegisterInfo.ModuleCount > 1) || RegisterInfo.MustReg;
SetMDICaption();
if (SystemInfo.HasRS)
{
db.UpdateModuleResources(this.Text, objRS);
}
if (SystemInfo.HasKQ)
{
db.UpdateModuleResources(this.Text, objKQ);
}
if (SystemInfo.HasMJ)
{
db.UpdateModuleResources(this.Text, objMJ);
}
if (SystemInfo.HasSF)
{
db.UpdateModuleResources(this.Text, objSF);
}
if (SystemInfo.HasSK)
{
db.UpdateModuleResources(this.Text, objSK);
}
if (objRSReport != null)
{
db.UpdateModuleResources(this.Text, objRSReport);
}
if (objKQReport != null)
{
db.UpdateModuleResources(this.Text, objKQReport);
}
if (objMJReport != null)
{
db.UpdateModuleResources(this.Text, objMJReport);
}
if (objSFReport != null)
{
db.UpdateModuleResources(this.Text, objSFReport);
}
if (objSKReport != null)
{
db.UpdateModuleResources(this.Text, objSKReport);
}
DataTableReader dr = null;
try
{
dr = db.GetDataReader(Pub.GetSQL(DBCode.DB_000002, new string[] { "2" }));
if (dr.Read())
{
SystemInfo.AccDBVersion = dr["DbVersion"].ToString() + ".";
DateTime dt = Convert.ToDateTime(dr["DbDate"]);
SystemInfo.AccDBVersion = SystemInfo.AccDBVersion + dt.ToString(SystemInfo.DateFormatDBVer);
}
}
finally
{
if (dr != null)
{
dr.Close();
}
dr = null;
}
}
private void btnFinish_Click(object sender, EventArgs e)
{
if (string.IsNullOrEmpty(this.txtTicketName.Text))
{
XtraMessageBox.Show("请输入操作票名称!", "提示", MessageBoxButtons.OK, MessageBoxIcon.Information);
return;
}
if (string.IsNullOrEmpty(this.txtTaskName.Text))
{
XtraMessageBox.Show("请输入操作任务!", "提示", MessageBoxButtons.OK, MessageBoxIcon.Information);
return;
}
if (string.IsNullOrEmpty(this.txtNo.Text))
{
XtraMessageBox.Show("请输入操作编号!", "提示", MessageBoxButtons.OK, MessageBoxIcon.Information);
return;
}
if (string.IsNullOrEmpty(this.txtOperationDate.Text))
{
XtraMessageBox.Show("请选择操作日期!", "提示", MessageBoxButtons.OK, MessageBoxIcon.Information);
return;
}
if (string.IsNullOrEmpty(this.txtUser.Text))
{
XtraMessageBox.Show("请输入开票人!", "提示", MessageBoxButtons.OK, MessageBoxIcon.Information);
return;
}
if (this.viewRoom.RowCount < 1)
{
XtraMessageBox.Show("请录入操作步骤!", "提示", MessageBoxButtons.OK, MessageBoxIcon.Information);
return;
}
if (this.txtStartTime.Text == "00:00:00")
{
if (XtraMessageBox.Show(string.Format("确认操作开始时间为 00:00:00 吗?"), "提示", MessageBoxButtons.OKCancel, MessageBoxIcon.Information) == DialogResult.Cancel)
{
return;
}
}
if (this.txtEndTime.Text == "00:00:00")
{
if (XtraMessageBox.Show(string.Format("确认操作结束时间为 00:00:00 吗?"), "提示", MessageBoxButtons.OKCancel, MessageBoxIcon.Information) == DialogResult.Cancel)
{
return;
}
}
System.Globalization.DateTimeFormatInfo dtForm = new System.Globalization.DateTimeFormatInfo();
dtForm.ShortTimePattern = "HH:mm:ss";
if (Convert.ToDateTime(this.txtStartTime.Text, dtForm) > Convert.ToDateTime(this.txtEndTime.Text, dtForm))
{
if (XtraMessageBox.Show(string.Format("确认操作开始时间大于结束时间吗?"), "提示", MessageBoxButtons.OKCancel, MessageBoxIcon.Information) == DialogResult.Cancel)
{
return;
}
}
if (this.txtStartTime.Text == this.txtEndTime.Text)
{
XtraMessageBox.Show("操作开始时间和结束时间相同!", "提示", MessageBoxButtons.OK, MessageBoxIcon.Information);
return;
}
Dictionary <string, string> dicTicket = new Dictionary <string, string>();
dicTicket["No"] = this.txtNo.Text;;
dicTicket["Name"] = this.txtTicketName.Text;
dicTicket["Task"] = this.txtTaskName.Text;
dicTicket["OperationDate"] = this.txtOperationDate.Text;
dicTicket["User"] = this.txtUser.Text;
dicTicket["StartTime"] = this.txtStartTime.Text;
dicTicket["EndTime"] = this.txtEndTime.Text;
dicTicket["CreateTime"] = this.txtCreateTime.Text;
dicTicket["CreateComment"] = this.txtCreateComment.Text;
for (int i = 0; i < dtGridView.Rows.Count; i++)
{
dtGridView.Rows[i]["CreateTime"] = this.txtCreateTime.Text;
}
if (!sqlTool.AddTicket(dicTicket))
{
XtraMessageBox.Show("新增操作票失败!", "提示", MessageBoxButtons.OK, MessageBoxIcon.Information);
return;
}
if (!sqlTool.AddOperations(dtGridView))
{
XtraMessageBox.Show("新增操作票步骤失败!", "提示", MessageBoxButtons.OK, MessageBoxIcon.Information);
return;
}
this.DialogResult = DialogResult.OK;
this.Close();
}
private int[] AddData()
{
int[] result = new int[2];
if (Session["UserId"] != null && Session["UserId"].ToString() != string.Empty)
{
int PortalId = Convert.ToInt32(ddlPortalList.SelectedValue);
int ContentItemId = int.Parse(ddlContentItem.SelectedValue);
int RouteId = int.Parse(ddlRouterList.SelectedValue);
string TabName = txt_TabName.Text;
string Title = txt_Title.Text;
int ParentId = int.Parse(ddlParentTab.SelectedValue);
string Description = txt_Desc.Text;
string Keywords = txt_Keywords.Text;
string Url = txt_Url.Text;
string TabPath = txt_Path.Text;
decimal SiteMapPriority = Convert.ToDecimal(txtSiteMapPriority.Text) / 10;
string PageHeadText = txt_PageHeadText.Text;
string PageFooterText = txt_PageFooterText.Text;
string CssClass = txt_CssClass.Text;
string CultureCode = ddlCultureCode.SelectedValue;
// string StartDate=txt_StartDate.Text;
// string EndDate= txt_EndDate.Text;
#region xu ly thoi gian ====================================================================================
System.Globalization.DateTimeFormatInfo MyDateTimeFormatInfo = new System.Globalization.DateTimeFormatInfo();
MyDateTimeFormatInfo.ShortDatePattern = "dd/MM/yyyy";
string StartDate = null, EndDate = null;
if (txt_StartDate.Text != string.Empty && txt_StartDate.Text != "__/__/____")
{
DateTime _start_date = DateTime.Parse(txt_StartDate.Text, MyDateTimeFormatInfo);
StartDate = _start_date.ToString("yyyy-MM-dd");
}
if (txt_EndDate.Text != string.Empty && txt_EndDate.Text != "__/__/____")
{
DateTime _end_date = DateTime.Parse(txt_EndDate.Text, MyDateTimeFormatInfo);
EndDate = _end_date.ToString("yyyy-MM-dd");
}
if (txt_StartDate.Text != string.Empty && txt_StartDate.Text != "__/__/____" &&
txt_EndDate.Text != string.Empty && txt_EndDate.Text != "__/__/____")
{
DateTime _start_date = DateTime.Parse(txt_StartDate.Text, MyDateTimeFormatInfo);
DateTime _end_date = DateTime.Parse(txt_EndDate.Text, MyDateTimeFormatInfo);
if (DateTime.Compare(_start_date, _end_date) > 0)
{
string scriptCode = "<script>alert('Thời điểm bắt đầu phải nhỏ hơn thời điểm kết thúc');</script>";
Page.ClientScript.RegisterClientScriptBlock(this.GetType(), "scriptName", scriptCode);
}
}
#endregion ================================================================================================
/*** UPLOAD *************************************************************************************************************/
HttpPostedFile icon_file = FileIconInput.PostedFile;
HttpPostedFile icon_large_file = FileIconLargeInput.PostedFile;
string IconFileName = "", IconFileLargeName = "", IconFilePath = string.Empty, IconFileLargePath = string.Empty;
if (icon_file.ContentLength > 0)
{
ModuleClass module_obj = new ModuleClass();
IconFileName = module_obj.GetEncodeString(System.IO.Path.GetFileName(icon_file.FileName));
IconFilePath = Server.MapPath(small_icon_path + "/" + IconFileName);
icon_file.SaveAs(IconFilePath);
}
if (icon_large_file.ContentLength > 0)
{
IconFileLargeName = System.IO.Path.GetFileName(icon_large_file.FileName);
IconFileLargePath = Server.MapPath(large_icon_path + "/" + IconFileLargeName);
icon_file.SaveAs(IconFileLargePath);
}
/************************************************************************************************************************/
bool IsDeleted = true, IsVisible = true, DisableLink = false, DisplayTitle = false, IsSecure = false, PermanentRedirect = false;
IsDeleted = chkIsDelete.Checked;
IsVisible = chkIsVisible.Checked;
DisableLink = chkDisableLink.Checked;
DisplayTitle = chkDisplayTitle.Checked;
IsSecure = chkIsSecure.Checked;
PermanentRedirect = chkPermanentRedirect.Checked;
result = tab_obj.Insert(PortalId, ContentItemId, ParentId, TabName, Title, CssClass,
IconFileName, IconFileLargeName, Description, Keywords, DisplayTitle, IsDeleted, IsVisible,
DisableLink, IsSecure, PermanentRedirect, SiteMapPriority, Url, TabPath, RouteId, PageHeadText, PageFooterText, "", StartDate, EndDate, CultureCode, UserId);
}
return(result);
}
private string[] loadFile( bool setPomodoroCount)
{
string[] lines = _storage.GetAllLines();
bool lastLineIsToday = false;
string lastLine = "";
if (lines.Length > 0)
lastLine = lines.Last();
if(lastLine.Length >0)
{
string[] components = lastLine.Split(',');
if (components.Length >= 2)
{
string date = components[0];
string pomodoros = components[1];
IFormatProvider provider = new System.Globalization.DateTimeFormatInfo();
if(DateTime.ParseExact(date,"yyyyMMdd", provider).Date == DateTime.Now.Date)
{
lastLineIsToday = true;
if(setPomodoroCount)
_pomodorosToday = int.Parse(pomodoros);
}
}
}
if(lastLineIsToday)// Special Treatment for today's line
{
string[] result = new string[lines.Count()-1];
Array.Copy(lines, 0, result, 0, lines.Count() - 1);// remove the last line from our array as we will update the count.
return result;
}
else
{
return lines;
}
}
public string GetIndexableFormat(string propertyName, string value)
{
if (!_map.ContainsKey(propertyName)) return value;
string type = _map[propertyName];
string retval = value;
switch (type)
{
case "Date":
System.Globalization.DateTimeFormatInfo dfi = new System.Globalization.DateTimeFormatInfo();
//dfi.ShortDatePattern = "YYYYMMDD";
DateTime dt = DateTime.Parse(value);
//retval = dt.ToString("s");
//retval = _convertDateStringToIndexable(dt.ToShortDateString());
retval = dt.ToString(dfi.SortableDateTimePattern);
break;
case "Number":
long l = long.Parse(value);
retval = l.ToString("000000000000");
break;
default:
break;
}
return retval;
}
private void btnNextDinner_Click(object sender, EventArgs e)
{
List<int> users = new List<int>();
for (int i = 0; i < ds.Tables["user"].Rows.Count; i++)
{
if (Convert.ToBoolean(ds.Tables["user"].Rows[i]["Active"]))
{
users.Add(i);
}
}
int numUsers = users.Count;
int numDinners = (numUsers + 2) / 4;
int currentDinner;
bool isSorted;
List<int> remaining = new List<int>();
int[,] hostedCountSorted, currDinnerGridTally = new int[2, numUsers];
int[,] dinners = new int[numDinners, 5];
string date = "";
for (int i = 0; i < dinners.GetLength(0); i++)
{
for (int j = 0; j < dinners.GetLength(1); j++)
{
dinners[i, j] = -1;
}
}
int to, from, temp1, temp2;
//get date
System.Globalization.DateTimeFormatInfo mfi = new System.Globalization.DateTimeFormatInfo();
date = mfi.GetAbbreviatedMonthName(dateTimePicker1.Value.Month) + " " + dateTimePicker1.Value.Year;
hostedCountSorted = new int[2, numUsers];
for (int i = 0; i < numUsers; i++)
{
hostedCountSorted[0, i] = users[i];
hostedCountSorted[1, i] = Convert.ToInt16(ds.Tables["user"].Rows[users[i]]["Host#"].ToString()) + 1;
}
//host month/active exceptions
int dateMonth = dateTimePicker1.Value.Month;
int userMonth;
for (int i = 0; i < numUsers; i++)
{
userMonth = Convert.ToInt16(ds.Tables["user"].Rows[users[i]]["Month"]);
if (userMonth == dateMonth)
{
hostedCountSorted[1, users[i]] = 0;
}
else if (userMonth != 0)
{
hostedCountSorted[1, users[i]] = Int16.MaxValue;
}
}
//randomize
Random rnd = new Random();
for (int i = 0; i < numUsers * 2; i++)
{
to = rnd.Next(0, hostedCountSorted.GetLength(1));
from = rnd.Next(0, hostedCountSorted.GetLength(1));
temp1 = hostedCountSorted[0, to];
temp2 = hostedCountSorted[1, to];
hostedCountSorted[0, to] = hostedCountSorted[0, from];
hostedCountSorted[1, to] = hostedCountSorted[1, from];
hostedCountSorted[0, from] = temp1;
hostedCountSorted[1, from] = temp2;
}
//sort
do
{
isSorted = true;
for (int i = 0; i < hostedCountSorted.GetLength(1) - 1; i++)
{
if (hostedCountSorted[1, i] > hostedCountSorted[1, i + 1])
{
//swap hosted values
temp1 = hostedCountSorted[1, i];
hostedCountSorted[1, i] = hostedCountSorted[1, i + 1];
hostedCountSorted[1, i + 1] = temp1;
//swap id
temp1 = hostedCountSorted[0, i];
hostedCountSorted[0, i] = hostedCountSorted[0, i + 1];
hostedCountSorted[0, i + 1] = temp1;
isSorted = false;
}
}
} while (!isSorted);
//choose the lowest x hosts, where x is the number of dinners
for (int i = 0; i < numDinners; i++)
{
//update number of times user has hosted
ds.Tables["user"].Rows[hostedCountSorted[0, i]]["Host#"] = Convert.ToInt16(ds.Tables["user"].Rows[hostedCountSorted[0, i]]["Host#"].ToString()) + 1;
//add host id to dinner array
dinners[i, 0] = hostedCountSorted[0, i];
}
//list of ids
remaining = users; //(basically name change)
//remove hosts from grid copy
for (int i = 0; i < dinners.GetLength(0); i++)
{
remaining.Remove(dinners[i, 0]);
}
//for each person left, find them a group
currentDinner = 0;
while (remaining.Count > 0)
{
//get grid tally for all users according to people in current group
currDinnerGridTally = new int[2, remaining.Count];
for (int i = 0; i < dinners.GetLength(1); i++)
{
if (dinners[currentDinner, i] == -1)
break;
for (int j = 0; j < remaining.Count; j++)
{
currDinnerGridTally[0, j] = remaining[j];
currDinnerGridTally[1, j] += Convert.ToInt16(ds.Tables["matchCount"].Rows[dinners[currentDinner, i]][remaining[j]]);
}
}
//randomize
for (int i = 0; i < currDinnerGridTally.GetLength(1) * 2; i++)
{
to = rnd.Next(0, currDinnerGridTally.GetLength(1));
from = rnd.Next(0, currDinnerGridTally.GetLength(1));
temp1 = currDinnerGridTally[0, to];
temp2 = currDinnerGridTally[1, to];
currDinnerGridTally[0, to] = currDinnerGridTally[0, from];
currDinnerGridTally[1, to] = currDinnerGridTally[1, from];
currDinnerGridTally[0, from] = temp1;
currDinnerGridTally[1, from] = temp2;
}
//sort
do
{
isSorted = true;
for (int i = 0; i < currDinnerGridTally.GetLength(1) - 1; i++)
{
if (currDinnerGridTally[1, i] > currDinnerGridTally[1, i + 1])
{
//swap hosted values
temp1 = currDinnerGridTally[1, i];
currDinnerGridTally[1, i] = currDinnerGridTally[1, i + 1];
currDinnerGridTally[1, i + 1] = temp1;
//swap id
temp1 = currDinnerGridTally[0, i];
currDinnerGridTally[0, i] = currDinnerGridTally[0, i + 1];
currDinnerGridTally[0, i + 1] = temp1;
isSorted = false;
}
}
} while (!isSorted);
//find available spot (indicated by -1) and put new member in
for (int k = 1; k < dinners.GetLength(1); k++)
{
if (dinners[currentDinner, k] == -1)
{
dinners[currentDinner, k] = currDinnerGridTally[0, 0];
break;
}
}
remaining.Remove(currDinnerGridTally[0, 0]);
currentDinner = (currentDinner + 1) % numDinners;
}
//increase matched (grid) count
//loop through dinners
for (int i = 0; i < dinners.GetLength(0); i++)
{
for (int j = 0; j < dinners.GetLength(1); j++)
{
for (int k = 0; k < dinners.GetLength(1); k++)
{
if (!(j == k || dinners[i, j] == -1 || dinners[i, k] == -1))
{
ds.Tables["matchCount"].Rows[dinners[i, j]][dinners[i, k]] = Convert.ToInt16(ds.Tables["matchCount"].Rows[dinners[i, j]][dinners[i, k]]) + 1;
}
}
}
}
history.Add(dinners);
historyDate.Add(date);
if (lsbDinnerSelect.Items[0].ToString().Equals("<empty>"))
lsbDinnerSelect.Items.Clear();
lsbDinnerSelect.Items.Add(date);
UpdateCellColors();
}
protected void borrowButton_Click(object sender, EventArgs e)
{
if (perm == "user")
{
try
{
List <string> columnNames = new List <string>();
List <string> values = new List <string>();
string itemID = String.Empty;
string userID = String.Empty;
string date = String.Empty;
string itemColumns = String.Empty;
string userColumns = String.Empty;
string itemValues = String.Empty;
string userValues = String.Empty;
string addColumns = String.Empty;
DateTime dateNow;
assetsConn.Open();
assetsCmd.Connection = assetsConn;
assetsCmd.CommandText = "SELECT * FROM Assets";
OleDbDataReader dr = assetsCmd.ExecuteReader();
for (int i = 0; i < dr.FieldCount; i++)
{
if (i > 4)
{
itemColumns += dr.GetName(i) + ", ";
}
}
dr.Close();
assetsCmd.CommandText = "SELECT * FROM People";
dr = assetsCmd.ExecuteReader();
for (int i = 0; i < dr.FieldCount; i++)
{
if (i > 1 && i != dr.FieldCount - 1)
{
userColumns += dr.GetName(i) + ", ";
}
if (i > 1 && i == dr.FieldCount - 1)
{
userColumns += dr.GetName(i);
}
}
dr.Close();
itemID = borrowsGrid.SelectedRow.Cells[1].Text;
assetsCmd.CommandText = "SELECT ID FROM People WHERE Nazwa = @userName";
assetsCmd.Parameters.AddWithValue("@userName", HttpContext.Current.User.Identity.Name);
userID = assetsCmd.ExecuteScalar().ToString();
date = System.DateTime.Now.ToString();
System.Globalization.DateTimeFormatInfo dateInfo = new System.Globalization.DateTimeFormatInfo();
dateInfo.FullDateTimePattern = "dd/MM/yyyy HH:mm:ss tt";
dateNow = Convert.ToDateTime(date, dateInfo);
assetsCmd.Parameters.Clear();
itemColumns = itemColumns.Remove(itemColumns.LastIndexOf(','));
assetsCmd.CommandText = "SELECT " + itemColumns + " FROM Assets WHERE ID = " + itemID;
dr = assetsCmd.ExecuteReader();
dr.Read();
for (int i = 0; i < dr.FieldCount; i++)
{
itemValues += "'" + dr.GetString(i) + "'" + ", ";
}
dr.Close();
assetsCmd.CommandText = "SELECT " + userColumns + " FROM People WHERE ID = " + userID;
dr = assetsCmd.ExecuteReader();
dr.Read();
for (int i = 0; i < dr.FieldCount; i++)
{
if (i < dr.FieldCount - 1)
{
userValues += "'" + dr.GetString(i) + "'" + ", ";
}
if (i == dr.FieldCount - 1)
{
userValues += "'" + dr.GetString(i) + "'";
}
}
dr.Close();
itemColumns += ", ";
assetsCmd.CommandText = "SELECT * FROM Assets";
dr = assetsCmd.ExecuteReader();
for (int i = 0; i < dr.FieldCount; i++)
{
if (i > 3)
{
addColumns += dr.GetName(i) + " string" + ", ";
}
}
dr.Close();
assetsCmd.CommandText = "SELECT * FROM People";
dr = assetsCmd.ExecuteReader();
for (int i = 0; i < dr.FieldCount; i++)
{
if (i > 1 && i < dr.FieldCount - 1)
{
addColumns += dr.GetName(i) + " string" + ", ";
}
if (i == dr.FieldCount - 1)
{
addColumns += dr.GetName(i) + " string";
}
}
dr.Close();
if (columnNames.Count == 7)
{
assetsCmd.CommandText = "ALTER TABLE Borrows ADD " + addColumns;
assetsCmd.ExecuteNonQuery();
}
assetsCmd.CommandText = "INSERT INTO Borrows (ID_przedmiotu, ID_użytkownika, Wypożyczony, Data_wypożyczenia, " + itemColumns + userColumns + ") VALUES (@itemID, @userID, 'Tak', @dateNow, " + itemValues + userValues + ")";
assetsCmd.Parameters.AddWithValue("@itemID", itemID);
assetsCmd.Parameters.AddWithValue("@userID", userID);
assetsCmd.Parameters.AddWithValue("@dateNow", dateNow);
assetsCmd.ExecuteNonQuery();
assetsCmd.Parameters.Clear();
assetsCmd.CommandText = "UPDATE Assets SET Wypożyczony = 'Tak' WHERE ID = @itemID";
assetsCmd.Parameters.AddWithValue("@itemID", itemID);
assetsCmd.ExecuteNonQuery();
assetsCmd.Parameters.Clear();
assetsConn.Close();
if (createPDFCheckBox.Checked)
{
assetsConn.Open();
assetsCmd.CommandText = "SELECT * FROM Borrows WHERE ID = (SELECT MAX(ID) FROM Borrows)";
dr = assetsCmd.ExecuteReader();
for (int i = 0; i < dr.FieldCount; i++)
{
columnNames.Add(dr.GetName(i));
}
dr.Read();
for (int i = 0; i < dr.FieldCount; i++)
{
values.Add(dr.GetValue(i).ToString());
}
assetsConn.Close();
var doc = new Document();
PdfWriter.GetInstance(doc, new FileStream(AppDomain.CurrentDomain.BaseDirectory + "PDF\\Wypożyczenia\\" + System.DateTime.Now.ToString("yyyy_MM_dd-HH_mm") + ".pdf", FileMode.Create));
doc.Open();
Font titleFont = FontFactory.GetFont(BaseFont.TIMES_ROMAN, BaseFont.CP1257, 14f, Font.BOLD);
Font dataFont = FontFactory.GetFont(BaseFont.TIMES_ROMAN, BaseFont.CP1257, 12f);
Phrase title = new Phrase("Potwierdzenie wypożyczenia", titleFont);
Paragraph titlePar = new Paragraph(title);
Paragraph dataPar = new Paragraph();
for (int i = 0; i < columnNames.Count; i++)
{
Phrase p = new Phrase(columnNames[i] + ": " + values[i] + "\n", dataFont);
dataPar.Add(p);
}
titlePar.SetAlignment("Center");
doc.Add(titlePar);
doc.Add(dataPar);
doc.Close();
Scripts.OperationLogCreator op1 = new Scripts.OperationLogCreator();
op1.OperationLog("UserID: " + userID + " || Operacja wykonana: wygenerowanie wydruku potwierdzającego wypożyczenie przedmiotu o ID: " + itemID);
}
Scripts.OperationLogCreator op = new Scripts.OperationLogCreator();
op.OperationLog("UserID: " + userID + " || Operacja wykonana: wypożyczenie przedmiotu o ID: " + itemID);
ClearTextBoxes();
}
catch (Exception exc)
{
Scripts.ErrorLogCreator err = new Scripts.ErrorLogCreator();
err.ErrorLog(exc.Message);
errorLabel.Text = "Błąd! " + exc.Message;
}
finally
{
assetsConn.Close();
usersConn.Close();
}
}
}
private int UpdateData()
{
string ApplicationId = ddlApplicationList.SelectedValue;
string PortalName = txtPortalName.Text;
string Currency = ddlCurrencyTypeList.SelectedValue;
string HostFee = txtHostFee.Text;
int HostSpace = Convert.ToInt32(txtHostSpace.Text);
string DefaultLanguage = ddlLanguageList.Text;
string HomeDirectory = txtHomeDirectory.Text;
string Url = txtUrl.Text;
string KeyWords = txtKeyWords.Text;
string FooterText = txtFooterText.Text;
string Description = txtDescription.Text;
string LastModifiedByUserId = Session["UserId"].ToString(); ;
#region UPLOAD ************************************************************************************************************/
string logo_dir_path = HttpContext.Current.Server.MapPath("~/" + System.Configuration.ConfigurationManager.AppSettings["upload_image_dir"] + "/portal_images/logo");
string background_dir_path = HttpContext.Current.Server.MapPath("~/" + System.Configuration.ConfigurationManager.AppSettings["upload_image_dir"] + "/portal_images/backgrounds");
string LogoFile = string.Empty; string BackgroundFile = string.Empty;
FileHandleClass file_handle_obj = new FileHandleClass();
HttpPostedFile _logo_file = InputLogoFile.PostedFile;
if (_logo_file.ContentLength > 0)
{
string logo_file_path = logo_dir_path + "/" + HiddenLogoFile.Value;
if (File.Exists(logo_file_path))
{
File.Delete(logo_file_path);
}
LogoFile = file_handle_obj.uploadInputFile(_logo_file, logo_dir_path);
}
else
{
LogoFile = HiddenLogoFile.Value;
}
HttpPostedFile _background_file = InputBackgroundFile.PostedFile;
if (_background_file.ContentLength > 0)
{
string background_file_path = background_dir_path + "/" + HiddenLogoFile.Value;
if (File.Exists(background_file_path))
{
File.Delete(background_file_path);
}
BackgroundFile = file_handle_obj.uploadInputFile(_background_file, background_dir_path);
}
else
{
BackgroundFile = HiddenBackgroundFile.Value;
}
#endregion ================================================================================
#region xu ly thoi gian =====================================================================================
System.Globalization.DateTimeFormatInfo MyDateTimeFormatInfo = new System.Globalization.DateTimeFormatInfo();
MyDateTimeFormatInfo.ShortDatePattern = "dd/MM/yyyy";
string ExpiryDate = null;
if (txtExpiryDate.Text != string.Empty)
{
DateTime _ExpiryDate = DateTime.Parse(txtExpiryDate.Text, MyDateTimeFormatInfo);
ExpiryDate = _ExpiryDate.ToString("yyyy-MM-dd");
}
#endregion ====================================================================================================
PortalController portal_obj = new PortalController();
int i = portal_obj.Update(_idx, ApplicationId, PortalName, ExpiryDate, Currency, HostFee, HostSpace, DefaultLanguage,
HomeDirectory, Url, LogoFile, BackgroundFile, KeyWords, FooterText, Description, LastModifiedByUserId);
return i;
}
public DateType(System.Globalization.DateTimeFormatInfo dateFormat, TypeCodec dateCodec)
: base("date")
{
dateFormatter = dateFormat;
this.dateCodec = dateCodec;
}
/// <summary>
/// ������� �������� ��� ������������� � �������. ���������������� ��������� ������������
/// </summary>
private void CreateCulture()
{
try
{
System.Globalization.DateTimeFormatInfo dt = new System.Globalization.DateTimeFormatInfo();
dt.ShortDatePattern = "dd.MM.yyyy";
dt.LongDatePattern = "dd.MM.yyyy";
dt.ShortTimePattern = "HH:mm";
dt.LongTimePattern = "HH:mm:ss";
System.Globalization.CultureInfo newCulture = new System.Globalization.CultureInfo(System.Globalization.CultureInfo.CurrentCulture.Name);
newCulture.NumberFormat.NumberDecimalSeparator = ",";
newCulture.NumberFormat.CurrencyDecimalSeparator = ",";
newCulture.NumberFormat.PercentDecimalSeparator = ",";
newCulture.NumberFormat.NumberGroupSeparator = " ";
newCulture.DateTimeFormat = dt;
System.Threading.Thread.CurrentThread.CurrentCulture = newCulture;
}
catch
{
}
}
private int[] AddData()
{
int[] result = new int[2];
if (Session["UserId"] != null && Session["UserId"].ToString() != string.Empty)
{
int PortalId = Convert.ToInt32(ddlPortalList.SelectedValue);
int ContentItemId = int.Parse(ddlContentItem.SelectedValue);
int RouteId = int.Parse(ddlRouterList.SelectedValue);
string TabName = txt_TabName.Text;
string Title = txt_Title.Text;
int ParentId = int.Parse(ddlParentTab.SelectedValue);
string Description = txt_Desc.Text;
string Keywords = txt_Keywords.Text;
string Url = txt_Url.Text;
string TabPath = txt_Path.Text;
decimal SiteMapPriority = Convert.ToDecimal(txtSiteMapPriority.Text)/10;
string PageHeadText = txt_PageHeadText.Text;
string PageFooterText = txt_PageFooterText.Text;
string CssClass = txt_CssClass.Text;
string CultureCode = ddlCultureCode.SelectedValue;
// string StartDate=txt_StartDate.Text;
// string EndDate= txt_EndDate.Text;
#region xu ly thoi gian ====================================================================================
System.Globalization.DateTimeFormatInfo MyDateTimeFormatInfo = new System.Globalization.DateTimeFormatInfo();
MyDateTimeFormatInfo.ShortDatePattern = "dd/MM/yyyy";
string StartDate = null, EndDate = null;
if (txt_StartDate.Text != string.Empty && txt_StartDate.Text != "__/__/____")
{
DateTime _start_date = DateTime.Parse(txt_StartDate.Text, MyDateTimeFormatInfo);
StartDate = _start_date.ToString("yyyy-MM-dd");
}
if (txt_EndDate.Text != string.Empty && txt_EndDate.Text != "__/__/____")
{
DateTime _end_date = DateTime.Parse(txt_EndDate.Text, MyDateTimeFormatInfo);
EndDate = _end_date.ToString("yyyy-MM-dd");
}
if (txt_StartDate.Text != string.Empty && txt_StartDate.Text != "__/__/____"
&& txt_EndDate.Text != string.Empty && txt_EndDate.Text != "__/__/____")
{
DateTime _start_date = DateTime.Parse(txt_StartDate.Text, MyDateTimeFormatInfo);
DateTime _end_date = DateTime.Parse(txt_EndDate.Text, MyDateTimeFormatInfo);
if (DateTime.Compare(_start_date, _end_date) > 0)
{
string scriptCode = "<script>alert('Thời điểm bắt đầu phải nhỏ hơn thời điểm kết thúc');</script>";
Page.ClientScript.RegisterClientScriptBlock(this.GetType(), "scriptName", scriptCode);
}
}
#endregion ================================================================================================
/*** UPLOAD *************************************************************************************************************/
HttpPostedFile icon_file = FileIconInput.PostedFile;
HttpPostedFile icon_large_file = FileIconLargeInput.PostedFile;
string IconFileName = "", IconFileLargeName = "", IconFilePath = string.Empty, IconFileLargePath = string.Empty;
if (icon_file.ContentLength > 0)
{
ModuleClass module_obj = new ModuleClass();
IconFileName = module_obj.GetEncodeString(System.IO.Path.GetFileName(icon_file.FileName));
IconFilePath = Server.MapPath(small_icon_path + "/" + IconFileName);
icon_file.SaveAs(IconFilePath);
}
if (icon_large_file.ContentLength > 0)
{
IconFileLargeName = System.IO.Path.GetFileName(icon_large_file.FileName);
IconFileLargePath = Server.MapPath(large_icon_path + "/" + IconFileLargeName);
icon_file.SaveAs(IconFileLargePath);
}
/************************************************************************************************************************/
bool IsDeleted = true, IsVisible = true, DisableLink = false, DisplayTitle = false, IsSecure = false, PermanentRedirect = false;
IsDeleted = chkIsDelete.Checked;
IsVisible = chkIsVisible.Checked;
DisableLink = chkDisableLink.Checked;
DisplayTitle = chkDisplayTitle.Checked;
IsSecure = chkIsSecure.Checked;
PermanentRedirect = chkPermanentRedirect.Checked;
result = tab_obj.Insert(PortalId, ContentItemId, ParentId, TabName, Title, CssClass,
IconFileName, IconFileLargeName, Description, Keywords, DisplayTitle, IsDeleted, IsVisible,
DisableLink, IsSecure, PermanentRedirect, SiteMapPriority, Url, TabPath, RouteId, PageHeadText, PageFooterText, "", StartDate, EndDate, CultureCode, UserId);
}
return result;
}
protected void Page_Load(object sender, EventArgs e)
{
string selectedServer = "";
string date;
/*
* if (this.ServerListFilterComboBox.SelectedIndex >= 0)
* {
* selectedServer = this.ServerListFilterComboBox.SelectedItem.Value.ToString();
* }
*/
if (this.ServerListFilterListBox.SelectedItems.Count > 0)
{
selectedServer = "";
for (int i = 0; i < this.ServerListFilterListBox.SelectedItems.Count; i++)
{
selectedServer += "'" + this.ServerListFilterListBox.SelectedItems[i].Text + "'" + ",";
}
try
{
selectedServer = selectedServer.Substring(0, selectedServer.Length - 1);
}
catch
{
selectedServer = ""; // throw ex;
}
finally { }
}
//10/23/2013 NS modified - added jQuery month/year control
/*
* if (this.DateParamEdit.Text == "")
* {
* date = DateTime.Now.ToString();
* this.DateParamEdit.Date = Convert.ToDateTime(date);
* }
* else
* {
* date = this.DateParamEdit.Value.ToString();
* }
*/
if (startDate.Value.ToString() == "")
{
date = DateTime.Now.ToString();
}
else
{
date = startDate.Value.ToString();
}
DateTime dt = Convert.ToDateTime(date);
DashboardReports.DominoResponseTimesMonthlyXtraRpt report = new DashboardReports.DominoResponseTimesMonthlyXtraRpt();
report.Parameters["DateM"].Value = dt.Month;
report.Parameters["DateY"].Value = dt.Year;
System.Globalization.DateTimeFormatInfo mfi = new System.Globalization.DateTimeFormatInfo();
string strMonthName = mfi.GetMonthName(dt.Month).ToString() + ", " + dt.Year.ToString();
report.Parameters["MonthYear"].Value = strMonthName;
report.Parameters["ServerName"].Value = selectedServer;
this.ReportViewer1.Report = report;
this.ReportViewer1.DataBind();
if (!IsPostBack)
{
fillcombo();
}
}
private int UpdateData()
{
string ApplicationId = ddlApplicationList.SelectedValue;
string PortalName = txtPortalName.Text;
string Currency = ddlCurrencyTypeList.SelectedValue;
string HostFee = txtHostFee.Text;
int HostSpace = Convert.ToInt32(txtHostSpace.Text);
string DefaultLanguage = ddlLanguageList.Text;
string HomeDirectory = txtHomeDirectory.Text;
string Url = txtUrl.Text;
string KeyWords = txtKeyWords.Text;
string FooterText = txtFooterText.Text;
string Description = txtDescription.Text;
string LastModifiedByUserId = Session["UserId"].ToString();;
#region UPLOAD ************************************************************************************************************/
string logo_dir_path = HttpContext.Current.Server.MapPath("~/" + System.Configuration.ConfigurationManager.AppSettings["upload_image_dir"] + "/portal_images/logo");
string background_dir_path = HttpContext.Current.Server.MapPath("~/" + System.Configuration.ConfigurationManager.AppSettings["upload_image_dir"] + "/portal_images/backgrounds");
string LogoFile = string.Empty; string BackgroundFile = string.Empty;
FileHandleClass file_handle_obj = new FileHandleClass();
HttpPostedFile _logo_file = InputLogoFile.PostedFile;
if (_logo_file.ContentLength > 0)
{
string logo_file_path = logo_dir_path + "/" + HiddenLogoFile.Value;
if (File.Exists(logo_file_path))
{
File.Delete(logo_file_path);
}
LogoFile = file_handle_obj.uploadInputFile(_logo_file, logo_dir_path);
}
else
{
LogoFile = HiddenLogoFile.Value;
}
HttpPostedFile _background_file = InputBackgroundFile.PostedFile;
if (_background_file.ContentLength > 0)
{
string background_file_path = background_dir_path + "/" + HiddenLogoFile.Value;
if (File.Exists(background_file_path))
{
File.Delete(background_file_path);
}
BackgroundFile = file_handle_obj.uploadInputFile(_background_file, background_dir_path);
}
else
{
BackgroundFile = HiddenBackgroundFile.Value;
}
#endregion ================================================================================
#region xu ly thoi gian =====================================================================================
System.Globalization.DateTimeFormatInfo MyDateTimeFormatInfo = new System.Globalization.DateTimeFormatInfo();
MyDateTimeFormatInfo.ShortDatePattern = "dd/MM/yyyy";
string ExpiryDate = null;
if (txtExpiryDate.Text != string.Empty)
{
DateTime _ExpiryDate = DateTime.Parse(txtExpiryDate.Text, MyDateTimeFormatInfo);
ExpiryDate = _ExpiryDate.ToString("yyyy-MM-dd");
}
#endregion ====================================================================================================
PortalController portal_obj = new PortalController();
int i = portal_obj.Update(_idx, ApplicationId, PortalName, ExpiryDate, Currency, HostFee, HostSpace, DefaultLanguage,
HomeDirectory, Url, LogoFile, BackgroundFile, KeyWords, FooterText, Description, LastModifiedByUserId);
return(i);
}
public static System.Globalization.DateTimeFormatInfo ReadOnly(System.Globalization.DateTimeFormatInfo dtfi)
{
Contract.Ensures(Contract.Result <System.Globalization.DateTimeFormatInfo>() != null);
return(default(System.Globalization.DateTimeFormatInfo));
}
protected void Page_Load(object sender, System.EventArgs e)
{
#region Properties For The Base Class and Check Login
LoginID = Request.QueryString["LoginID"];
LoginInfo = CCLib.Login.GetLoginInfo(LoginID);
Redirect();
PageTitle = TextCode(79);
Section = "schools";
CSS = "schools";
UsesjQuery = true;
LeftBar = "<TABLE WIDTH='100%' BORDER='0' CELLSPACING='0' CELLPADDING='0'><TR VALIGN='TOP' BGCOLOR='#996699'><TD BACKGROUND='/media/schools/i_c_prpl_bar_bg.gif'><IMG SRC='/media/schools/i_s_schools_icon.gif' WIDTH='24' HEIGHT='23' BORDER='0' alt=''><IMG SRC='/media1/USSchools/h_schools" + SuffixCode() + ".gif' WIDTH='141' HEIGHT='23' ALIGN='TOP' alt=''>";
#endregion Properties For The Base Class and Check Login
strSSBackLink = Request.QueryString["SSBackLink"];
strSSBackLink = (strSSBackLink == null) ? "" : strSSBackLink;
if (strSSBackLink != "")
{
strSSBackLinkHTML = "<DIV ALIGN=\"LEFT\"><TABLE BORDER=\"0\" CELLPADDING=\"0\" cellspacing=\"0\" BGCOLOR=\"#555555\" WIDTH=\"228\" HEIGHT=\"21\">"
+ "<TR><TD ALIGN=\"LEFT\" VALIGN=\"TOP\">"
+ "<table WIDTH=\"227\" border=\"0\" cellspacing=\"0\" cellpadding=\"4\" HEIGHT=\"20\">"
+ "<tr VALIGN=\"MIDDLE\">"
+ "<td bgcolor=\"#999999\"><a href=\"" + strSSBackLink + "SchoolSelector.aspx?LoginID=" + LoginID + "&SSBackLink=" + strSSBackLink + "\" class=\"SSBackLink\"><img src=\"/media/shared/arrow.gif\" width=\"19\" height=\"12\" border=\"0\" ALIGN=\"LEFT\" alt=''><font size=\"1\" face=\"Verdana, Arial, Helvetica, sans-serif\" COLOR=\"#FFFFFF\">"
+ "<b>Back to School Selector Results</b></font></a></td>"
+ "</tr>"
+ "</table>"
+ "</TD></TR></TABLE></DIV>";
strSSBackSelfLink = "&SSBackLink=" + strSSBackLink;
}
string action = CareerCruisingWeb.CCLib.Common.Strings.GetQueryString("Action");
i1 = 0;
i2 = 0;
i3 = 0;
i4 = 0;
iTemp = 0;
iIndex = 0; iRowCount = 0;
bExpense = false;
bTuition = false;
bFee = false;
bBook = false;
bBoard = false;
bBach = false; bbBach = false;
bAssoc = false; bbAssoc = false;
bNon = false; bbNon = false;
bVT = false;
bInterSports = false; bIntraSports = false; bSportScholarships = false;
bShow1 = false; bShow2 = false; bShow3 = false; bShow4 = false; bShow5 = false; bShow6 = false; bShow7 = false; bShow8 = false;
INUN_ID = Request["INUN_ID"];
dtf = new System.Globalization.DateTimeFormatInfo();
dataTable1 = new DataTable();
dataTable1 = CCLib.Cache.GetCachedDataTable("UGSchoolProfile_All_" + INUN_ID, "UGSP_SelectAllByID " + INUN_ID);
dtGRExpense = CCLib.Cache.GetCachedDataTable("GRSchoolExpense_" + INUN_ID, "select TUIT_AREA_FT_D,TUIT_NRES_FT_D,TUIT_INTL_FT_D,TUIT_STATE_FT_D,TUIT_OVERALL_FT_D,TUIT_VARY_PROG,TUIT_VARY_LOC,TUIT_VARY_TIME,TUIT_VARY_LOAD,TUIT_VARY_COURSE_LVL,TUIT_VARY_DEG,TUIT_VARY_RECIPROCITY,TUIT_VARY_STUD,TUIT_VARY_RELIGION,RM_BD_VARY_BD,RM_BD_VARY_LOC,RM_BD_VARY_HOUS,FEES_FT_D,RM_BD_D from GX_INST_View where INUN_ID = " + INUN_ID);
dtStudentServices = CCLib.Cache.GetCachedDataTable("GRSchoolStudentServices_" + INUN_ID, "select * from GR_STUDENT_SERVICES_View where INUN_ID = " + INUN_ID);
//DataTable dtLatLong = CCLib.Common.DataAccess.GetDataTable("Select latString, longString from zz_SchoolLoc where SchoolID='" + INUN_ID + "'");
//strLat = dtLatLong.Rows[0][0].ToString();
//strLong = dtLatLong.Rows[0][1].ToString();
//string strLocationText = (dataTable1.Rows[0]["NAME"].ToString() + "+" + dataTable1.Rows[0]["LINE1"] + ",+" + dataTable1.Rows[0]["CITY"] + "+" + dataTable1.Rows[0]["STATE_CODE"] + "+" + dataTable1.Rows[0]["ZIPCODE"]).Replace(" ", "+");
//strLocationText = (dataTable1.Rows[0]["LINE1"] + ",+" + dataTable1.Rows[0]["CITY"] + "+" + dataTable1.Rows[0]["STATE_CODE"] + "+" + dataTable1.Rows[0]["ZIPCODE"]).Replace(" ", "+");
strSessionCookieValue = Request.Cookies["ASP.NET_SessionId"].Value;
if (action == "CompareSchool")
{
string commandText = "Select INUN_ID FROM ux_vx_inst_view WHERE INUN_ID= " + INUN_ID;
DataTable table = CareerCruisingWeb.CCLib.Cache.GetCachedDataTable("USSchoolProfile_INUN_IDs_" + INUN_ID, commandText);//Should Use Cache. Don Xiong 02/03/2010
}
if ((dataTable1.Rows[0]["TUIT_AREA_FT_D"].ToString() != "") || (dataTable1.Rows[0]["TUIT_NRES_FT_D"].ToString() != "") || (dataTable1.Rows[0]["TUIT_INTL_FT_D"].ToString() != "") || (dataTable1.Rows[0]["TUIT_STATE_FT_D"].ToString() != "") || (dataTable1.Rows[0]["TUIT_OVERALL_FT_D"].ToString() != ""))
bTuition = true;
if (dataTable1.Rows[0]["FEES_FT_D"].ToString() != "")
bFee = true;
if (dataTable1.Rows[0]["BOOKS_RES_D"].ToString() != "")
bBook = true;
if (dataTable1.Rows[0]["RM_BD_D"].ToString() != "")
bBoard = true;
if (dataTable1.Rows[0]["FRSH_FT_AP_N"].ToString() != "" || dataTable1.Rows[0]["UG_FT_AP_N"].ToString() != "" || dataTable1.Rows[0]["FRSH_FT_ND_N"].ToString() != "" || dataTable1.Rows[0]["UG_FT_ND_N"].ToString() != "" ||
dataTable1.Rows[0]["FRSH_FT_ND_MET_N"].ToString() != "" || dataTable1.Rows[0]["UG_FT_ND_MET_N"].ToString() != "" || dataTable1.Rows[0]["FRSH_FT_ND_MET_P"].ToString() != "" || dataTable1.Rows[0]["UG_FT_ND_MET_P"].ToString() != "" ||
dataTable1.Rows[0]["FRSH_FT_AVG_PKG_D"].ToString() != "" || dataTable1.Rows[0]["UG_FT_AVG_PKG_D"].ToString() != "" || dataTable1.Rows[0]["FRESH_FT_AVG_NB_LOAN_D"].ToString() != "" || dataTable1.Rows[0]["UG_FT_AVG_NB_LOAN_D"].ToString() != "" ||
dataTable1.Rows[0]["FRSH_FT_AVG_NB_GIFT_D"].ToString() != "" || dataTable1.Rows[0]["UG_FT_AVG_NB_GIFT_D"].ToString() != "" || dataTable1.Rows[0]["FRESH_FT_NN_NONEED_D"].ToString() != "" || dataTable1.Rows[0]["UG_FT_NN_NONEED_D"].ToString() != "")
bFinancialAid = true;
if ((dataTable1.Rows[0]["SCHOL_NB_PELL"].ToString() != "")
|| (dataTable1.Rows[0]["LOAN_PERKINS"].ToString() != "")
|| (dataTable1.Rows[0]["LOAN_DIRECT_STAFFORD_SUB"].ToString() != "")
|| (dataTable1.Rows[0]["LOAN_DIRECT_STAFFORD_UNSUB"].ToString() != "")
|| (dataTable1.Rows[0]["LOAN_DIRECT_PLUS"].ToString() != "")
|| (dataTable1.Rows[0]["LOAN_FFEL_STAFFORD_SUB"].ToString() != "")
|| (dataTable1.Rows[0]["LOAN_FFEL_STAFFORD_UNSUB"].ToString() != "")
|| (dataTable1.Rows[0]["LOAN_FFEL_PLUS"].ToString() != "")
|| (dataTable1.Rows[0]["SCHOL_NB_SEOG"].ToString() == "X")
|| (dataTable1.Rows[0]["LOAN_STATE"].ToString() == "X")
|| (dataTable1.Rows[0]["SCHOL_NB_STATE"].ToString() == "X")
|| (dataTable1.Rows[0]["LOAN_INST"].ToString() == "X")
|| (dataTable1.Rows[0]["SCHOL_NB_INST"].ToString() == "X")
|| (dataTable1.Rows[0]["SCHOL_NB_PRIVATE"].ToString() == "X")
|| (dataTable1.Rows[0]["SCHOL_NB_UNCF"].ToString() == "X"))
bFinancialAidType = true;
dtAppReq = new DataTable();
dtAppReq = CCLib.Cache.GetCachedDataTable("UGSchoolProfile_AppReq_" + INUN_ID, "UGSP_SelectApplReq " + INUN_ID);
dtEntrExam = new DataTable();
dtEntrExam = CCLib.Cache.GetCachedDataTable("UGSchoolProfile_EntrExam_" + INUN_ID, "UGSP_SelectEntrExam " + INUN_ID);
dtPlaceExam = new DataTable();
dtPlaceExam = CCLib.Cache.GetCachedDataTable("UGSchoolProfile_PlaceExam_" + INUN_ID, "UGSP_SelectPlaceExam " + INUN_ID);
dtSport = new DataTable();
dtSport = CCLib.Cache.GetCachedDataTable("UGSchoolProfile_Sports_" + INUN_ID, "UGSP_SelectSports " + INUN_ID);
strTemp = "";
dt1 = new DataTable();
//dt1 = CareerCruisingWeb.CCLib.Common.DataAccess.GetDataTable("GRSP_SelectAllMajor " + INUN_ID);
//Should Use Cache, Please do not comment out the line below, it was in the worst query list. Don Xiong 02/03/2010
dt1 = CCLib.Cache.GetCachedDataTable("GRSchoolProfile_MajorResults_" + INUN_ID, "GRSP_SelectAllMajor " + INUN_ID);
//dvMajor=new DataView(dt1);//
dvArea = new DataView(dt1);
dvArea.Sort = "[1stLevel" + NonEngSuffixCode("US") + "]";
string strArea = Request["area"];
string strType = Request["type"];
DataView view;
if ((strArea != null) && (strArea != ""))
{
strTempFilter = strTempFilter + "[1stCode]='" + strArea + "' and ";
dvMajor = new DataView(dt1);
view = new DataView(dt1);
}
else//recreate new datatable to get rid of redundant rows
{
dt2 = dt1.Clone();
for (int i = 0; i < dt1.Rows.Count; i++)
{
if (i == 0 || (dt1.Rows[i]["DESCR"].ToString() != dt1.Rows[i - 1]["DESCR"].ToString()) || (dt1.Rows[i]["DESCR"].ToString() == dt1.Rows[i - 1]["DESCR"].ToString() && (dt1.Rows[i]["Non"].ToString() != dt1.Rows[i - 1]["Non"].ToString() || dt1.Rows[i]["BACH"].ToString() != dt1.Rows[i - 1]["BACH"].ToString() || dt1.Rows[i]["GRAD"].ToString() != dt1.Rows[i - 1]["GRAD"].ToString())))//just insert for the first one or if no duplicate
dt2.ImportRow(dt1.Rows[i]);
}
dvMajor = new DataView(dt2);
view = new DataView(dt2);
}
if ((strType != null) && (strType != ""))
{
if (strType == "A")
strTempFilter = strTempFilter + "ASSOC='X' and ";
if (strType == "B")
strTempFilter = strTempFilter + "BACH='X' and ";
if (strType == "N")
strTempFilter = strTempFilter + "Non='X' and ";
if (strType == "G")
strTempFilter = strTempFilter + "GRAD='X' and ";
}
if (strTempFilter.Length > 0) dvMajor.RowFilter = strTempFilter.Substring(0, strTempFilter.Length - 4);
else dvMajor.RowFilter = "[1stCode] is not null";
iRowCount = (int)CCLib.Cache.GetCachedValue("UGSchoolProfile_IsCTSchool_" + INUN_ID, "select count(INUN_ID) from VX_INST where INUN_ID=" + INUN_ID);
bVT = (iRowCount > 0) ? true : false;
view.RowFilter = "[1stCode] is not null";
foreach (DataRowView myRow in view)
{
if ((myRow["ASSOC"].ToString() == "X") && (!bAssoc))
bAssoc = true;
if ((myRow["BACH"].ToString() == "X") && (!bBach))
bBach = true;
if ((myRow["Non"].ToString() == "X") && (!bNon))
bNon = true;
if ((myRow["GRAD"].ToString() == "X") && (!bGRAD))
bGRAD = true;
}
foreach (DataRowView myRow in dvArea)
{
if ((myRow["ASSOC"].ToString() == "X") && (!bbAssoc))
bbAssoc = true;
if ((myRow["BACH"].ToString() == "X") && (!bbBach))
bbBach = true;
if ((myRow["Non"].ToString() == "X") && (!bbNon))
bbNon = true;
if ((myRow["GRAD"].ToString() == "X") && (!bbGRAD))
bbGRAD = true;
}
foreach (DataRow myRow in dtSport.Rows)
{
if ((myRow["SCHOL_MEN"].ToString() != "") || (myRow["SCHOL_WMN"].ToString() != ""))
{
bSportScholarships = true;
break;
}
}
foreach (DataRow myRow in dtSport.Rows)
{
if ((myRow["INTC_MEN"].ToString() != "") || (myRow["INTC_WMN"].ToString() != ""))
{
bInterSports = true;
break;
}
}
foreach (DataRow myRow in dtSport.Rows)
{
if ((myRow["INTM_MEN"].ToString() != "") || (myRow["INTM_WMN"].ToString() != ""))
{
bIntraSports = true;
break;
}
}
if (CCLib.Common.Strings.StringBiggerInteger(dataTable1.Rows[0]["SAT1_VERB_200_P"].ToString(), 50)
|| CCLib.Common.Strings.StringBiggerInteger(dataTable1.Rows[0]["SAT1_VERB_300_P"].ToString(), 50)
|| CCLib.Common.Strings.StringBiggerInteger(dataTable1.Rows[0]["SAT1_VERB_400_P"].ToString(), 50)
|| CCLib.Common.Strings.StringBiggerInteger(dataTable1.Rows[0]["SAT1_VERB_500_P"].ToString(), 50)
|| CCLib.Common.Strings.StringBiggerInteger(dataTable1.Rows[0]["SAT1_VERB_600_P"].ToString(), 50)
|| CCLib.Common.Strings.StringBiggerInteger(dataTable1.Rows[0]["SAT1_VERB_700_P"].ToString(), 50))
strSATVerbal = "<td valign=bottom><img src=../media/shared/ugsp_sat_chart_left2.gif width=72 height=340 alt='Chart: 0%, 10%, 20%, 30%, 40%, 50%, 60%, 70%, 80%, 90%, 100%'></td>";
else
strSATVerbal = "<td><img src=../media/shared/ugsp_sat_chart_left.gif width=72 height=220 alt='Chart: 0%, 10%, 20%, 30%, 40%, 50%, 60%'></td>";
if (CCLib.Common.Strings.StringBiggerInteger(dataTable1.Rows[0]["SAT1_MATH_200_P"].ToString(), 50)
|| CCLib.Common.Strings.StringBiggerInteger(dataTable1.Rows[0]["SAT1_MATH_300_P"].ToString(), 50)
|| CCLib.Common.Strings.StringBiggerInteger(dataTable1.Rows[0]["SAT1_MATH_400_P"].ToString(), 50)
|| CCLib.Common.Strings.StringBiggerInteger(dataTable1.Rows[0]["SAT1_MATH_500_P"].ToString(), 50)
|| CCLib.Common.Strings.StringBiggerInteger(dataTable1.Rows[0]["SAT1_MATH_600_P"].ToString(), 50)
|| CCLib.Common.Strings.StringBiggerInteger(dataTable1.Rows[0]["SAT1_MATH_700_P"].ToString(), 50))
strSATMath = "<td valign=bottom><img src=../media/shared/ugsp_sat_chart_left2.gif width=72 height=340 alt='Chart: 0%, 10%, 20%, 30%, 40%, 50%, 60%, 70%, 80%, 90%, 100%'></td>";
else
strSATMath = "<td><img src=../media/shared/ugsp_sat_chart_left.gif width=72 height=220 alt='Chart: 0%, 10%, 20%, 30%, 40%, 50%, 60%'></td>";
if (CCLib.Common.Strings.StringBiggerInteger(dataTable1.Rows[0]["SAT1_Writing_200_P"].ToString(), 50)
|| CCLib.Common.Strings.StringBiggerInteger(dataTable1.Rows[0]["SAT1_Writing_300_P"].ToString(), 50)
|| CCLib.Common.Strings.StringBiggerInteger(dataTable1.Rows[0]["SAT1_Writing_400_P"].ToString(), 50)
|| CCLib.Common.Strings.StringBiggerInteger(dataTable1.Rows[0]["SAT1_Writing_500_P"].ToString(), 50)
|| CCLib.Common.Strings.StringBiggerInteger(dataTable1.Rows[0]["SAT1_Writing_600_P"].ToString(), 50)
|| CCLib.Common.Strings.StringBiggerInteger(dataTable1.Rows[0]["SAT1_Writing_700_P"].ToString(), 50))
strSATWriting = "<td valign=bottom><img src=../media/shared/ugsp_sat_chart_left2.gif width=72 height=340 alt='Chart: 0%, 10%, 20%, 30%, 40%, 50%, 60%, 70%, 80%, 90%, 100%'></td>";
else
strSATWriting = "<td><img src=../media/shared/ugsp_sat_chart_left.gif width=72 height=220 alt='Chart: 0%, 10%, 20%, 30%, 40%, 50%, 60%'></td>";
if (CCLib.Common.Strings.StringBiggerInteger(dataTable1.Rows[0]["ACT_1_P"].ToString(), 50)
|| CCLib.Common.Strings.StringBiggerInteger(dataTable1.Rows[0]["ACT_2_P"].ToString(), 50)
|| CCLib.Common.Strings.StringBiggerInteger(dataTable1.Rows[0]["ACT_3_P"].ToString(), 50)
|| CCLib.Common.Strings.StringBiggerInteger(dataTable1.Rows[0]["ACT_4_P"].ToString(), 50)
|| CCLib.Common.Strings.StringBiggerInteger(dataTable1.Rows[0]["ACT_5_P"].ToString(), 50)
|| CCLib.Common.Strings.StringBiggerInteger(dataTable1.Rows[0]["ACT_6_P"].ToString(), 50))
strACT = "<td valign=bottom><img src=../media/shared/ugsp_sat_chart_left2.gif width=72 height=340 alt='Chart: 0%, 10%, 20%, 30%, 40%, 50%, 60%, 70%, 80%, 90%, 100%'></td>";
else
strACT = "<td><img src=../media/shared/ugsp_sat_chart_left.gif width=72 height=220 alt='Chart: 0%, 10%, 20%, 30%, 40%, 50%, 60%'></td>";
if ((dataTable1.Rows[0]["instate_area_code"].ToString() != "") || (dataTable1.Rows[0]["outstate_area_code"].ToString() != "")
|| (dataTable1.Rows[0]["fax_area_code"].ToString() != "")
|| (dataTable1.Rows[0]["ap_recd_1st_n"].ToString() != "") || (dataTable1.Rows[0]["ap_admt_1st_n"].ToString() != "")
|| (dataTable1.Rows[0]["ad_open"].ToString() != "") || (dataTable1.Rows[0]["ad_open_T"].ToString() != "") || (dataTable1.Rows[0]["ad_pref"].ToString() != "") || (dataTable1.Rows[0]["ad_pref_t"].ToString() != "")
|| (dataTable1.Rows[0]["ad_open"].ToString() != "") || (dataTable1.Rows[0]["ad_open_T"].ToString() != "") || (dataTable1.Rows[0]["ad_pref"].ToString() != "") || (dataTable1.Rows[0]["ad_pref_t"].ToString() != "")
|| (dtAppReq.Rows.Count != 0) || (dtEntrExam.Rows.Count != 0) || (dtPlaceExam.Rows.Count != 0)
|| (dataTable1.Rows[0]["AP_electronic"].ToString() != "")
)
bShow2 = true;
if ((dataTable1.Rows[0]["TUIT_AREA_FT_D"].ToString() != "")
|| (dataTable1.Rows[0]["TUIT_NRES_FT_D"].ToString() != "")
|| (dataTable1.Rows[0]["TUIT_INTL_FT_D"].ToString() != "")
|| (dataTable1.Rows[0]["TUIT_STATE_FT_D"].ToString() != "")
|| (dataTable1.Rows[0]["TUIT_OVERALL_FT_D"].ToString() != "")
|| (dataTable1.Rows[0]["TUIT_VARY_PROG"].ToString() != "")
|| (dataTable1.Rows[0]["TUIT_VARY_LOC"].ToString() != "")
|| (dataTable1.Rows[0]["TUIT_VARY_TIME"].ToString() != "")
|| (dataTable1.Rows[0]["TUIT_VARY_LOAD"].ToString() != "")
|| (dataTable1.Rows[0]["TUIT_VARY_COURSE_LVL"].ToString() != "")
|| (dataTable1.Rows[0]["TUIT_VARY_DEG"].ToString() != "")
|| (dataTable1.Rows[0]["TUIT_VARY_RECIPROCITY"].ToString() != "")
|| (dataTable1.Rows[0]["TUIT_VARY_STUD"].ToString() != "")
|| (dataTable1.Rows[0]["RM_BD_VARY_BD"].ToString() == "X")
|| (dataTable1.Rows[0]["RM_BD_VARY_LOC"].ToString() == "X")
|| (dataTable1.Rows[0]["RM_BD_VARY_GENDER"].ToString() == "X")
|| (dataTable1.Rows[0]["RM_BD_VARY_HOUS"].ToString() == "X")
|| (dataTable1.Rows[0]["TUIT_PLAN_GUAR"].ToString() == "Y")
|| (dataTable1.Rows[0]["TUIT_PLAN_PREPAY"].ToString() == "Y")
|| (dataTable1.Rows[0]["TUIT_PLAN_INSTALL"].ToString() == "X")
|| (dataTable1.Rows[0]["TUIT_PLAN_DEFER"].ToString() == "X"))
bShow4 = true;
if ((dataTable1.Rows[0]["certif"].ToString() == "X")
|| (dataTable1.Rows[0]["diploma"].ToString() == "X")
|| (dataTable1.Rows[0]["deg_assoc_tfer"].ToString() == "X")
|| (dataTable1.Rows[0]["deg_assoc_term"].ToString() == "X")
|| (dataTable1.Rows[0]["deg_bach"].ToString() != "")
|| (dataTable1.Rows[0]["certif_fp"].ToString() == "X")
|| (dataTable1.Rows[0]["deg_fp"].ToString() == "X")
|| (dataTable1.Rows[0]["deg_master"].ToString() != "")
|| (dataTable1.Rows[0]["certif_post_master"].ToString() == "X")
|| (dataTable1.Rows[0]["deg_Doctor"].ToString() != "")
|| (dataTable1.Rows[0]["award_t"].ToString() != "")
|| (dataTable1.Rows[0]["assoc_t"].ToString() != "") || (dataTable1.Rows[0]["bach_t"].ToString() != "")
|| (dataTable1.Rows[0]["acad_core"].ToString() == "Y") || (dataTable1.Rows[0]["LANG"].ToString() == "Y")
|| (dataTable1.Rows[0]["MATH_SCI"].ToString() == "Y") || (dataTable1.Rows[0]["CMPTR"].ToString() == "Y")
|| (dataTable1.Rows[0]["INTERN_ALL"].ToString() == "Y") || (dataTable1.Rows[0]["INTERN_SOME"].ToString() == "Y")
|| (dataTable1.Rows[0]["SR_PROJ_ALL"].ToString() == "Y") || (dataTable1.Rows[0]["SR_PROJ_SOME_MAJ"].ToString() == "Y")
|| (dataTable1.Rows[0]["SR_PROJ_SOME_HON"].ToString() == "Y"))
bShow3 = true;
if ((dataTable1.Rows[0]["EN_TOT_UG_N"].ToString() != "")
|| (dataTable1.Rows[0]["EN_GRAD_FT_MEN_N"].ToString() != "")
|| (dataTable1.Rows[0]["EN_GRAD_FT_WMN_N"].ToString() != "")
|| (dataTable1.Rows[0]["EN_GRAD_PT_MEN"].ToString() != "")
|| (dataTable1.Rows[0]["EN_GRAD_FT_WMN_N"].ToString() != "")
|| (dataTable1.Rows[0]["EN_TOT_FT_MEN_N"].ToString() != "")
|| (dataTable1.Rows[0]["EN_TOT_FT_WMN_N"].ToString() != "")
|| (dataTable1.Rows[0]["EN_TOT_PT_MEN_N"].ToString() != "")
|| (dataTable1.Rows[0]["EN_TOT_PT_WMN_N"].ToString() != "")
|| (dataTable1.Rows[0]["FRSH_HS_RANK_50_P"].ToString() != "")
|| (dataTable1.Rows[0]["FRSH_HS_RANK_25_P"].ToString() != "")
|| (dataTable1.Rows[0]["FRSH_HS_RANK_10_P"].ToString() != "")
|| (dataTable1.Rows[0]["FRSH_GPA"].ToString() != "")
|| (dataTable1.Rows[0]["SAT1_VERB_200_P"].ToString() != "")
|| (dataTable1.Rows[0]["SAT1_VERB_300_P"].ToString() != "")
|| (dataTable1.Rows[0]["SAT1_VERB_400_P"].ToString() != "")
|| (dataTable1.Rows[0]["SAT1_VERB_500_P"].ToString() != "")
|| (dataTable1.Rows[0]["SAT1_VERB_600_P"].ToString() != "")
|| (dataTable1.Rows[0]["SAT1_VERB_700_P"].ToString() != "")
|| (dataTable1.Rows[0]["SAT1_MATH_200_P"].ToString() != "")
|| (dataTable1.Rows[0]["SAT1_MATH_300_P"].ToString() != "")
|| (dataTable1.Rows[0]["SAT1_MATH_400_P"].ToString() != "")
|| (dataTable1.Rows[0]["SAT1_MATH_500_P"].ToString() != "")
|| (dataTable1.Rows[0]["SAT1_MATH_600_P"].ToString() != "")
|| (dataTable1.Rows[0]["SAT1_MATH_700_P"].ToString() != "")
|| (dataTable1.Rows[0]["ACT_1_P"].ToString() != "")
|| (dataTable1.Rows[0]["ACT_2_P"].ToString() != "")
|| (dataTable1.Rows[0]["ACT_3_P"].ToString() != "")
|| (dataTable1.Rows[0]["ACT_4_P"].ToString() != "")
|| (dataTable1.Rows[0]["ACT_5_P"].ToString() != "")
|| (dataTable1.Rows[0]["ACT_6_P"].ToString() != "")
)
bShow5 = true;
if ((dataTable1.Rows[0]["lib_main_name"].ToString() != "")
|| (dataTable1.Rows[0]["lib_vol_n"].ToString() != "")
|| (dataTable1.Rows[0]["lib_serials_n"].ToString() != "")
|| (dataTable1.Rows[0]["lib_micro_n"].ToString() != "")
|| (dataTable1.Rows[0]["lib_av_n"].ToString() != "")
|| (dataTable1.Rows[0]["lib_vol_n"].ToString() != "")
|| (dataTable1.Rows[0]["cmptr_n"].ToString() != "")
|| (dataTable1.Rows[0]["www"].ToString() == "X")
|| (dataTable1.Rows[0]["lab"].ToString() == "Y")
|| (dataTable1.Rows[0]["net"].ToString() == "Y")
|| (dataTable1.Rows[0]["net_stud_rm"].ToString() == "Y")
|| (dataTable1.Rows[0]["NET_OFFCMPS"].ToString() == "Y")
|| (dataTable1.Rows[0]["career_counsel_indv"].ToString() != "")
|| (dataTable1.Rows[0]["career_counsel_grp"].ToString() != "")
|| (dataTable1.Rows[0]["career_place"].ToString() != "")
|| (dataTable1.Rows[0]["career_recruit"].ToString() != "")
|| (dataTable1.Rows[0]["career_job_bank"].ToString() == "X")
|| (dataTable1.Rows[0]["career_job_fairs"].ToString() == "X")
|| (dataTable1.Rows[0]["career_job_iview"].ToString() == "X")
|| (dataTable1.Rows[0]["career_lib"].ToString() == "X")
|| (dataTable1.Rows[0]["career_resume_prep"].ToString() == "X")
|| (dataTable1.Rows[0]["career_resume_refer"].ToString() == "X")
|| (dataTable1.Rows[0]["career_testing"].ToString() == "X")
|| (dataTable1.Rows[0]["career_iview_wrkshp"].ToString() == "X")
|| (dataTable1.Rows[0]["career_oth_t"].ToString() != "")
|| (dataTable1.Rows[0]["SRVC_LEGAL"].ToString() == "Y")
|| (dataTable1.Rows[0]["SRVC_HEALTH"].ToString() == "Y")
|| (dataTable1.Rows[0]["SRVC_PSYCH"].ToString() == "Y")
|| (dataTable1.Rows[0]["SRVC_WMN_CTR"].ToString() == "Y")
)
bShow6 = true;
if (((dataTable1.Rows[0]["hous"].ToString() == "Y")
&& ((dataTable1.Rows[0]["hous_coed"].ToString() == "X")
|| (dataTable1.Rows[0]["hous_men"].ToString() == "X")
|| (dataTable1.Rows[0]["hous_wmn"].ToString() == "X")))
|| (dataTable1.Rows[0]["hous_req_yr"].ToString() != "")
|| (dataTable1.Rows[0]["life_frat_nat"].ToString() == "Y")
|| (dataTable1.Rows[0]["life_frat_local"].ToString() == "Y")
|| (dataTable1.Rows[0]["life_sor_nat"].ToString() == "Y")
|| (dataTable1.Rows[0]["life_sor_local"].ToString() == "Y")
|| (dataTable1.Rows[0]["life_chorus"].ToString() == "Y")
|| (dataTable1.Rows[0]["life_drama"].ToString() == "Y")
|| (dataTable1.Rows[0]["life_band"].ToString() == "Y")
|| (dataTable1.Rows[0]["life_news"].ToString() == "Y")
|| (dataTable1.Rows[0]["life_radio"].ToString() == "Y")
|| (dataTable1.Rows[0]["life_television"].ToString() == "Y")
|| (dataTable1.Rows[0]["life_pbk"].ToString() == "Y")
|| (dataTable1.Rows[0]["life_sx"].ToString() == "Y")
|| (dataTable1.Rows[0]["life_org_1_t"].ToString() != "")
|| (dataTable1.Rows[0]["life_org_2_t"].ToString() != "")
|| (dataTable1.Rows[0]["life_org_3_t"].ToString() != "")
|| (dataTable1.Rows[0]["life_org_4_t"].ToString() != "")
|| (dataTable1.Rows[0]["life_org_5_t"].ToString() != "")
|| (dataTable1.Rows[0]["life_event_1_t"].ToString() != "")
|| (dataTable1.Rows[0]["life_event_2_t"].ToString() != "")
|| (dataTable1.Rows[0]["life_event_3_t"].ToString() != ""))
bShow7 = true;
if ((bSportScholarships)
|| (bIntraSports)
|| (bInterSports)
|| (dataTable1.Rows[0]["assn_athl_ncaa"].ToString() != "")
|| (dataTable1.Rows[0]["assn_athl_naia"].ToString() == "X")
|| (dataTable1.Rows[0]["assn_athl_nccaa"].ToString() == "X")
|| (dataTable1.Rows[0]["assn_athl_nscaa"].ToString() == "X")
|| (dataTable1.Rows[0]["assn_athl_njcaa"].ToString() == "X"))
bShow8 = true;
}
/// <summary>Gets formatted date particle string for this.isoDate, based on
/// date format pattern token specified, and date format information object.
///
/// Eg. for this.isoDate=2003/06/30, pattern=MMM, dateFormat={en-au}, result=Jun</summary>
/// <param name="patternToken">Format pattern token</param>
/// <returns>Formatted date particle string</returns>
private string GetPatternReplacement(string patternToken, System.Globalization.DateTimeFormatInfo dateFormat)
{
switch (patternToken[0])
{
// Year tokens
case 'y':
switch (patternToken)
{
case "yyyy": return(this.isoDate.Year.ToString());
case "yy":
int year = this.isoDate.Year % 100;
return(year > 9 ? year.ToString() : "0" + year);
case "y": return((this.isoDate.Year % 100).ToString());
default: throw new NotSupportedException("Format pattern token '" + patternToken +
"' not supported for DvDateTime formatted ToString.");
}
// Month tokens
case 'M':
switch (patternToken)
{
case "MMMM": return(dateFormat.MonthNames[this.isoDate.Month - 1]);
case "MMM": return(dateFormat.AbbreviatedMonthNames[this.isoDate.Month - 1]);
case "MM":
int month = this.isoDate.Month;
return(month > 9 ? month.ToString() : "0" + month);
case "M": return(this.isoDate.Month.ToString());
default: throw new NotSupportedException("Format pattern token '" + patternToken +
"' not supported for DvDateTime formatted ToString.");
}
// Day tokens
case 'd':
switch (patternToken)
{
case "dddd":
System.DateTime timeDDDD = new System.DateTime(this.isoDate.Year,
this.isoDate.Month, this.isoDate.Day);
return(dateFormat.DayNames[(int)dateFormat.Calendar.GetDayOfWeek(timeDDDD)]);
case "ddd":
System.DateTime timeDDD = new System.DateTime(this.isoDate.Year,
this.isoDate.Month, this.isoDate.Day);
return(dateFormat.AbbreviatedDayNames[(int)dateFormat.Calendar.GetDayOfWeek(timeDDD)]);
case "dd":
int day = this.isoDate.Day;
return(day > 9 ? day.ToString() : "0" + day);
case "d": return(this.isoDate.Day.ToString());
default: throw new NotSupportedException("Format pattern token '" + patternToken +
"' not supported for DvDateTime formatted ToString.");
}
// Cover every other kind of token
default:
switch (patternToken)
{
// Symbols tokens, misc
case "/": return(dateFormat.DateSeparator);
case "gg":
throw new NotSupportedException(
"Format pattern token 'gg' is explicitly not supported for DvDateTime formatted ToString.");
default:
throw new NotSupportedException("Format pattern token '" + patternToken +
"' not supported for DvDateTime formatted ToString.");
} //end inner (default) switch
} // end outer switch
}
//=================================================================================================
private int folder_action_do()
{
// check source path
string lsFilePathS = moSource.msBase + moSource.msPath ;
if( ! Directory.Exists( lsFilePathS ) )
{
return (int) cMsg.MsgNo.ERROR_FILE_SOURCE_PATH_NOT_EXIST ;
}
// check destination path when action type is copy, move, copy_rename
string lsFilePathD = moDestination.msBase + moDestination.msPath ;
if( ( moAction.miType == cAction.Type.COPY
|| moAction.miType == cAction.Type.COPY_RENAME
|| moAction.miType == cAction.Type.MOVE
)
&&
( ! Directory.Exists( lsFilePathD ) )
)
{
return (int) cMsg.MsgNo.ERROR_FOLDER_DESTINATION_PATH_NOT_EXIST ;
}
// prepare datum
DateTime loNow = new DateTime() ;
DateTime loDatum = new DateTime() ;
loNow = DateTime.Now ;
int liValue = System.Convert.ToInt32( moCondition.msValue ) ;
switch( moCondition.msUnit.ToUpper() )
{
case "YEAR" :
loDatum = loNow.AddYears( (-1)*liValue ) ;
break ;
case "MONTH" :
loDatum = loNow.AddMonths( (-1)*liValue ) ;
break ;
case "DAY" :
loDatum = loNow.AddDays( (-1)*liValue ) ;
break ;
case "HOUR" :
loDatum = loNow.AddHours( (-1)*liValue ) ;
break ;
case "MINUTE" :
loDatum = loNow.AddMinutes( (-1)*liValue ) ;
break ;
case "SECOND" :
loDatum = loNow.AddSeconds( (-1)*liValue ) ;
break ;
default :
break ;
}
// prepare regular expression
System.Text.RegularExpressions.Regex loReg ;
System.Text.RegularExpressions.Match loMatch ;
System.Globalization.DateTimeFormatInfo loDateTimeFormat = new System.Globalization.DateTimeFormatInfo( ) ;
if( moCondition.msField == "FILENAME" )
{
try{ loReg = new System.Text.RegularExpressions.Regex( moCondition.msRegular ) ; }
catch( Exception e ){ return (int) cMsg.MsgNo.ERROR_FOLDER_NAMES_REGULAR_EXPRESSION_WRONG ; }
}
// prepare all folder name
string[] lsaFileNames ;
if( moSource.msExt == "" )
{
lsaFileNames = Directory.GetDirectories( lsFilePathS ) ;
}
else
{
lsaFileNames = Directory.GetDirectories( lsFilePathS , moSource.msExt ) ;
}
// process every item
for( int i=0 ; i < lsaFileNames.Length ; i++ )
{
// prepare fileTime
DirectoryInfo loFileInfo = new DirectoryInfo( lsaFileNames[i] ) ;
DateTime loFileTime = new DateTime() ;
string lsFileTime ;
switch( moCondition.msField )
{
case "WRITE_TIME" :
loFileTime = loFileInfo.LastWriteTime ;
break ;
case "FILENAME" :
// get datetime string
loReg = new System.Text.RegularExpressions.Regex( moCondition.msRegular ) ;
loMatch = loReg.Match( loFileInfo.Name ) ;
if( loMatch.Success )
{
lsFileTime = loMatch.ToString() ;
}
else
{
continue ;
}
// datetime string to datetime
loReg = new System.Text.RegularExpressions.Regex( "[^0-9]{1,}" );
loMatch = loReg.Match( lsFileTime ) ;
if( loMatch.Success )
{
try
{
loFileTime = DateTime.Parse( lsFileTime ) ;
}
catch( Exception e )
{
continue ;
}
}
else
{
try
{
if( ! cDatetime.to_datetime( lsFileTime , moCondition.msFormat , out loFileTime ) )
{
continue ;
}
}
catch( Exception e )
{
continue ;
}
}
break ;
default :
break ;
}
// compare datum and fileTime
bool lbCompareResult = false ;
switch( moCondition.msCompare )
{
case ">" :
lbCompareResult = ( loDatum > loFileTime ) ;
break ;
case ">=" :
lbCompareResult = ( loDatum >= loFileTime ) ;
break ;
case "<" :
lbCompareResult = ( loDatum < loFileTime ) ;
break ;
case "<=" :
lbCompareResult = ( loDatum <= loFileTime ) ;
break ;
default :
break ;
}
// do action
string lsNewName = "";
if( lbCompareResult )
{
switch( moAction.miType )
{
case cAction.Type.COPY :
cFile.copy_directory( loFileInfo.FullName , lsFilePathD + @"\" + loFileInfo.Name ) ;
break ;
case cAction.Type.DELETE :
System.IO.Directory.Delete( loFileInfo.FullName ,true) ;
break ;
case cAction.Type.RENAME :
lsNewName = lsFilePathS + @"\" + moDestination.msNewName.Replace( "{FILENAME}" , loFileInfo.Name ) ;
System.IO.Directory.Move( loFileInfo.FullName , lsNewName ) ;
break ;
case cAction.Type.MOVE :
lsNewName = lsFilePathD + @"\" + loFileInfo.Name ;
System.IO.Directory.Move( loFileInfo.FullName , lsNewName ) ;
break ;
case cAction.Type.COPY_RENAME :
// copy
cFile.copy_directory( loFileInfo.FullName , lsFilePathD + @"\" + loFileInfo.Name ) ;
// rename
lsNewName = lsFilePathS + @"\" + moDestination.msNewName.Replace( "{FILENAME}" , loFileInfo.Name ) ;
System.IO.Directory.Move( loFileInfo.FullName , lsNewName ) ;
break ;
default :
break ;
}
}
}
return (int) cMsg.MsgNo.SUCCESS ;
}
private void btnNextDinner_Click(object sender, EventArgs e)
{
List <int> users = new List <int>();
for (int i = 0; i < ds.Tables["user"].Rows.Count; i++)
{
if (Convert.ToBoolean(ds.Tables["user"].Rows[i]["Active"]))
{
users.Add(i);
}
}
int numUsers = users.Count;
int numDinners = (numUsers + 2) / 4;
int currentDinner;
bool isSorted;
List <int> remaining = new List <int>();
int[,] hostedCountSorted, currDinnerGridTally = new int[2, numUsers];
int[,] dinners = new int[numDinners, 5];
string date = "";
for (int i = 0; i < dinners.GetLength(0); i++)
{
for (int j = 0; j < dinners.GetLength(1); j++)
{
dinners[i, j] = -1;
}
}
int to, from, temp1, temp2;
//get date
System.Globalization.DateTimeFormatInfo mfi = new System.Globalization.DateTimeFormatInfo();
date = mfi.GetAbbreviatedMonthName(dateTimePicker1.Value.Month) + " " + dateTimePicker1.Value.Year;
hostedCountSorted = new int[2, numUsers];
for (int i = 0; i < numUsers; i++)
{
hostedCountSorted[0, i] = users[i];
hostedCountSorted[1, i] = Convert.ToInt16(ds.Tables["user"].Rows[users[i]]["Host#"].ToString()) + 1;
}
//host month/active exceptions
int dateMonth = dateTimePicker1.Value.Month;
int userMonth;
for (int i = 0; i < numUsers; i++)
{
userMonth = Convert.ToInt16(ds.Tables["user"].Rows[users[i]]["Month"]);
if (userMonth == dateMonth)
{
hostedCountSorted[1, users[i]] = 0;
}
else if (userMonth != 0)
{
hostedCountSorted[1, users[i]] = Int16.MaxValue;
}
}
//randomize
Random rnd = new Random();
for (int i = 0; i < numUsers * 2; i++)
{
to = rnd.Next(0, hostedCountSorted.GetLength(1));
from = rnd.Next(0, hostedCountSorted.GetLength(1));
temp1 = hostedCountSorted[0, to];
temp2 = hostedCountSorted[1, to];
hostedCountSorted[0, to] = hostedCountSorted[0, from];
hostedCountSorted[1, to] = hostedCountSorted[1, from];
hostedCountSorted[0, from] = temp1;
hostedCountSorted[1, from] = temp2;
}
//sort
do
{
isSorted = true;
for (int i = 0; i < hostedCountSorted.GetLength(1) - 1; i++)
{
if (hostedCountSorted[1, i] > hostedCountSorted[1, i + 1])
{
//swap hosted values
temp1 = hostedCountSorted[1, i];
hostedCountSorted[1, i] = hostedCountSorted[1, i + 1];
hostedCountSorted[1, i + 1] = temp1;
//swap id
temp1 = hostedCountSorted[0, i];
hostedCountSorted[0, i] = hostedCountSorted[0, i + 1];
hostedCountSorted[0, i + 1] = temp1;
isSorted = false;
}
}
} while (!isSorted);
//choose the lowest x hosts, where x is the number of dinners
for (int i = 0; i < numDinners; i++)
{
//update number of times user has hosted
ds.Tables["user"].Rows[hostedCountSorted[0, i]]["Host#"] = Convert.ToInt16(ds.Tables["user"].Rows[hostedCountSorted[0, i]]["Host#"].ToString()) + 1;
//add host id to dinner array
dinners[i, 0] = hostedCountSorted[0, i];
}
//list of ids
remaining = users; //(basically name change)
//remove hosts from grid copy
for (int i = 0; i < dinners.GetLength(0); i++)
{
remaining.Remove(dinners[i, 0]);
}
//for each person left, find them a group
currentDinner = 0;
while (remaining.Count > 0)
{
//get grid tally for all users according to people in current group
currDinnerGridTally = new int[2, remaining.Count];
for (int i = 0; i < dinners.GetLength(1); i++)
{
if (dinners[currentDinner, i] == -1)
{
break;
}
for (int j = 0; j < remaining.Count; j++)
{
currDinnerGridTally[0, j] = remaining[j];
currDinnerGridTally[1, j] += Convert.ToInt16(ds.Tables["matchCount"].Rows[dinners[currentDinner, i]][remaining[j]]);
}
}
//randomize
for (int i = 0; i < currDinnerGridTally.GetLength(1) * 2; i++)
{
to = rnd.Next(0, currDinnerGridTally.GetLength(1));
from = rnd.Next(0, currDinnerGridTally.GetLength(1));
temp1 = currDinnerGridTally[0, to];
temp2 = currDinnerGridTally[1, to];
currDinnerGridTally[0, to] = currDinnerGridTally[0, from];
currDinnerGridTally[1, to] = currDinnerGridTally[1, from];
currDinnerGridTally[0, from] = temp1;
currDinnerGridTally[1, from] = temp2;
}
//sort
do
{
isSorted = true;
for (int i = 0; i < currDinnerGridTally.GetLength(1) - 1; i++)
{
if (currDinnerGridTally[1, i] > currDinnerGridTally[1, i + 1])
{
//swap hosted values
temp1 = currDinnerGridTally[1, i];
currDinnerGridTally[1, i] = currDinnerGridTally[1, i + 1];
currDinnerGridTally[1, i + 1] = temp1;
//swap id
temp1 = currDinnerGridTally[0, i];
currDinnerGridTally[0, i] = currDinnerGridTally[0, i + 1];
currDinnerGridTally[0, i + 1] = temp1;
isSorted = false;
}
}
} while (!isSorted);
//find available spot (indicated by -1) and put new member in
for (int k = 1; k < dinners.GetLength(1); k++)
{
if (dinners[currentDinner, k] == -1)
{
dinners[currentDinner, k] = currDinnerGridTally[0, 0];
break;
}
}
remaining.Remove(currDinnerGridTally[0, 0]);
currentDinner = (currentDinner + 1) % numDinners;
}
//increase matched (grid) count
//loop through dinners
for (int i = 0; i < dinners.GetLength(0); i++)
{
for (int j = 0; j < dinners.GetLength(1); j++)
{
for (int k = 0; k < dinners.GetLength(1); k++)
{
if (!(j == k || dinners[i, j] == -1 || dinners[i, k] == -1))
{
ds.Tables["matchCount"].Rows[dinners[i, j]][dinners[i, k]] = Convert.ToInt16(ds.Tables["matchCount"].Rows[dinners[i, j]][dinners[i, k]]) + 1;
}
}
}
}
history.Add(dinners);
historyDate.Add(date);
if (lsbDinnerSelect.Items[0].ToString().Equals("<empty>"))
{
lsbDinnerSelect.Items.Clear();
}
lsbDinnerSelect.Items.Add(date);
UpdateCellColors();
}
// --Commented out by Inspection START (11/21/05 12:42 PM):
// /**
// * Get the byte lengthOfSection of this numberOfSection.
// *
// * @return lengthOfSection in bytes of this numberOfSection
// */
// public final int getLength()
// {
// return lengthOfSection;
// }
// --Commented out by Inspection STOP (11/21/05 12:42 PM)
// --Commented out by Inspection START (11/21/05 12:42 PM):
// /**
// * Number of this numberOfSection, should be 1
// */
// public final int getSection()
// {
// return numberOfSection;
// }
// --Commented out by Inspection STOP (11/21/05 12:42 PM)
static Grib2IdentificationSection()
{
{
//UPGRADE_ISSUE: Constructor 'java.text.SimpleDateFormat.SimpleDateFormat' was not converted. "ms-help://MS.VSCC.v80/dv_commoner/local/redirect.htm?index='!DefaultContextWindowIndex'&keyword='jlca1000_javatextSimpleDateFormat'"
dateFormat = new System.Globalization.DateTimeFormatInfo();
}
}
/// <summary>
/// 期間定義文字列から開始・終了日時を取得します。
/// </summary>
/// <param name="terms">期間定義文字列</param>
/// <param name="year">対象年</param>
/// <returns>DateTime型配列 / [0]: 開始日時, [1]: 終了日時, [2]: MinValue(日付指定) / MaxValue(相対指定)</returns>
public static DateTime[] FromTerm(string terms, int year)
{
var dt = new DateTime[3];
if (terms == "<Empty>")
{
return(dt);
}
var daterm = @"^(\d\d)/(\d\d)/(\d\d)-(\d\d):(\d\d) (\d{1,3})(Ds|Hs|Ms)$";
var targeterm = @"^@\[(\s?[A-Za-z0-9]+)*\]-(\d\d):(\d\d) (\d{1,3})(Ds|Hs|Ms)$";
try {
if (Regex.IsMatch(terms, daterm))
{
var m = Regex.Match(terms, daterm);
dt[0] = new DateTime(
int.Parse(m.Groups[1].ToString()) + 2_000, int.Parse(m.Groups[2].ToString()), int.Parse(m.Groups[3].ToString()),
int.Parse(m.Groups[4].ToString()), int.Parse(m.Groups[5].ToString()), 0
);
var timeVal = int.Parse(m.Groups[6].ToString());
switch (m.Groups[7].ToString())
{
case "Ds":
dt[1] = dt[0].AddDays(timeVal);
break;
case "Hs":
dt[1] = dt[0].AddHours(timeVal);
break;
case "Ms":
dt[1] = dt[0].AddMinutes(timeVal);
break;
default:
return(null);
}
dt[2] = DateTime.MinValue;
return(dt);
}
else if (Regex.IsMatch(terms, targeterm))
{
var m = Regex.Match(terms, targeterm);
var target = m.Groups[1].Captures.Cast <Capture>().Select(x => x.ToString().Trim()).ToArray();
var timeVal = int.Parse(m.Groups[4].ToString());
var weekNumber = int.TryParse(target[0], out int res) ? res : 5;
var weekDay = new System.Globalization.DateTimeFormatInfo().DayNames.ToList()
.FindIndex(x => x == target[1]);
var monthNumber = new System.Globalization.DateTimeFormatInfo().MonthNames.ToList()
.FindIndex(x => x == target[2]);
if (weekDay == -1 || monthNumber == -1)
{
return(null);
}
dt[0] = FromWeekNumber(year, monthNumber + 1, weekNumber, (DayOfWeek)weekDay);
dt[0] = dt[0].AddHours(int.Parse(m.Groups[2].ToString())).AddMinutes(int.Parse(m.Groups[3].ToString()));
switch (m.Groups[5].ToString())
{
case "Ds":
dt[1] = dt[0].AddDays(timeVal);
break;
case "Hs":
dt[1] = dt[0].AddHours(timeVal);
break;
case "Ms":
dt[1] = dt[0].AddMinutes(timeVal);
break;
default:
return(null);
}
dt[2] = DateTime.MaxValue;
return(dt);
}
} catch (Exception e) {
Console.WriteLine(e.Message);
}
return(null);
}
///<summary>
/// This method creates a customer with the same details of a self exclusion customer
/// <example>RegisterCustomer_selfExclusion(portalbrowser, adminbrowser) </example>
public void RegisterCustomer_selfExclusion(ISelenium browser, ISelenium adminBrowser)
{
try
{
string regMsg, gender, xPath;
var admincommonObj = new AdminSuite.Common();
Random rnd = new Random();
int rndNumber = rnd.Next(10000);
//get details of customer in OB
adminBrowser.WindowFocus();
string username = "******" + rndNumber;
admincommonObj.SelectMainFrame(adminBrowser);
string firstname = adminBrowser.GetText("//tr/td[@class='caption' and contains(text(), 'First Name:')]/following-sibling::td");
string lastname = adminBrowser.GetText("//tr/td[@class='caption' and contains(text(), 'Last Name:')]/following-sibling::td");
string title = adminBrowser.GetText("//tr/td[@class='caption' and contains(text(), 'Title:')]/following-sibling::td");
if (title.ToLower() == "mr")
{
gender = "male";
}
else
{
gender = "female";
}
string dob = adminBrowser.GetText("//tr/td[@class='caption' and contains(text(), 'Date of Birth:')]/following-sibling::td");
string[] arr = dob.Split('-');
string DOByear = arr[0];
System.Globalization.DateTimeFormatInfo mfi = new System.Globalization.DateTimeFormatInfo();
string DOBmonth = mfi.GetMonthName(int.Parse(arr[1])).ToString();
string DOBday = arr[2];
string houseno = adminBrowser.GetText("//tr/td[@class='caption' and contains(text(), 'Address (1)')]/following-sibling::td");
string postcode = adminBrowser.GetText("//tr/td[@class='caption' and contains(text(), 'Postcode:')]/following-sibling::td");
string address1 = adminBrowser.GetText("//tr/td[@class='caption' and contains(text(), '(2)')]/following-sibling::td") + adminBrowser.GetText("//tr/td[@class='caption' and contains(text(), '(3)')]/following-sibling::td");
string address2 = adminBrowser.GetText("//tr/td[@class='caption' and contains(text(), '(3)')]/following-sibling::td");
string city = adminBrowser.GetText("//tr/td[@class='caption' and contains(text(), 'City:')]/following-sibling::td");
string email = adminBrowser.GetText("//tr/td[@class='caption' and contains(text(), 'Email:')]/following-sibling::td");
string teleCode = "+44";
string telnumber = "1234567890";
string mobnumber = "1234512345";
string password = "******";
string confirmPassword = "******";
string securityQuestion = "Favourite Colour";
string securityAnswer = "Blue";
string accountCurrency = "UK Pound Sterling";
string country = "United Kingdom";
browser.WindowFocus();
WaitForLoadingIcon_MobileLobby(browser, FrameGlobals.IconLoadTimeout);
Assert.IsTrue(browser.IsVisible(MobileLobbyControls.registrationTitle), "Registration Page is not displayed");
//Enter data in all the fields
browser.Type(MobileLobbyControls.promocode, "");
browser.Select(MobileLobbyControls.title, title);
browser.Type(MobileLobbyControls.firstname, firstname);
browser.Type(MobileLobbyControls.lastname, lastname);
//gender
if (gender.ToLower().Trim() == "male")
{
browser.Click(MobileLobbyControls.genderMale);
}
else
{
browser.Click(MobileLobbyControls.genderFemale);
}
browser.Select(MobileLobbyControls.DOBday, DOBday);
browser.Select(MobileLobbyControls.DOBmonth, DOBmonth);
browser.Select(MobileLobbyControls.DOByear, DOByear);
browser.Select(MobileLobbyControls.country, country);
browser.Type(MobileLobbyControls.housename, houseno);
browser.Type(MobileLobbyControls.postcode, postcode);
browser.Type(MobileLobbyControls.address1, address1);
browser.Type(MobileLobbyControls.address2, address2);
browser.Type(MobileLobbyControls.city, city);
browser.Type(MobileLobbyControls.email, email);
browser.Type(MobileLobbyControls.telintcode, teleCode);
browser.Type(MobileLobbyControls.telnumber, telnumber);
browser.Type(MobileLobbyControls.mobintcode, teleCode);
browser.Type(MobileLobbyControls.mobnumber, mobnumber);
browser.Select(MobileLobbyControls.accountCurrency, accountCurrency);
browser.Type(MobileLobbyControls.username, username);
browser.Type(MobileLobbyControls.password, password);
browser.Type(MobileLobbyControls.confirmPassword, confirmPassword);
browser.Select(MobileLobbyControls.securityQuestion, securityQuestion);
browser.Type(MobileLobbyControls.securityAnswer, securityAnswer);
MLcommonObj.SelectCheckbox(browser, MobileLobbyControls.contactMe, "on");
MLcommonObj.SelectCheckbox(browser, MobileLobbyControls.aggreement, "on");
Thread.Sleep(1000);
//Validate registration
clickObject_MobileLobby(browser, MobileLobbyControls.registerNow);
Assert.IsTrue(browser.IsVisible(MobileLobbyControls.registrationTitle), "Registration page title was not found in the header after registration");
Assert.IsTrue(browser.IsVisible(MobileLobbyControls.failureRgMsg), "Registration failure message was not displayed");
regMsg = "We are sorry but your country of residence is currently prohibited from using the Ladbrokes service.";
xPath = "//ul[@class='error_align']/li[contains(text()[2], '" + regMsg + "')]";
Assert.IsTrue(browser.IsElementPresent(xPath), "Registration failure message was not displayed to the user");
Assert.IsTrue(browser.IsVisible(MobileLobbyControls.contactMessage), "Customer contact message was not displayed on failing to create a customer from banned country");
Console.WriteLine("Customer was not registered as his details provided matched a self excluded customer");
}
catch (Exception ex)
{
CaptureScreenshot(browser, "EnterRegisterDetails");
Console.WriteLine("Function 'EnterRegisterDetails' - Failed");
Console.WriteLine(ex.Message);
Fail(ex.Message);
}
}
public CrateDB()
{
System.Globalization.CultureInfo culture = System.Globalization.CultureInfo.CreateSpecificCulture("en-US");
dtfi = culture.DateTimeFormat;
}
/// <summary>
/// Weeks the of year.
/// </summary>
/// <param name="datetime">The datetime.</param>
/// <param name="firstDayOfWeek">The first day of week.</param>
/// <returns></returns>
public static int WeekOfYear(this DateTime datetime, DayOfWeek firstDayOfWeek)
{
System.Globalization.DateTimeFormatInfo dateinf = new System.Globalization.DateTimeFormatInfo();
System.Globalization.CalendarWeekRule weekrule = dateinf.CalendarWeekRule;
return(WeekOfYear(datetime, weekrule, firstDayOfWeek));
}
public ActionResult Index()
{
ViewBag.Message = Session["msg"];
ViewBag.Error = Session["err"];
Session["err"] = "";
Session["msg"] = "";
int companyacademicyearid = Convert.ToInt16(Session["CompanyAcademicYearID"].ToString());
int roleid = Convert.ToInt16(Session["RoleID"].ToString());
int userid = Convert.ToInt16(Session["UserID"].ToString());
int schoolid = Convert.ToInt16(Session["SchoolID"].ToString());
System.Globalization.DateTimeFormatInfo mfi = new System.Globalization.DateTimeFormatInfo();
int classid = 0;
if (Request.QueryString["class"] != null)
{
try
{
classid = Convert.ToInt16(Request.QueryString["class"]);
}
catch { }
}
int sectionid = 0;
if (Request.QueryString["section"] != null)
{
try
{
sectionid = Convert.ToInt16(Request.QueryString["section"]);
}
catch { }
}
DateTime dte = Convert.ToDateTime(DateTime.Now.Year + "-" + DateTime.Now.Month + "-" + DateTime.Now.Day);
DateTime dteyearstart = Convert.ToDateTime(DateTime.Now.Year + "-01-01");
if (Request.QueryString["date"] != null)
{
try
{
dte = Convert.ToDateTime(Request.QueryString["date"]);
dte = Convert.ToDateTime(dte.Year + "-" + dte.Month + "-" + dte.Day);
}
catch { }
}
List <StudentAttendanceModel> studentAttendancemodelList = new List <StudentAttendanceModel>();
Calendar calendar = db.Calendars.Where(c => c.Date == dte).FirstOrDefault();
if (calendar.IsHoliday)
{
ViewBag.Error = " Selected date : " + dte.Day + " - " + mfi.GetMonthName(dte.Month).Substring(0, 3) + " - " + dte.Year + " is HOLIDAY : " + calendar.Description;
calendar = db.Calendars.Where(c => c.Date <= dte && c.IsHoliday == false).OrderByDescending(c => c.Date).FirstOrDefault();
dte = calendar.Date;
dte = Convert.ToDateTime(dte.Year + "-" + dte.Month + "-" + dte.Day);
}
int workingdays = db.Calendars.Where(c => c.Date <= dte && c.Date >= dteyearstart && c.IsHoliday == false).Count();
foreach (Student student in db.Students.ToList())
{
StudentAttendance isStudentAdded = db.StudentAttendances.Where(s => s.StudentID == student.StudentID && s.AttendanceDate == calendar.Date).FirstOrDefault();
if (isStudentAdded == null)
{
StudentAttendance studentAttendancenew = new StudentAttendance();
studentAttendancenew.AttendanceTypeID = 2;
studentAttendancenew.AttendanceDate = calendar.Date;
studentAttendancenew.StudentID = student.StudentID;
studentAttendancenew.IdCard = student.IdCard;
studentAttendancenew.UserID = userid;
studentAttendancenew.UpdatedDate = DateTime.Now;
studentAttendancenew.Percentage = 0;
db.StudentAttendances.Add(studentAttendancenew);
db.SaveChanges();
}
else
{
StudentAttendance studentAttendanceexist = db.StudentAttendances.Find(isStudentAdded.StudentAttendanceID);
int attendeddays = db.StudentAttendances.Where(s => s.StudentID == student.StudentID && s.AttendanceDate <= calendar.Date && s.AttendanceTypeID == 1).Count();
double perc = Convert.ToInt16(attendeddays) * 100 / Convert.ToInt16(workingdays);
decimal perc1 = Convert.ToDecimal(string.Format("{0:0.00}", perc));
studentAttendanceexist.Percentage = perc1;
db.Entry(studentAttendanceexist).State = EntityState.Modified;
db.SaveChanges();
}
}
var studentAttendance = db.StudentAttendances.Include(s => s.CurrentAttendanceType).Include(s => s.CurrentStudent).Include(s => s.CurrentStudent.CurrentSchool).Include(s => s.CurrentStudent.CurrentClass).Include(s => s.CurrentStudent.CurrentSection).Include(s => s.CurrentUser).Where(s => s.AttendanceDate == calendar.Date && s.CurrentStudent.CurrentSchool.SchoolID == schoolid && s.CurrentStudent.CurrentClass.ClassID == classid && s.CurrentStudent.CurrentSection.SectionID == sectionid).OrderBy(t => t.CurrentStudent.Name).ToList();
foreach (StudentAttendance ta in studentAttendance)
{
StudentAttendanceModel studentAttendancemodel = new StudentAttendanceModel();
studentAttendancemodel.StudentAttendanceID = ta.StudentAttendanceID;
studentAttendancemodel.StudentID = ta.StudentID;
studentAttendancemodel.ClassID = ta.CurrentStudent.CurrentClass.ClassID;
studentAttendancemodel.SectionID = ta.CurrentStudent.CurrentSection.SectionID;
studentAttendancemodel.Class = ta.CurrentStudent.CurrentClass.Name;
studentAttendancemodel.Section = ta.CurrentStudent.CurrentSection.Name;
studentAttendancemodel.IdCard = ta.IdCard;
studentAttendancemodel.StudentName = ta.CurrentStudent.Name;
studentAttendancemodel.AttendanceTypeID = ta.AttendanceTypeID;
studentAttendancemodel.BackDay1 = "";
studentAttendancemodel.BackDay2 = "";
studentAttendancemodel.BackDay3 = "";
studentAttendancemodel.BackDay4 = "";
studentAttendancemodel.BackDay5 = "";
studentAttendancemodel.BackDay6 = "";
studentAttendancemodel.Percentage = ta.Percentage;
studentAttendancemodelList.Add(studentAttendancemodel);
}
ViewBag.SelectedDate = calendar.Date.Day + " " + mfi.GetMonthName(calendar.Date.Month).Substring(0, 3) + " " + calendar.Date.Year;
dte = calendar.Date.AddDays(-1);
calendar = db.Calendars.Where(c => c.Date <= dte && c.IsHoliday == false).OrderByDescending(c => c.Date).FirstOrDefault();
foreach (Student student in db.Students.ToList())
{
StudentAttendance isStudentAdded = db.StudentAttendances.Where(s => s.StudentID == student.StudentID && s.AttendanceDate == calendar.Date).FirstOrDefault();
if (isStudentAdded == null)
{
StudentAttendance studentAttendancenew = new StudentAttendance();
studentAttendancenew.AttendanceTypeID = 2;
studentAttendancenew.AttendanceDate = calendar.Date;
studentAttendancenew.StudentID = student.StudentID;
studentAttendancenew.IdCard = student.IdCard;
studentAttendancenew.UserID = userid;
studentAttendancenew.UpdatedDate = DateTime.Now;
studentAttendancenew.Percentage = 0;
db.StudentAttendances.Add(studentAttendancenew);
db.SaveChanges();
}
else
{
StudentAttendance studentAttendanceexist = db.StudentAttendances.Find(isStudentAdded.StudentAttendanceID);
int attendeddays = db.StudentAttendances.Where(s => s.StudentID == student.StudentID && s.AttendanceDate <= calendar.Date && s.AttendanceTypeID == 1).Count();
double perc = Convert.ToInt16(attendeddays) * 100 / Convert.ToInt16(workingdays);
decimal perc1 = Convert.ToDecimal(string.Format("{0:0.00}", perc));
studentAttendanceexist.Percentage = perc1;
db.Entry(studentAttendanceexist).State = EntityState.Modified;
db.SaveChanges();
}
}
studentAttendance = db.StudentAttendances.Include(s => s.CurrentAttendanceType).Include(s => s.CurrentStudent).Include(s => s.CurrentStudent.CurrentSchool).Include(s => s.CurrentStudent.CurrentClass).Include(s => s.CurrentStudent.CurrentSection).Include(s => s.CurrentUser).Where(s => s.AttendanceDate == calendar.Date && s.CurrentStudent.CurrentSchool.SchoolID == schoolid && s.CurrentStudent.CurrentClass.ClassID == classid && s.CurrentStudent.CurrentSection.SectionID == sectionid).OrderBy(t => t.CurrentStudent.Name).ToList();
foreach (StudentAttendance ta in studentAttendance)
{
StudentAttendanceModel studentattendanceid = studentAttendancemodelList.Find(item => item.StudentID == ta.StudentID);
studentattendanceid.BackDay1 = ta.CurrentAttendanceType.Name;
}
ViewBag.BackDay1 = calendar.Date.Day + " " + mfi.GetMonthName(calendar.Date.Month).Substring(0, 3);
dte = calendar.Date.AddDays(-1);
calendar = db.Calendars.Where(c => c.Date <= dte && c.IsHoliday == false).OrderByDescending(c => c.Date).FirstOrDefault();
foreach (Student student in db.Students.ToList())
{
StudentAttendance isStudentAdded = db.StudentAttendances.Where(s => s.StudentID == student.StudentID && s.AttendanceDate == calendar.Date).FirstOrDefault();
if (isStudentAdded == null)
{
StudentAttendance studentAttendancenew = new StudentAttendance();
studentAttendancenew.AttendanceTypeID = 2;
studentAttendancenew.AttendanceDate = calendar.Date;
studentAttendancenew.StudentID = student.StudentID;
studentAttendancenew.IdCard = student.IdCard;
studentAttendancenew.UserID = userid;
studentAttendancenew.UpdatedDate = DateTime.Now;
studentAttendancenew.Percentage = 0;
db.StudentAttendances.Add(studentAttendancenew);
db.SaveChanges();
}
else
{
StudentAttendance studentAttendanceexist = db.StudentAttendances.Find(isStudentAdded.StudentAttendanceID);
int attendeddays = db.StudentAttendances.Where(s => s.StudentID == student.StudentID && s.AttendanceDate <= calendar.Date && s.AttendanceTypeID == 1).Count();
double perc = Convert.ToInt16(attendeddays) * 100 / Convert.ToInt16(workingdays);
decimal perc1 = Convert.ToDecimal(string.Format("{0:0.00}", perc));
studentAttendanceexist.Percentage = perc1;
db.Entry(studentAttendanceexist).State = EntityState.Modified;
db.SaveChanges();
}
}
studentAttendance = db.StudentAttendances.Include(s => s.CurrentAttendanceType).Include(s => s.CurrentStudent).Include(s => s.CurrentStudent.CurrentSchool).Include(s => s.CurrentStudent.CurrentClass).Include(s => s.CurrentStudent.CurrentSection).Include(s => s.CurrentUser).Where(s => s.AttendanceDate == calendar.Date && s.CurrentStudent.CurrentSchool.SchoolID == schoolid && s.CurrentStudent.CurrentClass.ClassID == classid && s.CurrentStudent.CurrentSection.SectionID == sectionid).OrderBy(t => t.CurrentStudent.Name).ToList();
foreach (StudentAttendance ta in studentAttendance)
{
StudentAttendanceModel studentattendanceid = studentAttendancemodelList.Find(item => item.StudentID == ta.StudentID);
studentattendanceid.BackDay2 = ta.CurrentAttendanceType.Name;
}
ViewBag.BackDay2 = calendar.Date.Day + " " + mfi.GetMonthName(calendar.Date.Month).Substring(0, 3);
dte = calendar.Date.AddDays(-1);
calendar = db.Calendars.Where(c => c.Date <= dte && c.IsHoliday == false).OrderByDescending(c => c.Date).FirstOrDefault();
foreach (Student student in db.Students.ToList())
{
StudentAttendance isStudentAdded = db.StudentAttendances.Where(s => s.StudentID == student.StudentID && s.AttendanceDate == calendar.Date).FirstOrDefault();
if (isStudentAdded == null)
{
StudentAttendance studentAttendancenew = new StudentAttendance();
studentAttendancenew.AttendanceTypeID = 2;
studentAttendancenew.AttendanceDate = calendar.Date;
studentAttendancenew.StudentID = student.StudentID;
studentAttendancenew.IdCard = student.IdCard;
studentAttendancenew.UserID = userid;
studentAttendancenew.UpdatedDate = DateTime.Now;
studentAttendancenew.Percentage = 0;
db.StudentAttendances.Add(studentAttendancenew);
db.SaveChanges();
}
else
{
StudentAttendance studentAttendanceexist = db.StudentAttendances.Find(isStudentAdded.StudentAttendanceID);
int attendeddays = db.StudentAttendances.Where(s => s.StudentID == student.StudentID && s.AttendanceDate <= calendar.Date && s.AttendanceTypeID == 1).Count();
double perc = Convert.ToInt16(attendeddays) * 100 / Convert.ToInt16(workingdays);
decimal perc1 = Convert.ToDecimal(string.Format("{0:0.00}", perc));
studentAttendanceexist.Percentage = perc1;
db.Entry(studentAttendanceexist).State = EntityState.Modified;
db.SaveChanges();
}
}
studentAttendance = db.StudentAttendances.Include(s => s.CurrentAttendanceType).Include(s => s.CurrentStudent).Include(s => s.CurrentStudent.CurrentSchool).Include(s => s.CurrentStudent.CurrentClass).Include(s => s.CurrentStudent.CurrentSection).Include(s => s.CurrentUser).Where(s => s.AttendanceDate == calendar.Date && s.CurrentStudent.CurrentSchool.SchoolID == schoolid && s.CurrentStudent.CurrentClass.ClassID == classid && s.CurrentStudent.CurrentSection.SectionID == sectionid).OrderBy(t => t.CurrentStudent.Name).ToList();
foreach (StudentAttendance ta in studentAttendance)
{
StudentAttendanceModel studentattendanceid = studentAttendancemodelList.Find(item => item.StudentID == ta.StudentID);
studentattendanceid.BackDay3 = ta.CurrentAttendanceType.Name;
}
ViewBag.BackDay3 = calendar.Date.Day + " " + mfi.GetMonthName(calendar.Date.Month).Substring(0, 3);
dte = calendar.Date.AddDays(-1);
calendar = db.Calendars.Where(c => c.Date <= dte && c.IsHoliday == false).OrderByDescending(c => c.Date).FirstOrDefault();
foreach (Student student in db.Students.ToList())
{
StudentAttendance isStudentAdded = db.StudentAttendances.Where(s => s.StudentID == student.StudentID && s.AttendanceDate == calendar.Date).FirstOrDefault();
if (isStudentAdded == null)
{
StudentAttendance studentAttendancenew = new StudentAttendance();
studentAttendancenew.AttendanceTypeID = 2;
studentAttendancenew.AttendanceDate = calendar.Date;
studentAttendancenew.StudentID = student.StudentID;
studentAttendancenew.IdCard = student.IdCard;
studentAttendancenew.UserID = userid;
studentAttendancenew.UpdatedDate = DateTime.Now;
studentAttendancenew.Percentage = 0;
db.StudentAttendances.Add(studentAttendancenew);
db.SaveChanges();
}
else
{
StudentAttendance studentAttendanceexist = db.StudentAttendances.Find(isStudentAdded.StudentAttendanceID);
int attendeddays = db.StudentAttendances.Where(s => s.StudentID == student.StudentID && s.AttendanceDate <= calendar.Date && s.AttendanceTypeID == 1).Count();
double perc = Convert.ToInt16(attendeddays) * 100 / Convert.ToInt16(workingdays);
decimal perc1 = Convert.ToDecimal(string.Format("{0:0.00}", perc));
studentAttendanceexist.Percentage = perc1;
db.Entry(studentAttendanceexist).State = EntityState.Modified;
db.SaveChanges();
}
}
studentAttendance = db.StudentAttendances.Include(s => s.CurrentAttendanceType).Include(s => s.CurrentStudent).Include(s => s.CurrentStudent.CurrentSchool).Include(s => s.CurrentStudent.CurrentClass).Include(s => s.CurrentStudent.CurrentSection).Include(s => s.CurrentUser).Where(s => s.AttendanceDate == calendar.Date && s.CurrentStudent.CurrentSchool.SchoolID == schoolid && s.CurrentStudent.CurrentClass.ClassID == classid && s.CurrentStudent.CurrentSection.SectionID == sectionid).OrderBy(t => t.CurrentStudent.Name).ToList();
foreach (StudentAttendance ta in studentAttendance)
{
StudentAttendanceModel studentattendanceid = studentAttendancemodelList.Find(item => item.StudentID == ta.StudentID);
studentattendanceid.BackDay4 = ta.CurrentAttendanceType.Name;
}
ViewBag.BackDay4 = calendar.Date.Day + " " + mfi.GetMonthName(calendar.Date.Month).Substring(0, 3);
dte = calendar.Date.AddDays(-1);
calendar = db.Calendars.Where(c => c.Date <= dte && c.IsHoliday == false).OrderByDescending(c => c.Date).FirstOrDefault();
foreach (Student student in db.Students.ToList())
{
StudentAttendance isStudentAdded = db.StudentAttendances.Where(s => s.StudentID == student.StudentID && s.AttendanceDate == calendar.Date).FirstOrDefault();
if (isStudentAdded == null)
{
StudentAttendance studentAttendancenew = new StudentAttendance();
studentAttendancenew.AttendanceTypeID = 2;
studentAttendancenew.AttendanceDate = calendar.Date;
studentAttendancenew.StudentID = student.StudentID;
studentAttendancenew.IdCard = student.IdCard;
studentAttendancenew.UserID = userid;
studentAttendancenew.UpdatedDate = DateTime.Now;
studentAttendancenew.Percentage = 0;
db.StudentAttendances.Add(studentAttendancenew);
db.SaveChanges();
}
else
{
StudentAttendance studentAttendanceexist = db.StudentAttendances.Find(isStudentAdded.StudentAttendanceID);
int attendeddays = db.StudentAttendances.Where(s => s.StudentID == student.StudentID && s.AttendanceDate <= calendar.Date && s.AttendanceTypeID == 1).Count();
double perc = Convert.ToInt16(attendeddays) * 100 / Convert.ToInt16(workingdays);
decimal perc1 = Convert.ToDecimal(string.Format("{0:0.00}", perc));
studentAttendanceexist.Percentage = perc1;
db.Entry(studentAttendanceexist).State = EntityState.Modified;
db.SaveChanges();
}
}
studentAttendance = db.StudentAttendances.Include(s => s.CurrentAttendanceType).Include(s => s.CurrentStudent).Include(s => s.CurrentStudent.CurrentSchool).Include(s => s.CurrentStudent.CurrentClass).Include(s => s.CurrentStudent.CurrentSection).Include(s => s.CurrentUser).Where(s => s.AttendanceDate == calendar.Date && s.CurrentStudent.CurrentSchool.SchoolID == schoolid && s.CurrentStudent.CurrentClass.ClassID == classid && s.CurrentStudent.CurrentSection.SectionID == sectionid).OrderBy(t => t.CurrentStudent.Name).ToList();
foreach (StudentAttendance ta in studentAttendance)
{
StudentAttendanceModel studentattendanceid = studentAttendancemodelList.Find(item => item.StudentID == ta.StudentID);
studentattendanceid.BackDay5 = ta.CurrentAttendanceType.Name;
}
ViewBag.BackDay5 = calendar.Date.Day + " " + mfi.GetMonthName(calendar.Date.Month).Substring(0, 3);
dte = calendar.Date.AddDays(-1);
calendar = db.Calendars.Where(c => c.Date <= dte && c.IsHoliday == false).OrderByDescending(c => c.Date).FirstOrDefault();
foreach (Student student in db.Students.ToList())
{
StudentAttendance isStudentAdded = db.StudentAttendances.Where(s => s.StudentID == student.StudentID && s.AttendanceDate == calendar.Date).FirstOrDefault();
if (isStudentAdded == null)
{
StudentAttendance studentAttendancenew = new StudentAttendance();
studentAttendancenew.AttendanceTypeID = 2;
studentAttendancenew.AttendanceDate = calendar.Date;
studentAttendancenew.StudentID = student.StudentID;
studentAttendancenew.IdCard = student.IdCard;
studentAttendancenew.UserID = userid;
studentAttendancenew.UpdatedDate = DateTime.Now;
studentAttendancenew.Percentage = 0;
db.StudentAttendances.Add(studentAttendancenew);
db.SaveChanges();
}
else
{
StudentAttendance studentAttendanceexist = db.StudentAttendances.Find(isStudentAdded.StudentAttendanceID);
int attendeddays = db.StudentAttendances.Where(s => s.StudentID == student.StudentID && s.AttendanceDate <= calendar.Date && s.AttendanceTypeID == 1).Count();
double perc = Convert.ToInt16(attendeddays) * 100 / Convert.ToInt16(workingdays);
decimal perc1 = Convert.ToDecimal(string.Format("{0:0.00}", perc));
studentAttendanceexist.Percentage = perc1;
db.Entry(studentAttendanceexist).State = EntityState.Modified;
db.SaveChanges();
}
}
studentAttendance = db.StudentAttendances.Include(s => s.CurrentAttendanceType).Include(s => s.CurrentStudent).Include(s => s.CurrentStudent.CurrentSchool).Include(s => s.CurrentStudent.CurrentClass).Include(s => s.CurrentStudent.CurrentSection).Include(s => s.CurrentUser).Where(s => s.AttendanceDate == calendar.Date && s.CurrentStudent.CurrentSchool.SchoolID == schoolid && s.CurrentStudent.CurrentClass.ClassID == classid && s.CurrentStudent.CurrentSection.SectionID == sectionid).OrderBy(t => t.CurrentStudent.Name).ToList();
foreach (StudentAttendance ta in studentAttendance)
{
StudentAttendanceModel studentattendanceid = studentAttendancemodelList.Find(item => item.StudentID == ta.StudentID);
studentattendanceid.BackDay6 = ta.CurrentAttendanceType.Name;
}
ViewBag.BackDay6 = calendar.Date.Day + " " + mfi.GetMonthName(calendar.Date.Month).Substring(0, 3);
ViewBag.ClassID = new SelectList(db.Classes, "ClassID", "Name", classid);
ViewBag.SectionID = new SelectList(db.Sections, "SectionID", "Name", sectionid);
ViewBag.AttendanceTypeID = db.AttendanceTypes.ToList();
Class classselected = db.Classes.Find(classid);
Section sectionselected = db.Sections.Find(sectionid);
if (classselected != null && sectionselected != null)
{
ViewBag.Selected = "Selected Class : " + classselected.Name + ", Section: " + sectionselected.Name;
}
return(View(studentAttendancemodelList));
}
/// <summary>
/// Firsts the date time of week.
/// </summary>
/// <param name="datetime">The datetime.</param>
/// <returns></returns>
public static DateTime FirstDateTimeOfWeek(this DateTime datetime)
{
var dateinf = new System.Globalization.DateTimeFormatInfo();
DayOfWeek firstDayOfWeek = dateinf.FirstDayOfWeek;
return FirstDateTimeOfWeek(datetime, firstDayOfWeek);
}
public static DateTime ParseDate(string date)
{
System.Globalization.DateTimeFormatInfo dateFormatProvider = new System.Globalization.DateTimeFormatInfo();
dateFormatProvider.ShortDatePattern = "dd/MM/yyyy";
return(DateTime.Parse(date, dateFormatProvider));
}
/// <summary>
/// Serializes an Object Instance to the UPnP Way ;)
/// </summary>
/// <param name="data">Object to be serialized</param>
/// <returns>The serialized data, in string form</returns>
public static string SerializeObjectInstance(Object data)
{
if (data == null) return "";
string ObjectType = data.GetType().FullName;
string RetVal = "";
switch (ObjectType)
{
case "System.Byte[]":
RetVal = Base64.Encode((Byte[])data);
break;
case "System.Uri":
RetVal = ((Uri)data).AbsoluteUri;
break;
case "System.Boolean":
if ((bool)data == true)
{
RetVal = "1";
}
else
{
RetVal = "0";
}
break;
case "System.DateTime":
System.Globalization.DateTimeFormatInfo dtfi = new System.Globalization.DateTimeFormatInfo();
RetVal = ((DateTime)data).ToString(dtfi.SortableDateTimePattern);
break;
default:
RetVal = data.ToString();
break;
}
return (RetVal);
}
private List <UngVien> XuLyCV(XBrowser browser, JobLink job)
{
job.trang_thai_xu_ly = TrangThaiXuLy.DA_XU_LY;
List <UngVien> lst_ung_vien = new List <UngVien>();
try
{
var eles_ung_vien = browser.Find("//div[@class='col-sm-9']//form//div[@class='list-group-item-heading']");
if (eles_ung_vien.Count > 0)
{
Dictionary <string, string> dic_cv_ung_vien = new Dictionary <string, string>();
foreach (var item_ung_vien in eles_ung_vien)
{
try
{
var ho_ten_ele = browser.FindChildElement(item_ung_vien, ".//span[@class='text-accent']");
var link_cv_ele = browser.FindChildElement(item_ung_vien, ".//a");
if (ho_ten_ele != null && link_cv_ele != null)
{
string href = browser.GetAttribute(link_cv_ele, "href").Trim();
string ho_ten = browser.GetAttribute(ho_ten_ele, "innerText").Trim();
if (!dic_cv_ung_vien.ContainsKey(href))
{
dic_cv_ung_vien.Add(href, ho_ten);
}
}
}
catch (Exception)
{
}
}
foreach (var item in dic_cv_ung_vien)
{
browser.GoTo(item.Key);
UngVien ung_vien = new UngVien();
ung_vien.ngay_tao = ung_vien.ngay_sua = XMedia.XUtil.TimeInEpoch();
ung_vien.app_id = job.app_id;
ung_vien.job_link = job.link;
ung_vien.ho_ten = item.Value;
ung_vien.full_text = browser.GetPageSource();
ung_vien.vi_tri = job.ten_job;
ThongTinChungUngVien ttuv = new ThongTinChungUngVien();
ttuv.domain = UrlToDomain(item.Key);
ttuv.full_text = browser.GetInnerHtml("//div[@class='resume-show']//div[@class='media']", 200);
ttuv.full_text += browser.GetInnerHtml("//div[@id='divResumeContactInformation']", 200);
ung_vien.thong_tin_chung = ttuv;
//Bóc tách XPATH để lấy được thông tin này nếu có
ung_vien.kinh_nghiem = browser.GetInnerHtml("//h4[contains(text(),'Kinh nghiệm')]/following-sibling::dl", 200);
ung_vien.ky_nang = "";
ung_vien.hoc_van = browser.GetInnerHtml("//h4[contains(text(),'Học vấn')]/following-sibling::dl", 200);
ung_vien.email = browser.GetInnerHtml("//a[contains(@href,'mailto')]", 200);
ung_vien.so_dien_thoai = browser.GetInnerHtml("//div[@id='divResumeContactInformation']//dt[contains(text(),'Điện')]/following-sibling::dd[1]", 200);
string ngay_sinh = browser.GetInnerText("//span[@class='confidential-birth-day']", 500);
ung_vien.domain = UrlToDomain(item.Key);
ung_vien.custom_id = item.Key.Substring(item.Key.LastIndexOf("/") + 1);
ung_vien.nguoi_tao = job.nguoi_tao;
if (!string.IsNullOrEmpty(ngay_sinh))
{
//Convert ngay sinh
System.Globalization.DateTimeFormatInfo dtfi = new System.Globalization.DateTimeFormatInfo();
dtfi.ShortDatePattern = "dd/MM/yyyy";
dtfi.DateSeparator = "/";
try
{
var bird_day = Convert.ToDateTime(ngay_sinh, dtfi);
ung_vien.ngay_sinh = XMedia.XUtil.TimeInEpoch(bird_day);
}
catch (Exception)
{
}
}
var ifr = browser.FindFirst("//iframe");
if (ifr != null)
{
ung_vien.link_cv_offline = browser.DownloadByBrowserInIFrame("//iframe", "//button[@id='download']");
if (!string.IsNullOrEmpty(ung_vien.link_cv_offline))
{
ung_vien.cv_byte = File.ReadAllBytes($"{cv_save_path}\\{ung_vien.link_cv_offline}");
}
}
lst_ung_vien.Add(ung_vien);
}
}
else
{
job.thong_tin_xu_ly = Common.KHONG_TIM_THAY_UNG_VIEN;
}
}
catch (Exception ex)
{
job.trang_thai_xu_ly = TrangThaiXuLy.LOI;
job.thong_tin_xu_ly = ex.Message;
}
job.ngay_xu_ly = XMedia.XUtil.TimeInEpoch();
return(lst_ung_vien);
}
protected override void Render(HtmlTextWriter writer)
{
try
{
DateTime tmpDate;
try
{
tmpDate = this.SelectedDate == "" ? DateTime.Now : Convert.ToDateTime(SelectedDate);
}
catch (Exception ex)
{
tmpDate = DateTime.Now;
}
string temp = CssClass;
CssClass = "";
if (temp == "")
{
temp = "ampicker";
}
writer.AddAttribute(HtmlTextWriterAttribute.Cellpadding, "0");
writer.AddAttribute(HtmlTextWriterAttribute.Cellspacing, "0");
writer.AddAttribute(HtmlTextWriterAttribute.Width, Width.ToString());
writer.RenderBeginTag(HtmlTextWriterTag.Table);
writer.RenderBeginTag(HtmlTextWriterTag.Tr);
if (Text != "")
{
writer.AddAttribute(HtmlTextWriterAttribute.Style, "white-space:nowrap");
writer.RenderBeginTag(HtmlTextWriterTag.Td);
writer.Write(Text);
writer.RenderEndTag();
}
writer.AddAttribute(HtmlTextWriterAttribute.Width, Width.ToString());
writer.RenderBeginTag(HtmlTextWriterTag.Td);
writer.AddAttribute("class", temp);
writer.AddAttribute("id", ClientID);
writer.AddAttribute("name", ClientID);
writer.AddAttribute("onblur", "return window." + ClientID + ".onblur(this);");
writer.AddAttribute("onkeypress", "return window." + ClientID + ".onlyDateChars(event);");
//writer.AddAttribute("onkeydown", "return window." & Me.ClientID & ".KeyPress(event);")
//writer.AddAttribute("onclick", "return window." & Me.ClientID & ".Click(event);showalert();")
if (Enabled == false)
{
writer.AddAttribute("disabled", "disabled");
}
if (ShowDateBox)
{
writer.RenderBeginTag(HtmlTextWriterTag.Input);
writer.RenderEndTag();
}
dtFI = Thread.CurrentThread.CurrentCulture.DateTimeFormat;
if (!(string.IsNullOrEmpty(SelectedDate)))
{
DateTime dte = DateTime.Parse(SelectedDate);
SelectedDate = dte.ToString(dtFI.ShortDatePattern + " " + dtFI.ShortTimePattern);
}
writer.AddAttribute("type", "hidden");
writer.AddAttribute("id", "hid_" + ClientID);
writer.AddAttribute("name", "hid_" + ClientID);
writer.AddAttribute("value", SelectedDate);
writer.RenderBeginTag(HtmlTextWriterTag.Input);
writer.RenderEndTag();
writer.AddAttribute("id", "cal_" + ClientID);
writer.AddAttribute("style", "display:none;position:absolute;");
writer.RenderBeginTag(HtmlTextWriterTag.Div);
writer.RenderEndTag();
writer.RenderEndTag();
writer.RenderBeginTag(HtmlTextWriterTag.Td);
if (ImageUrl == string.Empty)
{
ImageUrl = Page.ClientScript.GetWebResourceUrl(GetType(), "DotNetNuke.Modules.ActiveForums.CustomControls.Resources.calendar.gif");
}
if (Enabled)
{
writer.AddAttribute("src", ImageUrl);
writer.AddAttribute("onclick", "window." + ClientID + ".Toggle(event);");
writer.AddAttribute("id", "img_" + ClientID);
writer.RenderBeginTag(HtmlTextWriterTag.Img);
writer.RenderEndTag();
}
writer.RenderEndTag();
writer.RenderEndTag();
writer.RenderEndTag();
var str = new StringBuilder();
str.Append("<script type=\"text/javascript\">");
cal = new System.Globalization.GregorianCalendar();
if (Thread.CurrentThread.CurrentCulture != null)
{
cal = Thread.CurrentThread.CurrentCulture.Calendar;
}
DateFormat = dtFI.ShortDatePattern;
TimeFormat = dtFI.ShortTimePattern;
str.Append("window." + ClientID + "=new asDatePicker('" + ClientID + "');");
str.Append("window." + ClientID + ".Locale='" + Context.Request.UserLanguages[0].Substring(0, 2).ToUpper() + "';");
str.Append("window." + ClientID + ".SelectedDate='" + SelectedDate + "';");
str.Append("window." + ClientID + ".Width='" + CalendarWidth + "';");
str.Append("window." + ClientID + ".Height='" + CalendarHeight + "';");
str.Append("window." + ClientID + ".DateFormat='" + dtFI.ShortDatePattern + "';");
str.Append("window." + ClientID + ".TimeFormat='" + dtFI.ShortTimePattern + "';");
str.Append("window." + ClientID + ".Year=" + tmpDate.Year + ";");
str.Append("window." + ClientID + ".Month=" + (tmpDate.Month - 1) + ";");
str.Append("window." + ClientID + ".Day=" + tmpDate.Day + ";");
str.Append("window." + ClientID + ".SelectedYear=" + tmpDate.Year + ";");
str.Append("window." + ClientID + ".SelectedMonth=" + (tmpDate.Month - 1) + ";");
str.Append("window." + ClientID + ".SelectedDay=" + tmpDate.Day + ";");
str.Append("window." + ClientID + ".ShowTime=" + ShowTime.ToString().ToLower() + ";");
str.Append("window." + ClientID + ".DefaultTime='" + DefaultTime + "';");
str.Append("window." + ClientID + ".CallbackFlag='" + CallbackFlag + "';");
if (!(string.IsNullOrEmpty(RelatedControl)))
{
Control ctl = Parent.FindControl(RelatedControl);
if (ctl == null)
{
ctl = Page.FindControl(RelatedControl);
}
if (ctl == null)
{
RelatedControl = string.Empty;
}
else
{
RelatedControl = ctl.ClientID;
}
}
str.Append("window." + ClientID + ".linkedControl='" + RelatedControl + "';");
if (IsEndDate)
{
str.Append("window." + ClientID + ".isEndDate=true;");
}
else
{
str.Append("window." + ClientID + ".isEndDate=false;");
}
string sTime = string.Empty;
SelectedTime = tmpDate.ToString(TimeFormat);
if (ShowTime)
{
if (SelectedTime != "12:00 AM")
{
sTime = SelectedTime;
}
if (TimeRequired)
{
str.Append("window." + ClientID + ".RequireTime=true;");
}
else
{
str.Append("window." + ClientID + ".RequireTime=false;");
}
}
else
{
str.Append("window." + ClientID + ".RequireTime=false;");
}
str.Append("window." + ClientID + ".SelectedTime='" + sTime + "';");
if (string.IsNullOrEmpty(ImgNext))
{
str.Append("window." + ClientID + ".ImgNext='" + Page.ClientScript.GetWebResourceUrl(GetType(), "DotNetNuke.Modules.ActiveForums.CustomControls.Resources.cal_nextMonth.gif") + "';");
}
else
{
str.Append("window." + ClientID + ".ImgNext='" + Page.ResolveUrl(ImgNext) + "';");
}
if (string.IsNullOrEmpty(ImgPrev) )
{
str.Append("window." + ClientID + ".ImgPrev='" + Page.ClientScript.GetWebResourceUrl(GetType(), "DotNetNuke.Modules.ActiveForums.CustomControls.Resources.cal_prevMonth.gif") + "';");
}
else
{
str.Append("window." + ClientID + ".ImgPrev='" + Page.ResolveUrl(ImgPrev) + "';");
}
if (SelectedDate != "")
{
try
{
if (ShowTime == false && sTime == string.Empty)
{
str.Append("window." + ClientID + ".textbox.value=new Date(" + tmpDate.Year + "," + (tmpDate.Month - 1) + "," + tmpDate.Day + ").formatDP('" + DateFormat + "','" + ClientID + "');");
str.Append("window." + ClientID + ".dateSel = new Date(" + tmpDate.Year + "," + (tmpDate.Month - 1) + "," + tmpDate.Day + ",0,0,0,0);");
}
else
{
str.Append("window." + ClientID + ".textbox.value=new Date(" + tmpDate.Year + "," + (tmpDate.Month - 1) + "," + tmpDate.Day + "," + tmpDate.Hour + "," + tmpDate.Minute + ",0).formatDP('" + DateFormat + " " + TimeFormat + "','" + ClientID + "');");
str.Append("window." + ClientID + ".dateSel = new Date(" + tmpDate.Year + "," + (tmpDate.Month - 1) + "," + tmpDate.Day + "," + tmpDate.Hour + "," + tmpDate.Minute + ",0);");
}
}
catch (Exception ex)
{
}
}
int xMonths = cal.GetMonthsInYear(cal.GetYear(tmpDate), cal.GetEra(tmpDate));
int currMonth = cal.GetMonth(tmpDate);
int currYear = cal.GetYear(tmpDate);
int currDay = cal.GetDayOfMonth(tmpDate);
str.Append("window." + ClientID + ".MonthDays = new Array(");
for (int i = 0; i < xMonths; i++)
{
str.Append(cal.GetDaysInMonth(currYear, i + 1));
if (i < (xMonths - 1))
{
str.Append(",");
}
}
str.Append(");");
str.AppendLine();
string[] mNames = dtFI.MonthNames;
str.Append("window." + ClientID + ".MonthNames = new Array(");
for (int i = 0; i < xMonths; i++)
{
str.Append("'" + mNames[i] + "'");
if (i < (xMonths - 1))
{
str.Append(",");
}
}
str.Append(");");
str.AppendLine();
str.Append("window." + ClientID + ".ShortMonthNames = new Array(");
string[] mAbbr = dtFI.AbbreviatedMonthNames;
for (int i = 0; i < xMonths; i++)
{
str.Append("'" + mAbbr[i] + "'");
if (i < (xMonths - 1))
{
str.Append(",");
}
}
str.Append(");");
str.AppendLine();
str.Append("window." + ClientID + ".ShortDayNames = new Array(");
string[] dAbbr = dtFI.AbbreviatedDayNames;
for (int i = 0; i <= 6; i++)
{
str.Append("'" + dAbbr[i] + "'");
if (i < 6)
{
str.Append(",");
}
}
str.Append(");");
str.AppendLine();
str.Append("window." + ClientID + ".Class={");
str.Append("CssCalendarStyle:'" + CssCalendarStyle + "',");
str.Append("CssMonthStyle:'" + CssMonthStyle + "',");
str.Append("CssWeekendStyle:'" + CssWeekendStyle + "',");
str.Append("CssWeekdayStyle:'" + CssWeekdayStyle + "',");
str.Append("CssSelectedDayStyle:'" + CssSelectedDayStyle + "',");
str.Append("CssCurrentMonthDayStyle:'" + CssCurrentMonthDayStyle + "',");
str.Append("CssOtherMonthDayStyle:'" + CssOtherMonthDayStyle + "',");
str.Append("CssDayHeaderStyle:'" + CssDayHeaderStyle + "',");
str.Append("CssCurrentDayStyle:'" + CssCurrentDayStyle + "'};");
str.Append("window." + ClientID + ".selectedDate=window." + ClientID + ".textbox.value;");
str.Append("window." + ClientID + ".timeLabel='[RESX:Time]';");
str.Append("</script>");
writer.Write(str);
}
catch (Exception ex)
{
}
}
public void Report()
{
string selectedServer = "";
string date;
/*
* if (this.ServerListFilterComboBox.SelectedIndex >= 0)
* {
* selectedServer = this.ServerListFilterComboBox.SelectedItem.Value.ToString();
* }
*/
if (this.ServerListFilterListBox.SelectedItems.Count > 0)
{
selectedServer = "";
for (int i = 0; i < this.ServerListFilterListBox.SelectedItems.Count; i++)
{
selectedServer += "'" + this.ServerListFilterListBox.SelectedItems[i].Text + "'" + ",";
}
try
{
selectedServer = selectedServer.Substring(0, selectedServer.Length - 1);
}
catch
{
selectedServer = ""; // throw ex;
}
finally { }
}
//10/22/2013 NS modified - added jQuery month/year control
/*
* if (this.DateParamEdit.Text == "")
* {
* date = DateTime.Now.ToString();
* }
* else
* {
* date = this.DateParamEdit.Value.ToString();
* }
*/
if (startDate.Value.ToString() == "")
{
date = DateTime.Now.ToString();
}
else
{
date = startDate.Value.ToString();
}
//2/2/2015 NS added for VSPLUS-1370
if (this.ServerTypeFilterListBox.SelectedItems.Count > 0)
{
selectedType = "";
for (int i = 0; i < this.ServerTypeFilterListBox.SelectedItems.Count; i++)
{
selectedType += "'" + this.ServerTypeFilterListBox.SelectedItems[i].Text + "'" + ",";
}
try
{
selectedType = selectedType.Substring(0, selectedType.Length - 1);
}
catch
{
selectedType = ""; // throw ex;
}
finally { }
}
DateTime dt = Convert.ToDateTime(date);
DashboardReports.DailyMemoryUsedXtraRpt report = new DashboardReports.DailyMemoryUsedXtraRpt();
report.Parameters["DateM"].Value = dt.Month;
report.Parameters["DateY"].Value = dt.Year;
System.Globalization.DateTimeFormatInfo mfi = new System.Globalization.DateTimeFormatInfo();
string strMonthName = mfi.GetMonthName(dt.Month).ToString() + ", " + dt.Year.ToString();
report.Parameters["MonthYear"].Value = strMonthName;
report.Parameters["ServerName"].Value = selectedServer;
//2/2/2015 NS added for VSPLUS-1370
report.Parameters["ServerType"].Value = selectedType;
this.ReportViewer1.Report = report;
this.ReportViewer1.DataBind();
}