public BankDetails Details(Int32 BankID)
{
try
{
MySqlCommand cmd = new MySqlCommand();
cmd.CommandType = System.Data.CommandType.Text;
string SQL = SQLSelect() + "WHERE BankID = @BankID;";
cmd.Parameters.AddWithValue("@BankID", BankID);
cmd.CommandText = SQL;
string strDataTableName = "tbl" + this.GetType().FullName.Split(new Char[] { '.' })[this.GetType().FullName.Split(new Char[] { '.' }).Length - 1]; System.Data.DataTable dt = new System.Data.DataTable(strDataTableName);
base.MySqlDataAdapterFill(cmd, dt);
BankDetails Details = new BankDetails();
foreach (System.Data.DataRow dr in dt.Rows)
{
Details.BankID = BankID;
Details.BankCode = dr["BankCode"].ToString();
Details.BankName = dr["BankName"].ToString();
Details.ChequeCode = dr["ChequeCode"].ToString();
Details.ChequeCounter = dr["ChequeCounter"].ToString();
}
return(Details);
}
catch (Exception ex)
{
throw base.ThrowException(ex);
}
}
public Int32 Save(BankDetails Details)
{
try
{
string SQL = "CALL procSaveBank(@BankID, @BankCode, @BankName, @ChequeCode, @ChequeCounter, @CreatedOn, @LastModified);";
MySqlCommand cmd = new MySqlCommand();
cmd.CommandType = System.Data.CommandType.Text;
cmd.CommandText = SQL;
cmd.Parameters.AddWithValue("BankID", Details.BankID);
cmd.Parameters.AddWithValue("BankCode", Details.BankCode);
cmd.Parameters.AddWithValue("BankName", Details.BankName);
cmd.Parameters.AddWithValue("ChequeCode", Details.ChequeCode);
cmd.Parameters.AddWithValue("ChequeCounter", Details.ChequeCounter);
cmd.Parameters.AddWithValue("CreatedOn", Details.CreatedOn == DateTime.MinValue ? Constants.C_DATE_MIN_VALUE : Details.CreatedOn);
cmd.Parameters.AddWithValue("LastModified", Details.LastModified == DateTime.MinValue ? Constants.C_DATE_MIN_VALUE : Details.LastModified);
return(base.ExecuteNonQuery(cmd));
}
catch (Exception ex)
{
throw base.ThrowException(ex);
}
}
public void Update(BankDetails Details)
{
try
{
Save(Details);
}
catch (Exception ex)
{
throw base.ThrowException(ex);
}
}
public void Update(BankDetails Details)
{
try
{
Save(Details);
}
catch (Exception ex)
{
throw base.ThrowException(ex);
}
}
public Int32 Insert(BankDetails Details)
{
try
{
Save(Details);
return(Int32.Parse(base.getLAST_INSERT_ID(this)));
}
catch (Exception ex)
{
throw base.ThrowException(ex);
}
}
public Int32 Insert(BankDetails Details)
{
try
{
Save(Details);
return Int32.Parse(base.getLAST_INSERT_ID(this));
}
catch (Exception ex)
{
throw base.ThrowException(ex);
}
}
private void SaveRecord()
{
BankDetails clsDetails = new BankDetails();
clsDetails.BankID = Convert.ToInt32(lblBankID.Text);
clsDetails.BankCode = txtBankCode.Text;
clsDetails.BankName = txtBankName.Text;
clsDetails.ChequeCode = txtChequeCode.Text;
clsDetails.ChequeCounter = txtChequeCounter.Text;
Banks clsBank = new Banks();
clsBank.Update(clsDetails);
clsBank.CommitAndDispose();
}
private Int32 SaveRecord()
{
BankDetails clsDetails = new BankDetails();
clsDetails.BankCode = txtBankCode.Text;
clsDetails.BankName = txtBankName.Text;
clsDetails.ChequeCode = txtChequeCode.Text;
clsDetails.ChequeCounter = txtChequeCounter.Text;
Banks clsBank = new Banks();
Int32 id = clsBank.Insert(clsDetails);
clsBank.CommitAndDispose();
return id;
}
public BankDetails Details(Int32 BankID)
{
try
{
MySqlCommand cmd = new MySqlCommand();
cmd.CommandType = System.Data.CommandType.Text;
string SQL = SQLSelect() + "WHERE BankID = @BankID;";
cmd.Parameters.AddWithValue("@BankID", BankID);
cmd.CommandText = SQL;
string strDataTableName = "tbl" + this.GetType().FullName.Split(new Char[] { '.' })[this.GetType().FullName.Split(new Char[] { '.' }).Length - 1]; System.Data.DataTable dt = new System.Data.DataTable(strDataTableName);
base.MySqlDataAdapterFill(cmd, dt);
BankDetails Details = new BankDetails();
foreach (System.Data.DataRow dr in dt.Rows)
{
Details.BankID = BankID;
Details.BankCode = dr["BankCode"].ToString();
Details.BankName = dr["BankName"].ToString();
Details.ChequeCode = dr["ChequeCode"].ToString();
Details.ChequeCounter = dr["ChequeCounter"].ToString();
}
return Details;
}
catch (Exception ex)
{
throw base.ThrowException(ex);
}
}
public Int32 Save(BankDetails Details)
{
try
{
string SQL = "CALL procSaveBank(@BankID, @BankCode, @BankName, @ChequeCode, @ChequeCounter, @CreatedOn, @LastModified);";
MySqlCommand cmd = new MySqlCommand();
cmd.CommandType = System.Data.CommandType.Text;
cmd.CommandText = SQL;
cmd.Parameters.AddWithValue("BankID", Details.BankID);
cmd.Parameters.AddWithValue("BankCode", Details.BankCode);
cmd.Parameters.AddWithValue("BankName", Details.BankName);
cmd.Parameters.AddWithValue("ChequeCode", Details.ChequeCode);
cmd.Parameters.AddWithValue("ChequeCounter", Details.ChequeCounter);
cmd.Parameters.AddWithValue("CreatedOn", Details.CreatedOn == DateTime.MinValue ? Constants.C_DATE_MIN_VALUE : Details.CreatedOn);
cmd.Parameters.AddWithValue("LastModified", Details.LastModified == DateTime.MinValue ? Constants.C_DATE_MIN_VALUE : Details.LastModified);
return base.ExecuteNonQuery(cmd);
}
catch (Exception ex)
{
throw base.ThrowException(ex);
}
}
