public Boolean updateCustomerGroup(accountgroup agroup) { Boolean status = true; string utString = ""; try { string updateSQL = "update AccountGroup set " + "GroupDescription = " + "'" + agroup.GroupDescription + "'" + " where GroupLevel = " + agroup.GroupLevel + " and GroupCode = '" + agroup.GroupCode + "'"; utString = utString + updateSQL + Main.QueryDelimiter; utString = utString + ActivityLogDB.PrepareActivityLogQquerString("update", "AccountGroup", "", 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 <accountgroup> getAccountGroupDetails(int lvl) { accountgroup agroup; List <accountgroup> accountGroupList = new List <accountgroup>(); try { string query = "select GroupLevel,GroupCode, GroupDescription, CreateTime, CreateUser " + " from AccountGroup where GroupLevel = " + lvl; SqlConnection conn = new SqlConnection(Login.connString); SqlCommand cmd = new SqlCommand(query, conn); conn.Open(); SqlDataReader reader = cmd.ExecuteReader(); while (reader.Read()) { agroup = new accountgroup(); agroup.GroupLevel = reader.GetInt32(0); agroup.GroupCode = reader.GetString(1); agroup.GroupDescription = reader.GetString(2); agroup.CreateTime = reader.GetDateTime(3); agroup.CreateUser = reader.GetString(4); accountGroupList.Add(agroup); } conn.Close(); } catch (Exception ex) { MessageBox.Show(this.ToString() + "-" + System.Reflection.MethodBase.GetCurrentMethod().Name + "() : Error"); } return(accountGroupList); }
public Boolean insertAccountGroup(accountgroup agroup) { Boolean status = true; string utString = ""; try { string updateSQL = "insert into AccountGroup " + "(Grouplevel,GroupCode,GroupDescription,CreateTime,CreateUser) " + "values ('" + agroup.GroupLevel + "','" + agroup.GroupCode + "','" + agroup.GroupDescription + "'," + "GETDATE()" + ",'" + Login.userLoggedIn + "')"; utString = utString + updateSQL + Main.QueryDelimiter; utString = utString + ActivityLogDB.PrepareActivityLogQquerString("insert", "AccountGroup", "", 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 validateCustomerGroup(accountgroup sg) { Boolean status = true; try { if ((sg.GroupCode.Trim().Length == 0) || (sg.GroupCode == null)) { status = false; } if ((sg.GroupDescription.Trim().Length == 0) || (sg.GroupDescription == null)) { status = false; } } catch (Exception ex) { MessageBox.Show(this.ToString() + "-" + System.Reflection.MethodBase.GetCurrentMethod().Name + "() : Error"); status = false; } return(status); }