public static bool SaveEvaluationGroup(ATTEvaluationGroup obj) { try { return(DLLEvaluationGroup.SaveEvaluationGroup(obj)); } catch (Exception ex) { throw ex; } }
public static List <ATTEvaluationGroup> GetEvaluationGroupList(Default defGroup, Default defCriteria, Default defGrade, string active) { List <ATTEvaluationGroup> lst = new List <ATTEvaluationGroup>(); try { List <ATTEvaluationCriteria> lstCriteria = BLLEvaluationCriteria.GetEvaluationCriteriaList(null, defCriteria, active); foreach (DataRow row in DLLEvaluationGroup.GetEvaluationGroupTable().Rows) { ATTEvaluationGroup grp = new ATTEvaluationGroup(); grp.GroupID = int.Parse(row["Eval_Group_ID"].ToString()); grp.GroupName = row["Eval_Group_Name"].ToString(); grp.LstEvaluationCriteria = lstCriteria.FindAll ( delegate(ATTEvaluationCriteria crit) { return (crit.GroupID == grp.GroupID); } ); lst.Add(grp); if (defCriteria == Default.Yes && grp.LstEvaluationCriteria.Count > 0) { ATTEvaluationCriteria defaultCrit = new ATTEvaluationCriteria(); defaultCrit.EvaluationCriteriaName = "----- बिवरण छन्नुहोस -----"; grp.LstEvaluationCriteria.Insert(0, defaultCrit); } } if (defGroup == Default.Yes) { ATTEvaluationGroup defaultX = new ATTEvaluationGroup(0, "----- समुह छन्नुहोस -----"); lst.Insert(0, defaultX); } return(lst); } catch (Exception ex) { throw ex; } }
protected void btnSubmit_Click(object sender, EventArgs e) { int groupID = 0; string groupName = this.txtEvaluationGroup_Rqd.Text.Trim(); List <ATTEvaluationGroup> EvaluationGroupList = (List <ATTEvaluationGroup>)Session["EvaluationGroupList"]; ATTEvaluationGroup EvaluationGroup = new ATTEvaluationGroup(groupID, groupName); if (this.lstEvaluationGroup.SelectedIndex > -1) { EvaluationGroup.GroupID = EvaluationGroupList[this.lstEvaluationGroup.SelectedIndex].GroupID; EvaluationGroup.Action = "E"; } else { EvaluationGroup.Action = "A"; } try { BLLEvaluationGroup.SaveEvaluationGroup(EvaluationGroup); if (this.lstEvaluationGroup.SelectedIndex > -1) { EvaluationGroupList[this.lstEvaluationGroup.SelectedIndex] = EvaluationGroup; } else { EvaluationGroupList.Add(EvaluationGroup); } this.lstEvaluationGroup.DataSource = EvaluationGroupList; this.lstEvaluationGroup.DataBind(); this.txtEvaluationGroup_Rqd.Text = ""; this.lstEvaluationGroup.SelectedIndex = -1; this.lblStatusMessage.Text = "Evaluation Group Saved Successfully."; this.programmaticModalPopup.Show(); } catch (Exception ex) { this.lblStatusMessage.Text = ex.Message; this.programmaticModalPopup.Show(); } }
public static bool SaveEvaluationGroup(ATTEvaluationGroup obj) { string SP = ""; if (obj.Action == "A") { SP = "SP_ADD_EVALUATION_GROUPS"; } else if (obj.Action == "E") { SP = "SP_EDIT_EVALUATION_GROUPS"; } List <OracleParameter> paramArray = new List <OracleParameter>(); GetConnection getConn = new GetConnection(); OracleTransaction Tran = getConn.GetDbConn(Module.PMS).BeginTransaction(); paramArray.Add(Utilities.GetOraParam("P_EVAL_GROUP_ID", obj.GroupID, OracleDbType.Int64, ParameterDirection.InputOutput)); paramArray.Add(Utilities.GetOraParam("P_EVAL_GROUP_NAME", obj.GroupName, OracleDbType.Varchar2, ParameterDirection.Input)); try { SqlHelper.ExecuteNonQuery(Tran, CommandType.StoredProcedure, SP, paramArray.ToArray()); int groupID = int.Parse(paramArray[0].Value.ToString()); obj.GroupID = groupID; Tran.Commit(); return(true); } catch (Exception ex) { Tran.Rollback(); throw ex; } finally { getConn.CloseDbConn(); } }