public Boolean updateDocEmpMapping(docempmapping doc, docempmapping prevdoc) { Boolean status = true; string utString = ""; try { string updateSQL = "update DocEmpMapping set EmployeeID='" + doc.EmployeeID + "'," + "SeniorEmployeeID='" + doc.SeniorEmployeeID + "'," + " Status=" + doc.DocumentStatus + " where DocumentID='" + prevdoc.DocumentID + "'" + " and EmployeeID='" + prevdoc.EmployeeID + "'" + " and SeniorEmployeeID='" + prevdoc.SeniorEmployeeID + "'"; utString = utString + updateSQL + Main.QueryDelimiter; utString = utString + ActivityLogDB.PrepareActivityLogQquerString("update", "DocEmpMapping", "", 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 validateDocument(docempmapping doc) { Boolean status = true; try { if (doc.DocumentID.Trim().Length == 0 || doc.DocumentID == null) { return(false); } if (doc.EmployeeID.Trim().Length == 0 || doc.EmployeeID == null) { return(false); } if (doc.SeniorEmployeeID.Trim().Length == 0 || doc.SeniorEmployeeID == null || doc.EmployeeID.Trim() == doc.SeniorEmployeeID.Trim()) { return(false); } } catch (Exception ex) { MessageBox.Show(this.ToString() + "-" + System.Reflection.MethodBase.GetCurrentMethod().Name + "() : Error"); } return(status); }
public Boolean insertDocEmpMapping(docempmapping doc) { Boolean status = true; string utString = ""; try { DateTime cdt = DateTime.Now; string updateSQL = "insert into DocEmpMapping (DocumentID,EmployeeID,SeniorEmployeeID,Status,CreateTime,CreateUser)" + "values (" + "'" + doc.DocumentID + "'," + "'" + doc.EmployeeID + "'," + "'" + doc.SeniorEmployeeID + "'," + doc.DocumentStatus + "," + "GETDATE()" + "," + "'" + Login.userLoggedIn + "'" + ")"; utString = utString + updateSQL + Main.QueryDelimiter; utString = utString + ActivityLogDB.PrepareActivityLogQquerString("insert", "DocEmpMapping", "", 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 List <docempmapping> getDocEmpMapping() { docempmapping docempmappingrec; List <docempmapping> DocEmpMappings = new List <docempmapping>(); try { SqlConnection conn = new SqlConnection(Login.connString); string query = "select a.DocumentID, b.DocumentName,a.EmployeeID,c.Name, a.SeniorEmployeeID," + "d.Name, a.status from DocEmpMapping a, Document b, " + "Employee c, Employee d where a.DocumentID=b.DocumentID and " + "a.EmployeeID=c.EmployeeID and a.SeniorEmployeeID=d.EmployeeID " + "order by a.DocumentID,c.Name"; SqlCommand cmd = new SqlCommand(query, conn); conn.Open(); SqlDataReader reader = cmd.ExecuteReader(); while (reader.Read()) { docempmappingrec = new docempmapping(); docempmappingrec.DocumentID = reader.GetString(0); docempmappingrec.DocumentName = reader.GetString(1); docempmappingrec.EmployeeID = reader.GetString(2); docempmappingrec.EmployeeName = reader.GetString(3); docempmappingrec.SeniorEmployeeID = reader.GetString(4); docempmappingrec.SeniorEmployeeName = reader.GetString(5); docempmappingrec.DocumentStatus = reader.GetInt32(6); DocEmpMappings.Add(docempmappingrec); } conn.Close(); } catch (Exception) { MessageBox.Show(this.ToString() + "-" + System.Reflection.MethodBase.GetCurrentMethod().Name + "() : Error"); } return(DocEmpMappings); }