public static List <ATTLitigantSubType> GetLitigantSubType(int?litigantSubTypeID, string active, int litSubTypeDV)
{
try
{
List <ATTLitigantSubType> litigantSubTypeLIST = new List <ATTLitigantSubType>();
foreach (DataRow drow in DLLLitigantSubType.GetLitigantSubType(litigantSubTypeID, active).Rows)
{
ATTLitigantSubType litigantSubType = new ATTLitigantSubType();
litigantSubType.LitigantSubTypeID = int.Parse(drow["LITIGANT_SUB_TYPE_ID"].ToString());
litigantSubType.LitigantSubTypeName = drow["LITIGANT_SUB_TYPE_NAME"].ToString();
litigantSubType.Active = drow["ACTIVE"].ToString();
litigantSubType.Action = "";
litigantSubTypeLIST.Add(litigantSubType);
}
if (litSubTypeDV > 0)
{
litigantSubTypeLIST.Insert(0, new ATTLitigantSubType(0, "छान्नहोस", ""));
}
return(litigantSubTypeLIST);
}
catch (Exception ex)
{
throw ex;
}
}
protected void btnSave_Click(object sender, EventArgs e)
{
if (txLitigantSubTypeName.Text.Trim() == "")
{
lblStatusMessage.Text = "Litigant Sub Type छुट्यो </br>";
this.programmaticModalPopup.Show();
return;
}
try
{
List <ATTLitigantSubType> litigantStatusLST = (List <ATTLitigantSubType>)Session["LitigantSubType"];
ATTLitigantSubType litigantStatus = new ATTLitigantSubType();
litigantStatus.LitigantSubTypeName = txLitigantSubTypeName.Text.Trim();
litigantStatus.Active = (chkLitigantSubType.Checked) ? "Y" : "N";
litigantStatus.EntryBy = entryBy;
if (lstLitigantSubType.SelectedIndex >= 0)
{
litigantStatus.Action = "E";
litigantStatus.LitigantSubTypeID = litigantStatusLST[lstLitigantSubType.SelectedIndex].LitigantSubTypeID;
}
else
{
litigantStatus.Action = "A";
}
if (BLLLitigantSubType.AddEditDeleteLitigantSubType(litigantStatus))
{
if (lstLitigantSubType.SelectedIndex >= 0)
{
litigantStatusLST[lstLitigantSubType.SelectedIndex] = litigantStatus;
}
else
{
litigantStatusLST.Add(litigantStatus);
}
lstLitigantSubType.DataSource = litigantStatusLST;
lstLitigantSubType.DataBind();
lblStatusMessage.Text = "Data Saved Successfully</br>";
this.programmaticModalPopup.Show();
}
else
{
lblStatusMessage.Text = "Problem Occurred while Saving Data </br>";
this.programmaticModalPopup.Show();
}
txLitigantSubTypeName.Text = "";
chkLitigantSubType.Checked = true;
lstLitigantSubType.SelectedIndex = -1;
}
catch (Exception)
{
lblStatusMessage.Text = "Problem Occurred while Saving Data </br>";
this.programmaticModalPopup.Show();
}
}
public static bool AddEditDeleteLitigantSubType(ATTLitigantSubType litigantSubType)
{
try
{
return(DLLLitigantSubType.AddEditDeleteLitigantSubType(litigantSubType));
}
catch (Exception ex)
{
throw ex;
}
}
public static bool AddEditDeleteLitigantSubType(ATTLitigantSubType litigantSubType)
{
string InsertUpdateDeleteSQL = "";
GetConnection GetConn = new GetConnection();
OracleConnection DBConn = GetConn.GetDbConn(Module.CMS);
try
{
if (litigantSubType.Action == "A")
{
InsertUpdateDeleteSQL = "SP_ADD_LITIGANT_SUB_TYPE";
}
else if (litigantSubType.Action == "E")
{
InsertUpdateDeleteSQL = "SP_EDIT_LITIGANT_SUB_TYPE";
}
else if (litigantSubType.Action == "D")
{
InsertUpdateDeleteSQL = "SP_DEL_LITIGANT_SUB_TYPE";
}
OracleParameter[] ParamArray;
if (litigantSubType.Action == "A" || litigantSubType.Action == "E")
{
ParamArray = new OracleParameter[4];
ParamArray[0] = FRAMEWORK.Utilities.GetOraParam(":P_LITIGANT_SUB_TYPE_ID", litigantSubType.LitigantSubTypeID, OracleDbType.Int64, ParameterDirection.InputOutput);
ParamArray[1] = FRAMEWORK.Utilities.GetOraParam(":P_LITIGANT_SUB_TYPE_NAME", litigantSubType.LitigantSubTypeName, OracleDbType.Varchar2, ParameterDirection.Input);
ParamArray[2] = FRAMEWORK.Utilities.GetOraParam(":P_ACTIVE", litigantSubType.Active, OracleDbType.Varchar2, ParameterDirection.Input);
ParamArray[3] = FRAMEWORK.Utilities.GetOraParam(":P_ENTRY_BY", litigantSubType.EntryBy, OracleDbType.Varchar2, ParameterDirection.Input);
SqlHelper.ExecuteNonQuery(DBConn, CommandType.StoredProcedure, InsertUpdateDeleteSQL, ParamArray);
litigantSubType.LitigantSubTypeID = int.Parse(ParamArray[0].Value.ToString());
litigantSubType.Action = "";
}
return(true);
}
catch (Exception ex)
{
throw ex;
}
finally
{
GetConn.CloseDbConn();
}
}
