public List <companybank> getBranch(string bank) { companybank det; List <companybank> Details = new List <companybank>(); try { SqlConnection conn = new SqlConnection(Login.connString); string query = "select RowID, BranchName " + "from BankBranch where BankID='" + bank + "' and Status = 1 order by RowID"; SqlCommand cmd = new SqlCommand(query, conn); conn.Open(); SqlDataReader reader = cmd.ExecuteReader(); while (reader.Read()) { det = new companybank(); det.RowID = reader.GetInt32(0); det.BranchName = reader.GetString(1); Details.Add(det); } conn.Close(); } catch (Exception ex) { } return(Details); }
public static companybank getCompBankDetailForIOPrint(int CompbankRowID) { companybank ca = new companybank(); try { SqlConnection conn = new SqlConnection(Login.connString); string query = "select b.CompanyName,c.BankID,e.Description,c.BranchName,d.Description,a.AccountCode ,c.IFSCCode,c.SWIFTCode " + "from CompanyBank a, CompanyDetail b , BankBranch c , CatalogueValue d, CatalogueValue e " + "where a.CompanyID = b.CompanyID and a.BranchID = c.RowID and " + " a.AccountType = d.CatalogueValueID and c.BankID = e.CatalogueValueID and a.RowID = " + CompbankRowID; SqlCommand cmd = new SqlCommand(query, conn); conn.Open(); SqlDataReader reader = cmd.ExecuteReader(); while (reader.Read()) { ca.CompanyName = reader.GetString(0); ca.BankID = reader.GetString(1); ca.BankName = reader.GetString(2); ca.BranchName = reader.GetString(3); ca.AccountType = reader.GetString(4); ca.AccountCode = reader.GetString(5); ca.CreateUser = reader.IsDBNull(6) ? "":reader.GetString(6); // For IFSC Code ca.CompanyID = reader.IsDBNull(7) ? "" : reader.GetString(7); // for SWIFT Code } conn.Close(); } catch (Exception ex) { MessageBox.Show("Error querying Company Bank"); } return(ca); }
public Boolean validateCompanyBank(companybank ca) { Boolean status = true; try { if (ca.CompanyID.Trim().Length == 0 || ca.CompanyID == null) { return(false); } if (ca.BranchName.Trim().Length == 0 || ca.BranchName == null) { return(false); } if (ca.AccountType.Trim().Length == 0 || ca.AccountType == null) { return(false); } if (ca.AccountCode.Trim().Length == 0 || ca.AccountCode == null) { return(false); } } catch (Exception) { } return(status); }
public Boolean insertCompBank(companybank ca) { Boolean status = true; string utString = ""; try { string updateSQL = "insert into CompanyBank (CompanyID,BranchID,AccountType," + "AccountCode,Status,CreateTime,CreateUser)" + " values (" + ca.CompanyID + "," + ca.BranchName + "," + "'" + ca.AccountType + "','" + ca.AccountCode + "'," + ca.Status + "," + "GETDATE()" + "," + "'" + Login.userLoggedIn + "'" + ")"; utString = utString + updateSQL + Main.QueryDelimiter; utString = utString + ActivityLogDB.PrepareActivityLogQquerString("insert", "CompanyBank", "", updateSQL) + Main.QueryDelimiter; if (!UpdateTable.UT(utString)) { status = false; } } catch (Exception) { status = false; } return(status); }
public Boolean updateCompBAnk(companybank ca) { Boolean status = true; string utString = ""; try { string updateSQL = "update CompanyBank set BranchID = " + ca.BranchName + " ,AccountType = '" + ca.AccountType + "',AccountCode='" + ca.AccountCode + "',Status=" + ca.Status + " where RowID=" + ca.RowID; utString = utString + updateSQL + Main.QueryDelimiter; utString = utString + ActivityLogDB.PrepareActivityLogQquerString("update", "CompanyBank", "", updateSQL) + Main.QueryDelimiter; if (!UpdateTable.UT(utString)) { status = false; } } catch (Exception) { status = false; } return(status); }
public List <companybank> getCompBankListForIO(int compID) { companybank ca; List <companybank> AddList = new List <companybank>(); try { SqlConnection conn = new SqlConnection(Login.connString); string query = "select a.CompanyID,e.CompanyName,b.BankID,b.BranchName, a.AccountType , " + "a.AccountCode,a.CreateUser,a.CreateTime,a.RowID,a.BranchID,a.Status from CompanyBank a," + " BankBranch b, CompanyDetail e ,CatalogueValue d where a.BranchID = b.RowID and " + " a.AccountType = d.CatalogueValueID and a.CompanyID = e.CompanyID and a.CompanyID = " + compID + " and b.Status = 1 and a.AccountType = 'CurrentA/c' and a.Status = 1"; SqlCommand cmd = new SqlCommand(query, conn); conn.Open(); SqlDataReader reader = cmd.ExecuteReader(); while (reader.Read()) { ca = new companybank(); ca.CompanyID = Convert.ToString(reader.GetInt32(0)); ca.CompanyName = reader.GetString(1); ca.BankID = reader.GetString(2); ca.BranchName = reader.GetString(3); ca.AccountType = reader.GetString(4); ca.AccountCode = reader.GetString(5); ca.CreateTime = reader.GetDateTime(7); ca.CreateUser = reader.GetString(6); ca.RowID = reader.GetInt32(8); ca.branchID = reader.GetInt32(9); ca.Status = reader.GetInt32(10); AddList.Add(ca); } conn.Close(); } catch (Exception ex) { MessageBox.Show("Error querying Company Bank"); } return(AddList); }