public static List <ATTDecisionType> GetDecisionType(int?DecType, string active, int defaultFlag)
{
List <ATTDecisionType> DecTypeList = new List <ATTDecisionType>();
try
{
foreach (DataRow row in DLLDecisionType.GetDecisionType(DecType, active).Rows)
{
ATTDecisionType objDec = new ATTDecisionType(
int.Parse(row["DECISION_TYPE_ID"].ToString()),
row["DECISION_TYPE_NAME"].ToString(),
row["ACTIVE"].ToString());
DecTypeList.Add(objDec);
}
if (defaultFlag > 0)
{
DecTypeList.Insert(0, new ATTDecisionType(0, "छान्नुहोस", ""));
}
return(DecTypeList);
}
catch (Exception ex)
{
throw ex;
}
}
public static bool SaveDecisionType(ATTDecisionType objDecType)
{
try
{
return(DLLDecisionType.SaveDecisionType(objDecType));
}
catch (Exception ex)
{
throw ex;
}
}
public static bool SaveDecisionType(ATTDecisionType objDecType)
{
string InsertUpdateSQL = "";
List <OracleParameter> paramArray = new List <OracleParameter>();
paramArray.Add(Utilities.GetOraParam(":P_DECISION_TYPE_ID", objDecType.DecisionTypeID, OracleDbType.Int64, ParameterDirection.InputOutput));
paramArray.Add(Utilities.GetOraParam(":P_DECISION_TYPE_NAME", objDecType.DecisionTypeName, OracleDbType.Varchar2, ParameterDirection.Input));
paramArray.Add(Utilities.GetOraParam(":P_ACTIVE", objDecType.Active, OracleDbType.Varchar2, ParameterDirection.Input));
paramArray.Add(Utilities.GetOraParam(":P_ENTRY_BY", objDecType.EntryBy, OracleDbType.Varchar2, ParameterDirection.Input));
if (objDecType.DecisionTypeID == 0)
{
InsertUpdateSQL = "SP_ADD_DECISION_TYPE";
}
else if (objDecType.DecisionTypeID > 0)
{
InsertUpdateSQL = "SP_EDIT_DECISION_TYPE";
}
GetConnection GetConn = new GetConnection();
OracleTransaction Tran = GetConn.GetDbConn(Module.CMS).BeginTransaction();
try
{
SqlHelper.ExecuteNonQuery(Tran, System.Data.CommandType.StoredProcedure, InsertUpdateSQL, paramArray.ToArray());
objDecType.DecisionTypeID = int.Parse(paramArray[0].Value.ToString());
int DecTypeID = int.Parse(paramArray[0].Value.ToString());
DLLOrgDecisionType.SaveOrgDecisionType(objDecType.LstOrgDecisionType, DecTypeID, Tran);
Tran.Commit();
return(true);
}
catch (OracleException oex)
{
PCS.COREDL.OracleError oe = new PCS.COREDL.OracleError();
throw new ArgumentException(oe.GetOraError(oex.Number, oex.Message));
}
catch (Exception ex)
{
Tran.Rollback();
throw ex;
}
finally
{
GetConn.CloseDbConn();
}
}
protected void btnSubmit_Click(object sender, EventArgs e)
{
if (txtDecisionTypeName_RQD.Text == "")
{
lblStatusMessage.Text = "निर्नयको किसिम लेख्नुस";
programmaticModalPopup.Show();
return;
}
ATTDecisionType objDecisionType = new ATTDecisionType(int.Parse(this.hdnDecTypeID.Value), this.txtDecisionTypeName_RQD.Text.Trim(), "Y");
objDecisionType.EntryBy = strUser;
foreach (GridViewRow row in grdOrganization.Rows)
{
ATTOrgDecisionType attODT = new ATTOrgDecisionType();
CheckBox cbSelect = (CheckBox)(row.Cells[0].FindControl("chkSelect"));
string active = "";
string action = "";
if (cbSelect.Checked == true && row.Cells[3].Text == "")
{
active = "Y";
action = "A";
}
else if (cbSelect.Checked == true && row.Cells[3].Text == "N")
{
active = "Y";
action = "E";
}
else if (cbSelect.Checked == false && row.Cells[3].Text == "Y")
{
active = "N";
action = "E";
}
else
{
continue;
}
attODT = new ATTOrgDecisionType(int.Parse(row.Cells[1].Text), int.Parse(this.hdnDecTypeID.Value), active);
attODT.Action = action;
attODT.EntryBy = strUser;
objDecisionType.LstOrgDecisionType.Add(attODT);
}
try
{
List <ATTDecisionType> DecisionTypeList = (List <ATTDecisionType>)Session["DecisionType"];
BLLDecisionType.SaveDecisionType(objDecisionType);
if (this.lstDecisionType.SelectedIndex != -1)
{
DecisionTypeList[this.lstDecisionType.SelectedIndex].DecisionTypeID = objDecisionType.DecisionTypeID;
DecisionTypeList[this.lstDecisionType.SelectedIndex].DecisionTypeName = objDecisionType.DecisionTypeName;
DecisionTypeList[this.lstDecisionType.SelectedIndex].Active = objDecisionType.Active;
}
else
{
DecisionTypeList.Add(objDecisionType);
}
this.lblStatusMessage.Text = "Successfully Saved.";
this.programmaticModalPopup.Show();
this.lstDecisionType.DataSource = DecisionTypeList;
this.lstDecisionType.DataBind();
ClearControls();
}
catch (Exception ex)
{
this.lblStatusMessage.Text = ex.Message;
this.programmaticModalPopup.Show();
}
}
