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);
}
