public void Update(BranchManagementBO branchMngmntBO, int branchIDforupdate)
{
string queryString = "";
queryString = @"SBPUpdateBranch";
try
{
_dbConnection.ConnectDatabase();
_dbConnection.ActiveStoredProcedure();
_dbConnection.AddParameter("@branchID", SqlDbType.Int, branchIDforupdate);
_dbConnection.AddParameter("@branchName", SqlDbType.VarChar, branchMngmntBO.BranchName);
_dbConnection.AddParameter("@address", SqlDbType.VarChar, branchMngmntBO.BranchAddress);
_dbConnection.AddParameter("@telePhone", SqlDbType.VarChar, branchMngmntBO.TelePhone);
_dbConnection.AddParameter("@fax", SqlDbType.VarChar, branchMngmntBO.Fax);
_dbConnection.AddParameter("@eMail", SqlDbType.VarChar, branchMngmntBO.Email);
_dbConnection.AddParameter("@web", SqlDbType.VarChar, branchMngmntBO.Web);
_dbConnection.AddParameter("@openDate", SqlDbType.DateTime, branchMngmntBO.BranchOpeningdate.ToShortDateString());
_dbConnection.AddParameter("@isActive ", SqlDbType.Int, branchMngmntBO.BranchIsActive);
_dbConnection.AddParameter("@entryBy", SqlDbType.VarChar, GlobalVariableBO._userName);
_dbConnection.ExecuteNonQuery(queryString);
}
catch (Exception exception)
{
throw exception;
}
finally
{
_dbConnection.CloseDatabase();
}
}
public void Insert(BranchManagementBO branchMngmntBO)
{
string queryString = "";
CommonBAL commonBAL = new CommonBAL();
branchMngmntBO.BranchId = commonBAL.GenerateID("SBP_Broker_Branch", "Branch_ID");
queryString = @"SBPSaveBranch";
try
{
_dbConnection.ConnectDatabase();
_dbConnection.ActiveStoredProcedure();
_dbConnection.AddParameter("@branchID", SqlDbType.Int, branchMngmntBO.BranchId);
_dbConnection.AddParameter("@branchName", SqlDbType.VarChar, branchMngmntBO.BranchName);
_dbConnection.AddParameter("@address", SqlDbType.VarChar, branchMngmntBO.BranchAddress);
_dbConnection.AddParameter("@telePhone", SqlDbType.VarChar, branchMngmntBO.TelePhone);
_dbConnection.AddParameter("@fax", SqlDbType.VarChar, branchMngmntBO.Fax);
_dbConnection.AddParameter("@eMail", SqlDbType.VarChar, branchMngmntBO.Email);
_dbConnection.AddParameter("@web", SqlDbType.VarChar, branchMngmntBO.Web);
_dbConnection.AddParameter("@openDate", SqlDbType.DateTime, branchMngmntBO.BranchOpeningdate.ToShortDateString());
_dbConnection.AddParameter("@isActive ", SqlDbType.Int, branchMngmntBO.BranchIsActive);
_dbConnection.AddParameter("@entryBy", SqlDbType.VarChar, GlobalVariableBO._userName);
_dbConnection.ExecuteNonQuery(queryString);
}
catch (Exception exception)
{
throw exception;
}
finally
{
_dbConnection.CloseDatabase();
}
}
