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; }