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(); } }