public static void AddBank(bank_master mst)
{
try
{
using (MySqlConnection con = new MySqlConnection(ConfigurationManager.ConnectionStrings["DefaultConnection"].ToString()))
{
string query = "INSERT INTO bank_master (bank_id,bank_name) VALUES (@bank_id,@bank_name)";
string maxid = @"SELECT
IFNULL(MAX(bank_id), 0) + 1
FROM
bank_master";
int id = con.ExecuteScalar <int>(maxid);
mst.bank_id = id;
mst.bank_name = mst.bank_name.Trim();
con.Execute(query, new
{
mst.bank_id,
mst.bank_name
});
}
}
catch (Exception ex)
{
throw ex;
}
}
public static void EditBank(bank_master mst)
{
try
{
using (MySqlConnection con = new MySqlConnection(ConfigurationManager.ConnectionStrings["DefaultConnection"].ToString()))
{
string query = @"UPDATE bank_master
SET
bank_name = @bank_name
WHERE
bank_id = @bank_id";
con.Execute(query, mst);
}
}
catch (Exception ex)
{
throw ex;
}
}