public static List <BankSubsidiary> GetBankSubsidiary(int branchid)
{
var dbUtil = new DatabaseManager();
var bankSubsidiaries = new List <BankSubsidiary>();
using (var conn = new SqlConnection(dbUtil.getSQLConnectionString("MainDB")))
{
conn.Open();
using (SqlCommand cmd = conn.CreateCommand())
{
cmd.CommandType = CommandType.StoredProcedure;
cmd.CommandText = "spColGetBankSubsidiary";
cmd.CommandTimeout = 180;
cmd.Parameters.Clear();
cmd.Parameters.AddWithValue("@intIDMasLocation", branchid);
using (SqlDataReader reader = cmd.ExecuteReader())
{
while (reader.Read())
{
var bankSubsidiary = new BankSubsidiary
{
BankSubsidiaryID = ReferenceEquals(reader["ID"], DBNull.Value) ? 0 : Convert.ToInt32(reader["ID"]),
Name = ReferenceEquals(reader["BankName"], DBNull.Value) ? String.Empty : Convert.ToString(reader["BankName"])
};
bankSubsidiaries.Add(bankSubsidiary);
}
return(bankSubsidiaries);
}
}
}
}
public static List <BankSubsidiary> GetBankSubsidiary(int branchid, string criteria)
{
var dbUtil = new DatabaseManager();
var bankSubsidiaries = new List <BankSubsidiary>();
using (var conn = new SqlConnection(dbUtil.getSQLConnectionString("MainDB")))
{
conn.Open();
using (SqlCommand cmd = conn.CreateCommand())
{
cmd.CommandType = CommandType.StoredProcedure;
cmd.CommandText = "spMasGetBank";
cmd.CommandTimeout = 180;
cmd.Parameters.Clear();
cmd.Parameters.AddWithValue("@intIDMasLocation", branchid);
cmd.Parameters.AddWithValue("@strCriteria", criteria);
using (SqlDataReader reader = cmd.ExecuteReader())
{
while (reader.Read())
{
var bankSubsidiary = new BankSubsidiary
{
BankID = ReferenceEquals(reader["bankID"], DBNull.Value) ? 0 : Convert.ToInt32(reader["bankID"]),
BankAccountName = ReferenceEquals(reader["strBankAccountName"], DBNull.Value) ? String.Empty : Convert.ToString(reader["strBankAccountName"]),
BankAccountNO = ReferenceEquals(reader["strBankAccountNo"], DBNull.Value) ? String.Empty : Convert.ToString(reader["strBankAccountNo"]),
Bank = ReferenceEquals(reader["strBank"], DBNull.Value) ? String.Empty : Convert.ToString(reader["strBank"]),
intIDmasLocation = ReferenceEquals(reader["intIDMasLocation"], DBNull.Value) ? 0 : Convert.ToInt32(reader["intIDMasLocation"]),
IsActive = ReferenceEquals(reader["intIsActive"], DBNull.Value) ? false : Convert.ToBoolean(reader["intIsActive"]),
intIDMasBankAccount = ReferenceEquals(reader["intIDMasBankAccount"], DBNull.Value) ? 0 : Convert.ToInt32(reader["intIDMasBankAccount"])
};
bankSubsidiaries.Add(bankSubsidiary);
}
return(bankSubsidiaries);
}
}
}
}
public static string ManageBank(NameValueCollection querystring)
{
int integerParse;
Boolean boolParser;
UserProfile userProfile = WebCommon.GetUserProfile();
var bankSubsidiary = new BankSubsidiary
{
BankID = int.TryParse(querystring.Get("BankID"), out integerParse) ? integerParse : 0,
BankAccountName = querystring.Get("BankAccountName"),
BankAccountNO = querystring.Get("BankAccountNo"),
Bank = querystring.Get("Bank"),
intIDmasLocation = int.TryParse(querystring.Get("intIDMasLocation"), out integerParse) ? integerParse : 0,
IsActive = Boolean.TryParse(querystring.Get("IsActive"), out boolParser) ? boolParser : false,
intIDMasBankAccount = int.TryParse(querystring.Get("intIDMasBankAccount"), out integerParse) ? integerParse : 0,
};
string isInsert = querystring.Get("TransType");
string param = WebCommon.ToXML(bankSubsidiary);
return(BankDAL.ManageBank(param, isInsert));
}
