public static List <ATTGeneralTippaniSearch> GetTippaniDetails(ATTGeneralTippaniSearch objTipp)
{
List <ATTGeneralTippaniSearch> lst = new List <ATTGeneralTippaniSearch>();
try
{
DataTable dt = DLLGeneralTippaniSearch.GetTippaniDetails(objTipp);
foreach (DataRow row in dt.Rows)
{
ATTGeneralTippaniSearch obj = new ATTGeneralTippaniSearch();
obj.OrgID = int.Parse(row["ORG_ID"].ToString());
obj.TippaniID = int.Parse(row["TIPPANI_ID"].ToString());
obj.TippaniSubjectID = int.Parse(row["TIPPANI_SUBJECT_ID"].ToString());
obj.TippaniSubject = row["TIPPANI_SUBJECT_NAME"].ToString();
obj.TippaniOn = row["TIPPANI_ON"].ToString();
obj.TippaniText = row["TIPPANI_TEXT"].ToString();
obj.FileNo = int.Parse(row["FILE_NO"].ToString());
obj.TippaniStatus = row["TIPPANI_STATUS_NAME"].ToString();
lst.Add(obj);
}
return(lst);
}
catch (Exception)
{
throw;
}
}
public static DataTable GetTippaniDetails(ATTGeneralTippaniSearch obj)
{
string query = "SELECT ORG_ID, TIPPANI_ID, TIPPANI_SUBJECT_ID,TIPPANI_SUBJECT_NAME,"
+ "TIPPANI_ON, TIPPANI_TEXT,FILE_NO,FINAL_STATUS,TIPPANI_STATUS_NAME,"
+ "ORG_NAME FROM VW_TIPPANI_INFO WHERE 1=1";
List <OracleParameter> paramArray = new List <OracleParameter>();
if (obj.OrgID > 0)
{
query += " AND ORG_ID=:org_id";
paramArray.Add(Utilities.GetOraParam(":org_id", obj.OrgID, OracleDbType.Int16, ParameterDirection.Input));
}
if (obj.TippaniSubjectID > 0)
{
query += " AND TIPPANI_SUBJECT_ID=:tip_sub_id";
paramArray.Add(Utilities.GetOraParam(":tip_sub_id", obj.TippaniSubjectID, OracleDbType.Int16, ParameterDirection.Input));
}
if (obj.FileNo > 0)
{
query += " AND FILE_NO=:file_no";
paramArray.Add(Utilities.GetOraParam(":file_no", obj.FileNo, OracleDbType.Int16, ParameterDirection.Input));
}
if (obj.FromDate != "" && obj.ToDate != "")
{
query += " AND TIPPANI_ON >=:from_date AND TIPPANI_ON <=:to_date";
paramArray.Add(Utilities.GetOraParam(":from_date", obj.FromDate, OracleDbType.Varchar2, ParameterDirection.Input));
paramArray.Add(Utilities.GetOraParam(":to_date", obj.ToDate, OracleDbType.Varchar2, ParameterDirection.Input));
}
if (obj.FinalStatus > 0)
{
query += " AND FINAL_STATUS=:final_status";
paramArray.Add(Utilities.GetOraParam(":final_status", obj.FinalStatus, OracleDbType.Int16, ParameterDirection.Input));
}
try
{
GetConnection DBcon = new GetConnection();
OracleConnection con = DBcon.GetDbConn(Module.OAS);
return(SqlHelper.ExecuteDataset(con, CommandType.Text, query, paramArray.ToArray()).Tables[0]);
}
catch (Exception ex)
{
throw ex;
}
}
protected void searchBtn_Click(object sender, EventArgs e)
{
ATTGeneralTippaniSearch obj = new ATTGeneralTippaniSearch();
if (ddlOrg_Rqd.SelectedIndex < 1)
{
this.lblStatusMessage.Text = "Please select organisation";
this.programmaticModalPopup.Show();
return;
}
if (ddlTipaniSubject_Rqd.SelectedIndex < 1)
{
this.lblStatusMessage.Text = "Please select Tippani Subject";
this.programmaticModalPopup.Show();
return;
}
obj.OrgID = int.Parse(this.ddlOrg_Rqd.SelectedValue);
obj.TippaniSubjectID = int.Parse(this.ddlTipaniSubject_Rqd.SelectedValue);
if (fileNoTxt.Text == "")
{
obj.FileNo = 0;
}
else
{
obj.FileNo = int.Parse(this.fileNoTxt.Text);
}
obj.FromDate = this.fromDateTxt.Text;
obj.ToDate = this.toDateTxt.Text;
obj.FinalStatus = int.Parse(this.ddlTippaniStatus.SelectedValue);
List <ATTGeneralTippaniSearch> lst = BLLGeneralTippaniSearch.GetTippaniDetails(obj);
this.tippaniDetailGrid.DataSource = lst;
this.tippaniDetailGrid.DataBind();
this.gridDiv.Visible = true;
}
