public int Save(PriviledgeDB objDB, SqlTransaction objTrans)
{
int PriviledgeID = 0;
DataAccessLayer objDataLayer = new DataAccessLayer();
SqlCommand objCmd = new SqlCommand();
try
{
objCmd.CommandText = "usp_Priviledges";
objCmd.CommandType = CommandType.StoredProcedure;
objCmd.Parameters.AddWithValue("@FormID", objDB.FormID);
objCmd.Parameters.AddWithValue("@RoleID", objDB.RoleID);
objCmd.Parameters.AddWithValue("@viewing", objDB.viewing);
objCmd.Parameters.AddWithValue("@PriviledgeID", SqlDbType.Int);
objCmd.Parameters["@PriviledgeID"].Direction = ParameterDirection.Output;
objCmd.Transaction = objTrans;
objCmd.Connection = objTrans.Connection;
objDataLayer.Command = objCmd;
objDataLayer.ExecQuery();
PriviledgeID = Convert.ToInt32(objCmd.Parameters["@PriviledgeID"].Value);
return PriviledgeID;
}
catch (Exception ex)
{
throw ex;
}
}
public int Save( PriviledgeUI objUI, System.Data.SqlClient.SqlTransaction objTrans)
{
int PriviledgeID = 0;
bool flagTransation = true;
PriviledgeDB objDB = new PriviledgeDB();
objDB.RoleID = objUI.RoleID;
objDB.FormID = objUI.FormID;
objDB.viewing = objUI.viewing;
DataAccessLayer objDataAccess = new DataAccessLayer();
try
{
if (objTrans == null)
{
flagTransation = false;
objDataAccess.GetConnection.Open();
SqlTransaction objTransaction = objDataAccess.GetConnection.BeginTransaction();
objTrans = objTransaction;
}
PriviledgeManager objManager = new PriviledgeManager();
PriviledgeID = objManager.Save(objDB, objTrans);
if (!flagTransation)
objTrans.Commit();
return PriviledgeID;
}
catch (Exception ex)
{
if (!flagTransation)
objTrans.Rollback();
throw ex;
}
finally
{
objDataAccess.GetConnection.Close();
}
}
