public static List <ATTLawyerInfoSearch> GetLawyerInfoSearchList(ATTLawyerInfoSearch objLIsrch)
{
List <ATTLawyerInfoSearch> lst = new List <ATTLawyerInfoSearch>();
try
{
DataTable tbl = DLLLawyerInfoSearch.GetLawyerInfoSearchTbl(objLIsrch);
foreach (DataRow row in tbl.Rows)
{
ATTLawyerInfoSearch obj = new ATTLawyerInfoSearch();
obj.PERSONID = double.Parse(row["p_id"].ToString());
obj.FNAME = row["FIRST_NAME"].ToString();
obj.MNAME = row["MID_NAME"].ToString() == "" ? "" : row["MID_NAME"].ToString();
obj.LNAME = row["SUR_NAME"].ToString();
obj.LICENSENO = row["license_no"].ToString();
obj.LTYPEID = int.Parse(row["lawyer_type_id"].ToString());
obj.LTYPE = row["lawyer_type_description"].ToString();
obj.LRENEWALUPTO = row["lawyer_last_ren_date"].ToString();
obj.ACTIVE = row["active"].ToString();
int?unitId;
if (row["unit_id"].ToString() == "")
{
unitId = null;
}
else
{
unitId = int.Parse(row["unit_id"].ToString());
}
obj.UNITID = unitId;
obj.UNITNAME = row["unit_name"].ToString() == "" ? "" : row["unit_name"].ToString();
obj.PLRENEWALUPTO = row["p_lawyer_last_ren_date"].ToString() == "" ? "" : row["p_lawyer_last_ren_date"].ToString();
if (obj.LRENEWALUPTO != null && obj.LRENEWALUPTO != "")
{
obj.DISPLAYDATE = obj.LRENEWALUPTO;
}
else if (obj.PLRENEWALUPTO != null && obj.PLRENEWALUPTO != "")
{
obj.DISPLAYDATE = obj.PLRENEWALUPTO;
}
else
{
obj.DISPLAYDATE = "";
}
lst.Add(obj);
}
return(lst);
}
catch (Exception ex)
{
throw ex;
}
}
public static bool UpdateLawyerInfo(ATTLawyerInfoSearch objLInfo)
{
GetConnection GetConn = new GetConnection();
OracleTransaction Tran = GetConn.GetDbConn(Module.LJMS).BeginTransaction();
string sp = "SP_EDIT_LAWYER_INFO_STATUS";
List <OracleParameter> paramArray = new List <OracleParameter>();
paramArray.Add(Utilities.GetOraParam("p_P_ID", objLInfo.PERSONID, OracleDbType.Int16, ParameterDirection.Input));
paramArray.Add(Utilities.GetOraParam("p_LTypeID", objLInfo.LTYPEID, OracleDbType.Int16, ParameterDirection.Input));
paramArray.Add(Utilities.GetOraParam("p_LicenceNo", objLInfo.LICENSENO, OracleDbType.Varchar2, ParameterDirection.Input));
paramArray.Add(Utilities.GetOraParam("p_active", objLInfo.ACTIVE, OracleDbType.Varchar2, ParameterDirection.Input));
try
{
SqlHelper.ExecuteNonQuery(Tran, CommandType.StoredProcedure, sp, paramArray.ToArray());
Tran.Commit();
return(true);
}
catch (Exception ex)
{
Tran.Rollback();
throw ex;
}
finally
{
GetConn.CloseDbConn();
}
}
private ATTLawyerInfoSearch GetFilter()
{
try
{
ATTLawyerInfoSearch objLIsrch = new ATTLawyerInfoSearch();
if (this.optNBA.Checked == true)
{
objLIsrch.PLRENEWALUPTO = this.txtDate.Text.Trim();
}
else if (this.optNBC.Checked == true)
{
objLIsrch.LRENEWALUPTO = this.txtDate.Text.Trim();
}
if (txtToDate.Text != "")
{
objLIsrch.TODATE = this.txtToDate.Text.Trim();
}
if (this.ddlUnit.SelectedIndex > 0)
{
objLIsrch.UNITID = int.Parse(this.ddlUnit.SelectedValue.ToString());
}
if (this.ddlType.SelectedIndex > 0)
{
objLIsrch.LTYPEID = int.Parse(this.ddlType.SelectedValue.ToString());
}
if (this.chkInRange.Checked)
{
objLIsrch.INRANGE = "Y";
}
else
{
objLIsrch.INRANGE = "N";
}
return(objLIsrch);
}
catch (Exception ex)
{
throw (ex);
}
}
//public static DataTable tblL;
//public static DataTable tblLR;
//public static DataTable tblPL;
//public static DataTable tblPLR;
public static bool UpdateLawyerDetails(ATTLawyerInfoSearch objLInfo)
{
try
{
if (DLLLawyer.UpdateLawyerInfo(objLInfo))
{
return(true);
}
else
{
return(false);
}
}
catch (Exception ex)
{
throw (ex);
}
}
public static List <ATTLawyerInfoSearch> getDuplicateEntry(string strFilter)
{
List <ATTLawyerInfoSearch> lst = new List <ATTLawyerInfoSearch>();
try
{
foreach (DataRow row in DLLLawyerInfoSearch.GetDuplicateLawyer(strFilter).Rows)
{
ATTLawyerInfoSearch obj = new ATTLawyerInfoSearch();
obj.PERSONID = double.Parse(row["p_id"].ToString());
obj.FNAME = row["FIRST_NAME"].ToString();
obj.MNAME = row["MID_NAME"].ToString() == "" ? "" : row["MID_NAME"].ToString();
obj.LNAME = row["SUR_NAME"].ToString();
obj.LICENSENO = row["license_no"].ToString();
obj.LTYPEID = int.Parse(row["lawyer_type_id"].ToString());
obj.LTYPE = row["lawyer_type_description"].ToString();
obj.LRENEWALUPTO = row["lawyer_last_ren_date"].ToString();
int?unitId;
if (row["unit_id"].ToString() == "")
{
unitId = null;
}
else
{
unitId = int.Parse(row["unit_id"].ToString());
}
obj.UNITID = unitId;
obj.UNITNAME = row["unit_name"].ToString() == "" ? "" : row["unit_name"].ToString();
obj.PLRENEWALUPTO = row["p_lawyer_last_ren_date"].ToString() == "" ? "" : row["p_lawyer_last_ren_date"].ToString();
lst.Add(obj);
}
return(lst);
}
catch (Exception ex)
{
throw ex;
}
}
protected void grdDisplay_RowDeleting(object sender, GridViewDeleteEventArgs e)
{
GridViewRow row = grdDisplay.Rows[e.RowIndex];
LinkButton lnkBtn = (LinkButton)row.Cells[9].Controls[0];
int pID = int.Parse(row.Cells[1].Text);
ATTLawyerInfoSearch objLInfo = new ATTLawyerInfoSearch();
objLInfo.PERSONID = int.Parse(row.Cells[1].Text);
objLInfo.LTYPEID = int.Parse(row.Cells[10].Text);
objLInfo.LICENSENO = row.Cells[11].Text;
string active = "";
if (row.Cells[8].Text.Trim() == "N" || row.Cells[8].Text.Trim() == "")
{
active = "Y";
}
else if (row.Cells[8].Text.Trim() == "Y")
{
active = "N";
}
objLInfo.ACTIVE = active;
if (BLLLawyer.UpdateLawyerDetails(objLInfo))
{
row.Cells[8].Text = active;
if (active == "N")
{
lnkBtn.Text = "निष्कृय";
row.ForeColor = System.Drawing.Color.Red;
}
else
{
lnkBtn.Text = "सक्रिय";
row.ForeColor = System.Drawing.Color.FromArgb(51, 51, 51);
}
}
}
public static DataTable GetLawyerInfoSearchTbl(ATTLawyerInfoSearch objLISrch)
{
try
{
GetConnection GetConn = new GetConnection();
OracleConnection DBConn = GetConn.GetDbConn(Module.LJMS);
string selectSQL = "SELECT * FROM VW_LAWYER_INFO WHERE 1=1 ";
int i = 0;
#region
/*
* if (objLISrch.UNITID != null)
* i++;
* if (objLISrch.LTYPEID != null)
* i++;
* if (objLISrch.LGENDER != null)
* i++;
* if (objLISrch.LICENSENO != null)
* i++;
* if (objLISrch.FNAME != null)
* i++;
* if (objLISrch.SURNAME != null)
* i++;
* if (objLISrch.LRENEWALUPTO != null)
* i++;
* if (objLISrch.PLRENEWALUPTO != null)
* i++;
* if (objLISrch.PERSONID != null)
* i++;
* if (objLISrch.LAWYERID != null)
* i++;
* if (objLISrch.PLAWYERID != null)
* i++;
*/
# endregion
if (objLISrch.FNAME != null)
{
i++;
}
if (objLISrch.SURNAME != null)
{
i++;
}
if (objLISrch.LICENSENO != null)
{
i++;
}
if (objLISrch.LTYPEID != null)
{
i++;
}
if (objLISrch.LRENEWALUPTO != null && objLISrch.LRENEWALUPTO != "")
{
i++;
}
if (objLISrch.UNITID != null)
{
i++;
}
if (objLISrch.PLRENEWALUPTO != null && objLISrch.PLRENEWALUPTO != "")
{
i++;
}
if (objLISrch.TODATE != null && objLISrch.TODATE != "")
{
i++;
}
OracleParameter[] ParamArray = new OracleParameter[i];
int j = 0;
if (objLISrch.FNAME != null)
{
selectSQL = selectSQL + " AND first_name LIKE :FName||'%'";
ParamArray[j] = Utilities.GetOraParam(":FName", objLISrch.FNAME, OracleDbType.Varchar2, ParameterDirection.Input);
j++;
}
if (objLISrch.SURNAME != null)
{
selectSQL = selectSQL + " AND sur_name LIKE :SName||'%'";
ParamArray[j] = Utilities.GetOraParam(":SName", objLISrch.SURNAME, OracleDbType.Varchar2, ParameterDirection.Input);
j++;
}
if (objLISrch.LICENSENO != null)
{
selectSQL = selectSQL + " AND license_no = :LicenseNo";
ParamArray[j] = Utilities.GetOraParam(":LicenseNo", objLISrch.LICENSENO, OracleDbType.Varchar2, ParameterDirection.Input);
j++;
}
if (objLISrch.LTYPEID != null)
{
selectSQL = selectSQL + " AND lawyer_type_id=:LTypeID";
ParamArray[j] = Utilities.GetOraParam(":LTypeID", objLISrch.LTYPEID, OracleDbType.Int16, ParameterDirection.Input);
j++;
}
//if (objLISrch.LRENEWALUPTO != null && objLISrch.LRENEWALUPTO != "")
//{
// selectSQL = selectSQL + " AND lawyer_last_ren_upto <= :LRenewalUpto";
// ParamArray[j] = Utilities.GetOraParam(":LRenewalUpto", objLISrch.LRENEWALUPTO, OracleDbType.Varchar2, ParameterDirection.Input);
// j++;
//}
if (objLISrch.LRENEWALUPTO != null && objLISrch.LRENEWALUPTO != "")
{
if (objLISrch.INRANGE.Trim() == "Y")
{
selectSQL = selectSQL + " AND lawyer_last_ren_upto between :LRenewalUpto AND :ToDate";
}
else
{
selectSQL = selectSQL + " AND lawyer_last_ren_upto not between :LRenewalUpto AND :ToDate";
}
ParamArray[j] = Utilities.GetOraParam(":LRenewalUpto", objLISrch.LRENEWALUPTO, OracleDbType.Varchar2, ParameterDirection.Input);
j++;
ParamArray[j] = Utilities.GetOraParam(":ToDate", objLISrch.TODATE, OracleDbType.Varchar2, ParameterDirection.Input);
j++;
}
if (objLISrch.UNITID != null)
{
selectSQL = selectSQL + " AND unit_id=:UnitID";
ParamArray[j] = Utilities.GetOraParam(":UnitID", objLISrch.UNITID, OracleDbType.Int16, ParameterDirection.Input);
j++;
}
//if (objLISrch.PLRENEWALUPTO != null && objLISrch.PLRENEWALUPTO != "")
//{
// selectSQL = selectSQL + " AND p_lawyer_last_ren_upto <= :PLRenewalUpto";
// ParamArray[j] = Utilities.GetOraParam(":PLRenewalUpto", objLISrch.PLRENEWALUPTO, OracleDbType.Varchar2, ParameterDirection.Input);
// j++;
//}
if (objLISrch.PLRENEWALUPTO != null && objLISrch.PLRENEWALUPTO != "")
{
if (objLISrch.INRANGE.Trim() == "Y")
{
selectSQL = selectSQL + " AND p_lawyer_last_ren_upto between :PLRenewalUpto AND :ToDate";
}
else
{
selectSQL = selectSQL + " AND p_lawyer_last_ren_upto not between :PLRenewalUpto AND :ToDate";
}
ParamArray[j] = Utilities.GetOraParam(":PLRenewalUpto", objLISrch.PLRENEWALUPTO, OracleDbType.Varchar2, ParameterDirection.Input);
j++;
ParamArray[j] = Utilities.GetOraParam(":ToDate", objLISrch.TODATE, OracleDbType.Varchar2, ParameterDirection.Input);
j++;
}
#region
/*
*
* if (objLISrch.UNITID != null)
* {
* selectSQL = selectSQL + " AND UNIT_ID=:UnitID";
* ParamArray[j] = Utilities.GetOraParam(":UnitID", objLISrch.UNITID, OracleDbType.Int16, ParameterDirection.Input);
* j++;
* }
* if (objLISrch.LTYPEID != null)
* {
* selectSQL = selectSQL + " AND LTYPE_ID=:LTypeID";
* ParamArray[j] = Utilities.GetOraParam(":LTypeID", objLISrch.LTYPEID, OracleDbType.Int16, ParameterDirection.Input);
* j++;
* }
* if (objLISrch.LGENDER != null)
* {
* selectSQL = selectSQL + " AND L_GENDER=:Gender";
* ParamArray[j] = Utilities.GetOraParam(":Gender", objLISrch.LGENDER, OracleDbType.Varchar2, ParameterDirection.Input);
* j++;
* }
*
*
* if (objLISrch.LICENSENO != null)
* {
* selectSQL = selectSQL + " AND LICENSE_NO = :LicenseNo";
* ParamArray[j] = Utilities.GetOraParam(":LicenseNo", objLISrch.LICENSENO, OracleDbType.Varchar2, ParameterDirection.Input);
* j++;
* }
*
* if (objLISrch.FNAME != null)
* {
* selectSQL = selectSQL + " AND FIRST_NAME LIKE :FName||'%'";
* ParamArray[j] = Utilities.GetOraParam(":FName", objLISrch.FNAME, OracleDbType.Varchar2, ParameterDirection.Input);
* j++;
* }
*
* if (objLISrch.SURNAME != null)
* {
* selectSQL = selectSQL + " AND SUR_NAME LIKE :SName||'%'";
* ParamArray[j] = Utilities.GetOraParam(":SName", objLISrch.SURNAME, OracleDbType.Varchar2, ParameterDirection.Input);
* j++;
* }
*
* if (objLISrch.LRENEWALUPTO != null)
* {
* selectSQL = selectSQL + " AND L_RENEWAL_UPTO <= :LRenewalUpto";
* ParamArray[j] = Utilities.GetOraParam(":LRenewalUpto", objLISrch.LRENEWALUPTO, OracleDbType.Varchar2, ParameterDirection.Input);
* j++;
* }
*
* if (objLISrch.PLRENEWALUPTO != null)
* {
* selectSQL = selectSQL + " AND PL_RENEWAL_UPTO <= :PLRenewalUpto";
* ParamArray[j] = Utilities.GetOraParam(":PLRenewalUpto", objLISrch.PLRENEWALUPTO, OracleDbType.Varchar2, ParameterDirection.Input);
* j++;
* }
*
* if (objLISrch.PERSONID != null)
* {
* selectSQL = selectSQL + " AND P_ID = :PID";
* ParamArray[j] = Utilities.GetOraParam(":PID", objLISrch.PERSONID, OracleDbType.Int16, ParameterDirection.Input);
* j++;
* }
*
* if (objLISrch.LAWYERID != null)
* {
* selectSQL = selectSQL + " AND L_ID = :LID";
* ParamArray[j] = Utilities.GetOraParam(":LID", objLISrch.LAWYERID, OracleDbType.Int16, ParameterDirection.Input);
* j++;
* }
*
* if (objLISrch.PLAWYERID != null)
* {
* selectSQL = selectSQL + " AND PL_ID = :PLID";
* ParamArray[j] = Utilities.GetOraParam(":PLID", objLISrch.PLAWYERID, OracleDbType.Int16, ParameterDirection.Input);
* j++;
* }
*/
#endregion
selectSQL = selectSQL + " order by lawyer_type_id ";
DataSet ds = SqlHelper.ExecuteDataset(DBConn, CommandType.Text, selectSQL, ParamArray);
DataTable tbl = new DataTable();
tbl = (DataTable)ds.Tables[0];
return(tbl);
}
