public int Update(RS_EmployScoreModel ObjModel) { int num = 0; using (SqlConnection connection = new SqlConnection(FunctionRule.GetConnectionString())) { connection.Open(); SqlTransaction transaction = connection.BeginTransaction(); try { try { num = new RS_EmployScoreBLL().Update(ObjModel, transaction); transaction.Commit(); } catch (SqlException exception) { transaction.Rollback(); throw exception; } return(num); } finally { connection.Close(); } } return(num); }
public RS_EmployScoreModel GetRS_EmployScore(int Code) { RS_EmployScoreModel model = new RS_EmployScoreModel(); using (SqlConnection connection = new SqlConnection(FunctionRule.GetConnectionString())) { try { connection.Open(); model = new RS_EmployScoreBLL().GetModel(Code, connection); connection.Close(); } catch (SqlException exception) { throw exception; } } return(model); }