private void WebForm1_BubbleClick(object sender, EventArgs e)
{
grdSrchPurchaseOrder.SelectedIndex = -1;
ATTInvSrchPurchaseOrder objSrchPo = (ATTInvSrchPurchaseOrder)Session["SrchRecmCriteria"];
LoadSearchedData(objSrchPo);
}
protected void btnSearch_Click(object sender, EventArgs e)
{
try
{
ATTInvSrchPurchaseOrder objSrchPo = new ATTInvSrchPurchaseOrder();
//if(ddlUnit_rqd.SelectedIndex > 0)
// objSrchPo.UnitID = int.Parse(ddlUnit_rqd.SelectedValue);
if (txtOrderNo.Text != "")
{
objSrchPo.OrderNo = txtOrderNo.Text;
}
if (txtODate_DT.Text != "")
{
objSrchPo.OrderDate = txtODate_DT.Text;
}
if (ddlSupplier.SelectedIndex > 0)
{
objSrchPo.SupplierID = int.Parse(ddlSupplier.SelectedValue);
}
LoadSearchedData(objSrchPo);
}
catch (Exception ex)
{
throw(ex);
}
}
public void LoadSearchedData(ATTInvSrchPurchaseOrder objSrchPo)
{
try
{
List <ATTInvPurchaseOrder> lstSearchedPurOrder = new List <ATTInvPurchaseOrder>();
lstSearchedPurOrder = BLLInvSrchPurchaseOrder.SrchPurchaseOrder(objSrchPo, 1);
if (lstSearchedPurOrder.Count > 0)
{
grdSrchPurchaseOrder.SelectedIndex = -1;
grdSrchPurchaseOrder.DataSource = lstSearchedPurOrder;
grdSrchPurchaseOrder.DataBind();
Session["lstSrchRecmPurOrder"] = lstSearchedPurOrder;
Session["SrchRecmCriteria"] = objSrchPo;
}
else
{
lblCount.Text = "कुनै पनि रेकर्ड भेटिएन्न् !!!! ";
//lblCount.Text = "";
grdSrchPurchaseOrder.DataSource = "";
grdSrchPurchaseOrder.DataBind();
}
ClearItemsDetailControls();
}
catch (Exception ex)
{
throw (ex);
}
}
protected void btnSearch_Click(object sender, EventArgs e)
{
try
{
Session["SrchCriteria"] = null;
ATTInvSrchPurchaseOrder objSrchPo = new ATTInvSrchPurchaseOrder();
if (txtOrderNo_rqd.Text != "")
{
objSrchPo.OrderNo = txtOrderNo_rqd.Text;
}
if (txtODate_DT.Text != "")
{
objSrchPo.OrderDate = txtODate_DT.Text;
}
if (ddlSupplier_rqd.SelectedIndex > 0)
{
objSrchPo.SupplierID = int.Parse(ddlSupplier_rqd.SelectedValue);
}
LoadSearchedData(objSrchPo);
}
catch (Exception ex)
{
throw(ex);
}
}
public static List <ATTInvPurchaseOrder> SrchPurchaseOrder(ATTInvSrchPurchaseOrder objSrchPo, int type)
{
try
{
List <ATTInvPurchaseOrder> lst = new List <ATTInvPurchaseOrder>();
foreach (DataRow row in DLLInvSrchPurchaseOrder.SrchPurchaseOrder(objSrchPo, type).Rows)
{
ATTInvPurchaseOrder obj = new ATTInvPurchaseOrder();
int?recby = null;
int?appby = null;
if (row["REC_BY"].ToString() != "")
{
recby = int.Parse(row["REC_BY"].ToString());
}
if (row["APP_BY"].ToString() != "")
{
appby = int.Parse(row["APP_BY"].ToString());
}
obj.OrgID = int.Parse(row["ORG_ID"].ToString());
obj.SupplierID = int.Parse(row["SUPPLIERS_ID"].ToString());
obj.SupplierName = row["SUPPLIERS_NAME"].ToString();
obj.OrderDate = row["ORDER_DATE"].ToString();
obj.OrderNo = row["ORDER_NO"].ToString();
obj.RecBy = recby;
obj.RecDate = row["REC_DATE"].ToString();
obj.RecYesNo = row["REC_YES_NO"].ToString();
obj.AppBy = appby;
obj.AppDate = row["APP_DATE"].ToString();
obj.AppYesNo = row["APP_YES_NO"].ToString();
lst.Add(obj);
}
return(lst);
}
catch (Exception ex)
{
throw (ex);
}
}
public static DataTable SrchPurchaseOrder(ATTInvSrchPurchaseOrder objSrchPo, int type)
{
GetConnection GetConn = new GetConnection();
OracleConnection DBConn = GetConn.GetDbConn(Module.OAS);
OracleTransaction Tran = DBConn.BeginTransaction();
try
{
string srchSQL = " SELECT distinct ORG_ID,SUPPLIERS_ID,SUPPLIERS_NAME,ORDER_DATE,ORDER_NO, "
+ " REC_BY,REC_DATE,REC_YES_NO,APP_BY,APP_DATE,APP_YES_NO "
+ " FROM vw_inv_purchase_orders WHERE 1=1";
if (type == 1)
{
srchSQL = srchSQL + " AND REC_YES_NO IS NULL AND APP_YES_NO IS NULL";
}
else if (type == 2)
{
srchSQL = srchSQL + " AND REC_YES_NO IS NOT NULL AND APP_YES_NO IS NULL";
}
List <OracleParameter> paramArray = new List <OracleParameter>();
if (objSrchPo.UnitID > 0)
{
srchSQL = srchSQL + " AND UNIT_ID=:unit_id";
paramArray.Add(Utilities.GetOraParam(":unit_id", objSrchPo.UnitID, OracleDbType.Int32, ParameterDirection.Input));
}
if (objSrchPo.SectionID > 0)
{
srchSQL = srchSQL + " AND SECTION_ID=:section_id";
paramArray.Add(Utilities.GetOraParam(":unit_id", objSrchPo.SectionID, OracleDbType.Int32, ParameterDirection.Input));
}
if (objSrchPo.OrderNo.Trim() != "")
{
srchSQL = srchSQL + " AND ORDER_NO =:order_no ";
paramArray.Add(Utilities.GetOraParam(":order_no", objSrchPo.OrderNo, OracleDbType.Varchar2, ParameterDirection.Input));
}
if (objSrchPo.OrderDate.Trim() != "")
{
srchSQL = srchSQL + " AND ORDER_DATE =:order_date ";
paramArray.Add(Utilities.GetOraParam(":order_date", objSrchPo.OrderDate, OracleDbType.Varchar2, ParameterDirection.Input));
}
if (objSrchPo.SupplierID > 0)
{
srchSQL = srchSQL + " AND SUPPLIERS_ID=:supplier_id";
paramArray.Add(Utilities.GetOraParam(":supplier_id", objSrchPo.SupplierID, OracleDbType.Int32, ParameterDirection.Input));
}
return(SqlHelper.ExecuteDataset(CommandType.Text, srchSQL, Module.OAS, paramArray.ToArray()).Tables[0]);
}
catch (Exception ex)
{
throw ex;
}
}
