public List <cmpnydetails> getdetails() { cmpnydetails det; List <cmpnydetails> Details = new List <cmpnydetails>(); try { SqlConnection conn = new SqlConnection(Login.connString); string query = "select CompanyID, CompanyName,Address,Status " + "from CompanyDetail order by CompanyID"; SqlCommand cmd = new SqlCommand(query, conn); conn.Open(); SqlDataReader reader = cmd.ExecuteReader(); while (reader.Read()) { det = new cmpnydetails(); det.companyID = reader.GetInt32(0); det.companyname = reader.GetString(1); det.companyAddress = reader.GetString(2); det.status = reader.GetInt32(3); Details.Add(det); } conn.Close(); } catch (Exception ex) { MessageBox.Show(this.ToString() + "-" + System.Reflection.MethodBase.GetCurrentMethod().Name + "() : Error"); } return(Details); }
public Boolean insertdetails(cmpnydetails det) { Boolean status = true; string utString = ""; try { string updateSQL = "insert into CompanyDetail (CompanyID,CompanyName,Address,Status)" + "values (" + "'" + det.companyID + "'," + "'" + det.companyname + "'," + "'" + det.companyAddress + "'," + "'" + det.status + "'" + ")"; utString = utString + updateSQL + Main.QueryDelimiter; utString = utString + ActivityLogDB.PrepareActivityLogQquerString("insert", "CompanyDetail", "", 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 validatedetails(cmpnydetails det) { Boolean status = true; try { if (/*bool hasAllwhitespace =*/ det.companyAddress.Trim().Length == 0 || det.companyAddress == null) { return(false); } if (det.companyname.Trim().Length == 0 || det.companyname == null) { return(false); } if (det.companyID.ToString().Length == 0) { return(false); } } catch (Exception ex) { MessageBox.Show(this.ToString() + "-" + System.Reflection.MethodBase.GetCurrentMethod().Name + "() : Error"); } return(status); }