public List <string> validateOfficeWDforHW(HolidayList ofhw) { string offc = ""; List <string> offlist = new List <string>(); try { string[] office = ofhw.officeID.Split(Main.delimiter1); foreach (string ofce in office) { if (ofce != "") { string query = "select Description from HolidayList where Date='" + ofhw.date.ToString("yyyy-MM-dd") + "' and officeIDs like '%" + ofce + "%'"; SqlConnection conn = new SqlConnection(Login.connString); SqlCommand cmd = new SqlCommand(query, conn); conn.Open(); SqlDataReader reader = cmd.ExecuteReader(); if (!reader.Read()) { offc = ofce; } conn.Close(); if (offc != "") { offlist.Add(offc); } } } } catch (Exception ex) { MessageBox.Show("validateOfficeWDforHW Error!!!"); } return(offlist); }
public Boolean ValidateOfficeHW(HolidayList Ofc) { //Regex r = new Regex("[a-zA-Z]"); Boolean stat = true; try { if (Ofc.Type == "" || Ofc.Type.Trim().Length == 0) { stat = false; } if (Ofc.Description == "" || Ofc.Description.Trim().Length == 0) { stat = false; } if (Ofc.officeID == "" || Ofc.officeID.Trim().Length == 0) { stat = false; } } catch (Exception ex) { } return(stat); }
public Boolean InsertLeaveOfficeWO(HolidayList ofh) { Boolean status = true; string utString = ""; try { string updateSQL = "insert into OfficeWeekOff (officeID,Weekoffs)" + "values (" + "'" + ofh.officeID + "','" + ofh.Weekoffs + "')"; utString = utString + updateSQL + Main.QueryDelimiter; utString = utString + ActivityLogDB.PrepareActivityLogQquerString("insert", "OfficeWeekOff", "", updateSQL) + Main.QueryDelimiter; if (!UpdateTable.UT(utString)) { status = false; } } catch (Exception) { MessageBox.Show(this.ToString() + "-" + System.Reflection.MethodBase.GetCurrentMethod().Name + "() : Error"); status = false; } return(status); }
public Boolean InsertLeaveOfficeHW(HolidayList ofh) { Boolean status = true; string utString = ""; try { string updateSQL = "insert into HolidayList (Type,Date,officeIDs,Description)" + "values (" + "'" + ofh.Type + "'," + "'" + ofh.date.ToString("yyyy-MM-dd") + "','" + ofh.officeID + "','" + ofh.Description + "')"; utString = utString + updateSQL + Main.QueryDelimiter; utString = utString + ActivityLogDB.PrepareActivityLogQquerString("insert", "HolidayList", "", updateSQL) + Main.QueryDelimiter; if (!UpdateTable.UT(utString)) { status = false; } } catch (Exception) { MessageBox.Show(this.ToString() + "-" + System.Reflection.MethodBase.GetCurrentMethod().Name + "() : Error"); status = false; } return(status); }
public Boolean UpdateOfficeWO(HolidayList Ofw) { Boolean status = true; string utString = ""; try { string updateSQL = "Update OfficeWeekOff set WeekOffs='" + Ofw.Weekoffs + "'" + " where OfficeID='" + Ofw.officeID + "' and RowID='" + Ofw.RowID + "'"; utString = utString + updateSQL + Main.QueryDelimiter; utString = utString + ActivityLogDB.PrepareActivityLogQquerString("update", "OfficeWeekOff", "", updateSQL) + Main.QueryDelimiter; if (!UpdateTable.UT(utString)) { status = false; } } catch (Exception) { MessageBox.Show(this.ToString() + "-" + System.Reflection.MethodBase.GetCurrentMethod().Name + "() : Error"); status = false; } return(status); }
public Boolean UpdateOfficeHW(HolidayList Ofw) { Boolean status = true; string utString = ""; try { string updateSQL = "Update HolidayList set Description='" + Ofw.Description + "',officeIDs='" + Ofw.officeID + "'," + " Date='" + Ofw.date.ToString("yyyy-MM-dd") + "' where RowID='" + Ofw.RowID + "'"; utString = utString + updateSQL + Main.QueryDelimiter; utString = utString + ActivityLogDB.PrepareActivityLogQquerString("update", "HolidayList", "", updateSQL) + Main.QueryDelimiter; if (!UpdateTable.UT(utString)) { status = false; } } catch (Exception) { MessageBox.Show(this.ToString() + "-" + System.Reflection.MethodBase.GetCurrentMethod().Name + "() : Error"); status = false; } return(status); }
public List <HolidayList> getOfficeWD() { HolidayList Wdlist; List <HolidayList> OfficeWDList = new List <HolidayList>(); try { string query = "select RowID,Type,Date,officeID,Description from OfficeWorkingDay where datepart(yyyy,Date)='" + UpdateTable.getSQLDateTime().Year + "' "; SqlConnection conn = new SqlConnection(Login.connString); SqlCommand cmd = new SqlCommand(query, conn); conn.Open(); SqlDataReader reader = cmd.ExecuteReader(); while (reader.Read()) { Wdlist = new HolidayList(); Wdlist.RowID = reader.GetInt32(0); Wdlist.Type = reader.GetString(1); Wdlist.date = reader.GetDateTime(2); Wdlist.officeID = reader.GetString(3); Wdlist.Description = reader.GetString(4); OfficeWDList.Add(Wdlist); } conn.Close(); } catch (Exception ex) { MessageBox.Show(System.Reflection.MethodBase.GetCurrentMethod().Name + "() : Error"); } return(OfficeWDList); }
public List <HolidayList> getOfficeWO() { HolidayList WOlist; List <HolidayList> OfficeWOList = new List <HolidayList>(); try { string query = "select RowID,OfficeID,Weekoffs from OfficeWeekOff "; SqlConnection conn = new SqlConnection(Login.connString); SqlCommand cmd = new SqlCommand(query, conn); conn.Open(); SqlDataReader reader = cmd.ExecuteReader(); while (reader.Read()) { WOlist = new HolidayList(); WOlist.RowID = reader.GetInt32(0); WOlist.officeID = reader.GetString(1); WOlist.Weekoffs = reader.GetString(2); OfficeWOList.Add(WOlist); } conn.Close(); } catch (Exception ex) { MessageBox.Show(System.Reflection.MethodBase.GetCurrentMethod().Name + "() : Error"); } return(OfficeWOList); }
//public Boolean validateOfficeWDforHW(officehw ofhw) //{ // int count = 0; // Boolean status = false; // try // { // string query = "select Description from OfficeHW where Date='" + ofhw.date.ToString("yyyy-MM-dd") + "'"; // SqlConnection conn = new SqlConnection(Login.connString); // SqlCommand cmd = new SqlCommand(query, conn); // conn.Open(); // SqlDataReader reader = cmd.ExecuteReader(); // if (reader.Read()) // { // status = true; // } // conn.Close(); // } // catch (Exception ex) // { // status = false; // } // return status; //} public List <string> validateOfficeWDforWO(HolidayList ofhw) { string offc = ""; List <string> offlist = new List <string>(); try { string[] office = ofhw.officeID.Split(Main.delimiter1); foreach (string ofce in office) { if (ofce != "") { string query = "select Weekoffs from OfficeWeekOff where OfficeID='" + ofce + "'"; SqlConnection conn = new SqlConnection(Login.connString); SqlCommand cmd = new SqlCommand(query, conn); conn.Open(); SqlDataReader reader = cmd.ExecuteReader(); if (reader.Read()) { List <DateTime> allweekenddate = GetAllweekends(UpdateTable.getSQLDateTime().Year, reader.GetString(0)); if (!allweekenddate.Contains(ofhw.date.Date)) { offc = ofce; } } else { offc = ofce; } conn.Close(); if (offc != "") { offlist.Add(offc); } } } } catch (Exception ex) { MessageBox.Show("validateOfficeWDforWO Error!!!"); } return(offlist); }
public Boolean validateOfficeWD(HolidayList ofhw) { int count = 0; Boolean status = true; try { string query = "select Description from OfficeWorkingDay where Type='" + ofhw.Type + "' and Date='" + ofhw.date.ToString("yyyy-MM-dd") + "'"; SqlConnection conn = new SqlConnection(Login.connString); SqlCommand cmd = new SqlCommand(query, conn); conn.Open(); SqlDataReader reader = cmd.ExecuteReader(); if (reader.Read()) { status = false; } conn.Close(); } catch (Exception ex) { status = false; } return(status); }
public Boolean validateOfficeWO(HolidayList ofhw) { int count = 0; Boolean status = true; try { string query = "select WeekOffs from OfficeWeekOff where OfficeID='" + ofhw.officeID + "'"; SqlConnection conn = new SqlConnection(Login.connString); SqlCommand cmd = new SqlCommand(query, conn); conn.Open(); SqlDataReader reader = cmd.ExecuteReader(); if (reader.Read()) { status = false; } conn.Close(); } catch (Exception ex) { status = false; } return(status); }