public int InsertBankBranch(BankInformationEntity oBankInformationEntity)
{
con = oConnectionDatabase.DatabaseConnection();
int i = 0;
cmd = new SqlCommand("INSERT INTO tblBankBranch (Bankid,BranchCode,BranchName,BranchAddress,BranchRoutingCode,BranchRemarks,BranchCreateBy,BranchLastModifieddBy) VALUES(" + oBankInformationEntity.Bankid + ",'" + oBankInformationEntity.BranchCode + "','" + oBankInformationEntity.BranchName + "','" + oBankInformationEntity.BranchAddress + "','" + oBankInformationEntity.BranchRoutingCode + "','" + oBankInformationEntity.BranchRemarks + "','" + oBankInformationEntity.BranchCreateBy + "','" + oBankInformationEntity.BranchLastModifieddBy + "')", con);
try
{
cmd.CommandType = CommandType.Text;
cmd.ExecuteNonQuery();
i = 1;
}
catch { }
con.Close();
return(i);
}
public int DeleteBank(BankInformationEntity oBankInformationEntity)
{
con = oConnectionDatabase.DatabaseConnection();
int i = 0;
cmd = new SqlCommand("DELETE FROM tblBank WHERE Bankid=" + oBankInformationEntity.Bankid, con);
try
{
cmd.CommandType = CommandType.Text;
cmd.ExecuteNonQuery();
i = 1;
}
catch { }
con.Close();
return(i);
}
public int InsertBank(BankInformationEntity oBankInformationEntity)
{
con = oConnectionDatabase.DatabaseConnection();
int i = 0;
cmd = new SqlCommand("INSERT INTO tblBank (BankName,BankRemarks) VALUES('" + oBankInformationEntity.BankName + "','" + oBankInformationEntity.BankRemarks + "')", con);
try
{
cmd.CommandType = CommandType.Text;
cmd.ExecuteNonQuery();
i = 1;
}
catch { }
con.Close();
return(i);
}
public int UpdateBank(BankInformationEntity oBankInformationEntity)
{
con = oConnectionDatabase.DatabaseConnection();
int i = 0;
cmd = new SqlCommand("UPDATE tblBank SET BankName='" + oBankInformationEntity.BankName + "',BankRemarks='" + oBankInformationEntity.BankRemarks + "' WHERE Bankid=" + oBankInformationEntity.Bankid, con);
try
{
cmd.CommandType = CommandType.Text;
cmd.ExecuteNonQuery();
i = 1;
}
catch { }
con.Close();
return(i);
}
public int UpdateBankBranch(BankInformationEntity oBankInformationEntity)
{
con = oConnectionDatabase.DatabaseConnection();
int i = 0;
cmd = new SqlCommand("UPDATE tblBankBranch SET BranchCode='" + oBankInformationEntity.BranchCode + "',BranchName='" + oBankInformationEntity.BranchName + "',BranchAddress='" + oBankInformationEntity.BranchAddress + "',BranchRoutingCode='" + oBankInformationEntity.BranchRoutingCode + "',BranchRemarks='" + oBankInformationEntity.BranchRemarks + "',BranchLastModifieddBy='" + oBankInformationEntity.BranchLastModifieddBy + "' WHERE BranchID=" + oBankInformationEntity.BranchID, con);
try
{
cmd.CommandType = CommandType.Text;
cmd.ExecuteNonQuery();
i = 1;
}
catch { }
con.Close();
return(i);
}
