protected void lstCriteria_SelectedIndexChanged(object sender, EventArgs e)
{
List <ATTEvaluationGroup> lstGrp = (List <ATTEvaluationGroup>)Session["EvaluationGroupListSetup"];
ATTEvaluationCriteria crit = lstGrp[this.ddlGroup_rqd.SelectedIndex].LstEvaluationCriteria[this.lstCriteria.SelectedIndex];
this.txtCriteria_rqd.Text = crit.EvaluationCriteriaName;
this.txtFromDate_rdt.Text = crit.FromDate;
this.txtFromDate_rdt.Enabled = false;
this.txtToDate_rdt.Text = crit.ToDate;
this.chkActive.Checked = (crit.Active == "Y") ? true : false;
List <ATTEvaluationCriteriaGrade> tempList = new List <ATTEvaluationCriteriaGrade>();
foreach (ATTEvaluationCriteriaGrade obj in crit.LstEvaluationCriteriaGrade)
{
ATTEvaluationCriteriaGrade grade = new ATTEvaluationCriteriaGrade();
grade.EvaluationCriteriaID = obj.EvaluationCriteriaID;
grade.FromDate = obj.FromDate;
grade.EvaluationGradeID = obj.EvaluationGradeID;
grade.EvaluationGradeName = obj.EvaluationGradeName;
grade.TotalWeight = obj.TotalWeight;
grade.Active = obj.Active;
grade.Action = obj.Action;
tempList.Add(grade);
}
((ATTEvaluationCriteria)Session["Criteria"]).LstEvaluationCriteriaGrade = tempList;
this.grdGrade.DataSource = tempList;
this.grdGrade.DataBind();
}
public static ObjectValidation Validate(ATTEvaluationCriteria obj)
{
ObjectValidation result = new ObjectValidation();
if (obj.EvaluationCriteriaName == "")
{
result.IsValid = false;
result.ErrorMessage = "Criteria name cannot be empty.";
return(result);
}
if (obj.FromDate == "")
{
result.IsValid = false;
result.ErrorMessage = "From date cannot be empty.";
return(result);
}
if (obj.ToDate == "")
{
result.IsValid = false;
result.ErrorMessage = "To date cannot be empty.";
return(result);
}
if (obj.GroupID <= 0)
{
result.IsValid = false;
result.ErrorMessage = "Evaluation group cannot be empty.";
return(result);
}
return(result);
}
protected void grdGrade_SelectedIndexChanged(object sender, EventArgs e)
{
ATTEvaluationCriteria crit = (ATTEvaluationCriteria)Session["Criteria"];
ATTEvaluationCriteriaGrade grade = crit.LstEvaluationCriteriaGrade[this.grdGrade.SelectedIndex];
this.txtGrade.Text = grade.EvaluationGradeName;
this.txtWeight.Text = grade.TotalWeight.ToString();
this.chkGrade.Checked = (grade.Active == "Y") ? true : false;
}
public static bool AddEvaluationCriteria(ATTEvaluationCriteria obj)
{
try
{
return(DLLEvaluationCriteria.AddEvaluationCriteria(obj));
}
catch (Exception ex)
{
throw ex;
}
}
public static bool AddEvaluationCriteria(ATTEvaluationCriteria obj)
{
string SP = "";
if (obj.Action == "A")
{
SP = "SP_ADD_EVALUATION_CRITERIA";
}
else if (obj.Action == "E")
{
SP = "SP_EDIT_EVALUATION_CRITERIA";
}
List <OracleParameter> paramArray = new List <OracleParameter>();
GetConnection getConn = new GetConnection();
OracleTransaction Tran = getConn.GetDbConn(Module.PMS).BeginTransaction();
if (obj.Action != "N")
{
paramArray.Add(Utilities.GetOraParam("P_EVAL_CRIT_ID", obj.EvaluationCriteriaID, OracleDbType.Int64, ParameterDirection.InputOutput));
paramArray.Add(Utilities.GetOraParam("P_FROM_DATE", obj.FromDate, OracleDbType.Varchar2, ParameterDirection.Input));
paramArray.Add(Utilities.GetOraParam("P_EVAL_GROUP_ID", obj.GroupID, OracleDbType.Int64, ParameterDirection.Input));
paramArray.Add(Utilities.GetOraParam("P_EVAL_CRIT_NAME", obj.EvaluationCriteriaName, OracleDbType.Varchar2, ParameterDirection.Input));
paramArray.Add(Utilities.GetOraParam("P_TO_DATE", obj.ToDate, OracleDbType.Varchar2, ParameterDirection.Input));
paramArray.Add(Utilities.GetOraParam("P_ACTIVE", obj.Active, OracleDbType.Char, ParameterDirection.Input));
}
try
{
SqlHelper.ExecuteNonQuery(Tran, CommandType.StoredProcedure, SP, paramArray.ToArray());
int CriteriaID = int.Parse(paramArray[0].Value.ToString());
obj.EvaluationCriteriaID = CriteriaID;
obj.Action = "N";
DLLEvaluationCriteriaGrade.AddEvaluationCriteriaGrade(obj.LstEvaluationCriteriaGrade, Tran, CriteriaID);
Tran.Commit();
return(true);
}
catch (Exception ex)
{
Tran.Rollback();
throw ex;
}
finally
{
getConn.CloseDbConn();
}
}
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;
}
}
public static List <ATTEvaluationCriteria> GetEvaluationCriteriaList(int?grpID, Default defGrade, string active)
{
List <ATTEvaluationCriteria> lst = new List <ATTEvaluationCriteria>();
try
{
List <ATTEvaluationCriteriaGrade> lstGrade = BLLEvaluationCriteriaGrade.GetEvaluationCriteriaGradeList("", active);
foreach (DataRow row in DLLEvaluationCriteria.GetEvaluationCriteriaTable(grpID, active).Rows)
{
ATTEvaluationCriteria obj = new ATTEvaluationCriteria();
obj.EvaluationCriteriaID = int.Parse(row["Eval_crit_id"].ToString());
obj.FromDate = row["from_date"].ToString();
obj.GroupID = int.Parse(row["Eval_group_id"].ToString());
obj.EvaluationCriteriaName = row["eval_crit_name"].ToString();
obj.ToDate = row["to_date"].ToString();
obj.Active = row["active"].ToString();
obj.Action = "N";
obj.LstEvaluationCriteriaGrade = lstGrade.FindAll
(
delegate(ATTEvaluationCriteriaGrade grade)
{
return(grade.EvaluationCriteriaID == obj.EvaluationCriteriaID &&
grade.FromDate == obj.FromDate);
}
);
if (defGrade == Default.Yes)
{
ATTEvaluationCriteriaGrade defaultGrade = new ATTEvaluationCriteriaGrade();
defaultGrade.EvaluationGradeName = "----- भार छन्नुहोस -----";
obj.LstEvaluationCriteriaGrade.Insert(0, defaultGrade);
}
lst.Add(obj);
}
return(lst);
}
catch (Exception ex)
{
throw ex;
}
}
void SetCriteriaSession()
{
Session["Criteria"] = new ATTEvaluationCriteria();
}
protected void btnSubmit_Click(object sender, EventArgs e)
{
if (this.ddlGroup_rqd.SelectedIndex == 0)
{
this.lblStatusMessage.Text = "Please select Evaluation group.";
this.programmaticModalPopup.Show();
this.ddlGroup_rqd.Focus();
return;
}
ATTEvaluationCriteria crit = (ATTEvaluationCriteria)Session["Criteria"];
crit.GroupID = int.Parse(this.ddlGroup_rqd.SelectedValue);
crit.EvaluationCriteriaName = this.txtCriteria_rqd.Text;
crit.FromDate = this.txtFromDate_rdt.Text;
crit.ToDate = this.txtToDate_rdt.Text;
crit.Active = (this.chkActive.Checked == true) ? "Y" : "N";
if (this.lstCriteria.SelectedIndex >= 0)
{
List <ATTEvaluationGroup> lstGrp = (List <ATTEvaluationGroup>)Session["EvaluationGroupListSetup"];
ATTEvaluationCriteria critSess = lstGrp[this.ddlGroup_rqd.SelectedIndex].LstEvaluationCriteria[this.lstCriteria.SelectedIndex];
crit.EvaluationCriteriaID = critSess.EvaluationCriteriaID;
crit.Action = "E";
}
else
{
crit.Action = "A";
}
ObjectValidation result = BLLEvaluationCriteria.Validate(crit);
if (result.IsValid == false)
{
this.lblStatusMessage.Text = result.ErrorMessage;
this.programmaticModalPopup.Show();
return;
}
try
{
BLLEvaluationCriteria.AddEvaluationCriteria(crit);
List <ATTEvaluationGroup> lstGrp = (List <ATTEvaluationGroup>)Session["EvaluationGroupListSetup"];
if (this.lstCriteria.SelectedIndex >= 0)
{
lstGrp[this.ddlGroup_rqd.SelectedIndex].LstEvaluationCriteria[this.lstCriteria.SelectedIndex] = crit;
}
else
{
lstGrp[this.ddlGroup_rqd.SelectedIndex].LstEvaluationCriteria.Add(crit);
}
this.ClearCriteria();
this.ClearGrade();
this.grdGrade.DataSource = "";
this.grdGrade.DataBind();
this.grdGrade.SelectedIndex = -1;
this.lstCriteria.SelectedIndex = -1;
//this.ddlGroup_rqd.SelectedIndex = 0;
this.lstCriteria.DataSource = lstGrp[this.ddlGroup_rqd.SelectedIndex].LstEvaluationCriteria;
this.lstCriteria.DataBind();
this.lblStatusMessage.Text = "Evaluation criteria and grade saved sucessfully.";
this.programmaticModalPopup.Show();
}
catch (Exception ex)
{
this.lblStatusMessage.Text = ex.Message;
this.programmaticModalPopup.Show();
}
}
protected void btnAddWeight_Click(object sender, EventArgs e)
{
if (this.ddlGroup_rqd.SelectedIndex == 0)
{
this.lblStatusMessage.Text = "Please select Evaluation group.";
this.programmaticModalPopup.Show();
this.ddlGroup_rqd.Focus();
return;
}
if (this.txtCriteria_rqd.Text.Trim() == "")
{
this.lblStatusMessage.Text = "Please enter Criteria name.";
this.programmaticModalPopup.Show();
this.txtCriteria_rqd.Focus();
return;
}
if (this.txtFromDate_rdt.Text.Trim() == "")
{
this.lblStatusMessage.Text = "Please enter From date.";
this.programmaticModalPopup.Show();
this.txtFromDate_rdt.Focus();
return;
}
ATTEvaluationCriteria crit = (ATTEvaluationCriteria)Session["Criteria"];
ATTEvaluationCriteriaGrade obj = new ATTEvaluationCriteriaGrade();
if (this.grdGrade.SelectedIndex >= 0)
{
obj.EvaluationCriteriaID = int.Parse(this.grdGrade.SelectedRow.Cells[0].Text);
obj.FromDate = this.grdGrade.SelectedRow.Cells[1].Text;
obj.EvaluationGradeID = int.Parse(this.grdGrade.SelectedRow.Cells[2].Text);
if (this.grdGrade.SelectedRow.Cells[6].Text == "A")
{
obj.Action = "A";
}
else
{
obj.Action = "E";
}
}
else
{
obj.EvaluationCriteriaID = 0;
obj.FromDate = this.txtFromDate_rdt.Text;
obj.EvaluationGradeID = 0;
obj.Action = "A";
}
obj.EvaluationGradeName = this.txtGrade.Text;
obj.TotalWeight = float.Parse(this.txtWeight.Text);
obj.Active = (this.chkGrade.Checked == true ? "Y" : "N");
if (this.grdGrade.SelectedIndex >= 0)
{
crit.LstEvaluationCriteriaGrade[this.grdGrade.SelectedIndex] = obj;
}
else
{
crit.LstEvaluationCriteriaGrade.Add(obj);
}
this.grdGrade.DataSource = crit.LstEvaluationCriteriaGrade;
this.grdGrade.DataBind();
this.ClearGrade();
this.grdGrade.SelectedIndex = -1;
}
