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