public Boolean updateSEFCheckList(sefcheck flim) { Boolean status = true; string utString = ""; try { string updateSQL = "update SEFCheckList set SequenceNo='" + flim.Sequenceno + "', Description = '" + flim.description + "'," + " Status='" + flim.Status + "'" + " where RowID='" + flim.rowid + "'"; utString = utString + updateSQL + Main.QueryDelimiter; utString = utString + ActivityLogDB.PrepareActivityLogQquerString("update", "SEFCheckList", "", updateSQL) + Main.QueryDelimiter; if (!UpdateTable.UT(utString)) { status = false; } } catch (Exception ex) { MessageBox.Show(this.ToString() + "-" + System.Reflection.MethodBase.GetCurrentMethod().Name + "() : Error"); status = false; } return(status); }
//ActivityLogDB alDB = new ActivityLogDB(); public List <sefcheck> getSEFCheckList(string sefid) { sefcheck flim; List <sefcheck> fLimList = new List <sefcheck>(); try { SqlConnection conn = new SqlConnection(Login.connString); string query = "select RowID,SEFID,SequenceNo,Description,Status,CreateUser" + ",CreateTime from SEFCheckList where SEFID='" + sefid + "' order by SequenceNo"; SqlCommand cmd = new SqlCommand(query, conn); conn.Open(); SqlDataReader reader = cmd.ExecuteReader(); while (reader.Read()) { flim = new sefcheck(); flim.rowid = reader.GetInt32(0); flim.SEFID = reader.GetString(1); flim.Sequenceno = reader.GetInt32(2); flim.description = reader.GetString(3); flim.Status = reader.GetInt32(4); flim.userCreateUser = reader.GetString(5); flim.userCreateime = reader.GetDateTime(6); fLimList.Add(flim); } conn.Close(); } catch (Exception ex) { MessageBox.Show(this.ToString() + "-" + System.Reflection.MethodBase.GetCurrentMethod().Name + "() : Error"); } return(fLimList); }
////////public Boolean checkEmployeeFinancialLimit(string docID, string empID, double ProductValue, double TaxAmount) ////////{ //////// Boolean status = false; //////// double amt = 0; //////// try //////// { //////// SqlConnection conn = new SqlConnection(Login.connString); //////// string query = "select FinancialLimit " + //////// "from EmployeeFinancialLimit where DocumentID='" + docID + "' and EmployeeID='" + empID + "' and Status=1"; //////// SqlCommand cmd = new SqlCommand(query, conn); //////// conn.Open(); //////// SqlDataReader reader = cmd.ExecuteReader(); //////// if (reader.Read()) //////// { //////// amt = reader.GetDouble(0); //////// } //////// conn.Close(); //////// if (amt >= ProductValue) //////// { //////// status = true; //////// } //////// } //////// catch (Exception ex) //////// { //////// MessageBox.Show(this.ToString() + "-" + System.Reflection.MethodBase.GetCurrentMethod().Name + "() : Error"); //////// status = false; //////// } //////// return status; ////////} public Boolean insertSefChecklist(sefcheck flim) { Boolean status = true; string utString = ""; try { DateTime cdt = DateTime.Now; string updateSQL = "insert into SEFCheckList (SEFID,SequenceNo,Description,Status,CreateTime,CreateUser)" + "values (" + "'" + flim.SEFID + "'," + "'" + flim.Sequenceno + "','" + flim.description + "','" + flim.Status + "'," + "GETDATE()" + "," + "'" + Login.userLoggedIn + "'" + ")"; utString = utString + updateSQL + Main.QueryDelimiter; utString = utString + ActivityLogDB.PrepareActivityLogQquerString("insert", "SEFCheckList", "", updateSQL) + Main.QueryDelimiter; if (!UpdateTable.UT(utString)) { status = false; } } catch (Exception ex) { MessageBox.Show(this.ToString() + "-" + System.Reflection.MethodBase.GetCurrentMethod().Name + "() : Error"); status = false; } return(status); }
public Boolean validateSEFChecklist(sefcheck flim) { Boolean status = true; try { if (flim.description.Trim().Length == 0 || flim.description == null) { return(false); } if (flim.Status == 0) { return(false); } } catch (Exception ex) { MessageBox.Show(this.ToString() + "-" + System.Reflection.MethodBase.GetCurrentMethod().Name + "() : Error"); } return(status); }