public void LoadSearchedData(ATTInvSrchDeliveryOrder objSrchDo) { try { btnCancel_Click(null, null); List <ATTInvDeliveryOrder> lstSrchedDeliveredOrder = new List <ATTInvDeliveryOrder>(); lstSrchedDeliveredOrder = BLLInvSrchDeliveryOrder.SrchDeliveredOrder(objSrchDo); if (lstSrchedDeliveredOrder.Count > 0) { grdDelivery.SelectedIndex = -1; grdDelivery.DataSource = lstSrchedDeliveredOrder; grdDelivery.DataBind(); Session["lstSrchedDeliveredOrder"] = lstSrchedDeliveredOrder; Session["SrchRetCriteria"] = objSrchDo; } else { lblDeliveryCount.Text = "कुनै पनि रेकर्ड भेटिएन्न् !!!! "; grdDelivery.DataSource = ""; grdDelivery.DataBind(); Session["lstSrchedDeliveredOrder"] = null; } } catch (Exception) { throw; } }
public void ReloadSrchData() { try { if (Session["SrchRetCriteria"] != null) { ATTInvSrchDeliveryOrder objSrchDo = (ATTInvSrchDeliveryOrder)Session["SrchRetCriteria"]; GridView grdDelivery = (GridView)this.ReturnOrder1.FindControl("grdDelivery"); List <ATTInvDeliveryOrder> lstSrchedDeliveredOrder = new List <ATTInvDeliveryOrder>(); lstSrchedDeliveredOrder = BLLInvSrchDeliveryOrder.SrchDeliveredOrder(objSrchDo); if (lstSrchedDeliveredOrder.Count > 0) { grdDelivery.SelectedIndex = -1; grdDelivery.DataSource = lstSrchedDeliveredOrder; grdDelivery.DataBind(); Session["lstSrchedDeliveredOrder"] = lstSrchedDeliveredOrder; } else { grdDelivery.DataSource = ""; grdDelivery.DataBind(); } } } catch (Exception) { throw; } }
public static List <ATTInvDeliveryOrderDetail> SrchDeliveryOrder(ATTInvSrchDeliveryOrder objSrchDo) { try { List <ATTInvDeliveryOrderDetail> lst = new List <ATTInvDeliveryOrderDetail>(); foreach (DataRow row in DLLInvSrchDeliveryOrder.SrchDeliveryOrder(objSrchDo).Rows) { ATTInvDeliveryOrderDetail obj = new ATTInvDeliveryOrderDetail(); obj.OrgID = int.Parse(row["ORG_ID"].ToString()); obj.OrderNo = row["ORDER_NO"].ToString(); obj.ItemsCategoryID = int.Parse(row["ITEMS_CATEGORY_ID"].ToString()); obj.ItemsCategoryName = row["ITEMS_CATEGORY_NAME"].ToString(); obj.ItemsSubCategoryID = int.Parse(row["ITEMS_SUB_CATEGORY_ID"].ToString()); obj.ItemsSubCategoryName = row["ITEMS_SUB_CATEGORY_NAME"].ToString(); obj.ItemsID = int.Parse(row["ITEMS_ID"].ToString()); obj.ItemsName = row["ITEMS_NAME"].ToString(); obj.RequiredQty = int.Parse(row["TOTAL_QUANTITY"].ToString()); obj.DeliveredQty = row["TOTAL_DELIVERED"].ToString() == "" ? 0 : int.Parse(row["TOTAL_DELIVERED"].ToString()); obj.ApproveDate = row["app_date"].ToString(); obj.SeqNo = int.Parse(row["SEQ_NO"].ToString()); lst.Add(obj); } return(lst); } catch (Exception ex) { throw (ex); } }
public static DataTable SrchDeliveryOrder(ATTInvSrchDeliveryOrder objSrchDo) { GetConnection GetConn = new GetConnection(); OracleConnection DBConn = GetConn.GetDbConn(Module.OAS); OracleTransaction Tran = DBConn.BeginTransaction(); try { string srchSQL = " SELECT * FROM vw_inv_delivery_orders WHERE 1=1 AND TOTAL_QUANTITY > TOTAL_DELIVERED "; List <OracleParameter> paramArray = new List <OracleParameter>(); if (objSrchDo.OrderNo.Trim() != "") { srchSQL = srchSQL + " AND ORDER_NO =:order_no "; paramArray.Add(Utilities.GetOraParam(":order_no", objSrchDo.OrderNo, OracleDbType.Varchar2, ParameterDirection.Input)); } return(SqlHelper.ExecuteDataset(CommandType.Text, srchSQL, Module.OAS, paramArray.ToArray()).Tables[0]); } catch (Exception ex) { throw ex; } }
public void LoadSearchedData(ATTInvSrchDeliveryOrder objSrchDo) { try { List <ATTInvDeliveryOrderDetail> lstSearchedDeliveryOrder = new List <ATTInvDeliveryOrderDetail>(); lstSearchedDeliveryOrder = BLLInvSrchDeliveryOrder.SrchDeliveryOrder(objSrchDo); Panel pnlDeliveryOrder = (Panel)this.DeliveryOrder1.FindControl("pnlDeliveryOrder"); if (lstSearchedDeliveryOrder.Count > 0) { pnlDeliveryOrder.Visible = true; TextBox txtOrderNo = (TextBox)this.DeliveryOrder1.FindControl("txtOrderNo"); TextBox txtApproveDate = (TextBox)this.DeliveryOrder1.FindControl("txtApproveDate"); txtOrderNo.Text = lstSearchedDeliveryOrder[0].OrderNo; txtApproveDate.Text = lstSearchedDeliveryOrder[0].ApproveDate; grdDeliveryDetails.SelectedIndex = -1; grdDeliveryDetails.DataSource = lstSearchedDeliveryOrder; grdDeliveryDetails.DataBind(); Session["lstSrchDelivOrder"] = lstSearchedDeliveryOrder; Session["DelivSrchCriteria"] = objSrchDo; } else { pnlDeliveryOrder.Visible = false; lblCount.Text = "कुनै पनि रेकर्ड भेटिएन्न् !!!!"; grdDeliveryDetails.DataSource = ""; grdDeliveryDetails.DataBind(); } } catch (Exception) { throw; } }
protected void btnSearch_Click(object sender, EventArgs e) { try { Session["DelivSrchCriteria"] = null; ATTInvSrchDeliveryOrder objSrchDo = new ATTInvSrchDeliveryOrder(); if (txtOrderNo_rqd.Text != "") { objSrchDo.OrderNo = txtOrderNo_rqd.Text; } LoadSearchedData(objSrchDo); } catch (Exception ex) { throw(ex); } }
public static DataTable SrchDeliveredOrder(ATTInvSrchDeliveryOrder objSrchDo) { GetConnection GetConn = new GetConnection(); OracleConnection DBConn = GetConn.GetDbConn(Module.OAS); OracleTransaction Tran = DBConn.BeginTransaction(); try { //string srchSQL = " SELECT DISTINCT org_id, order_no, delivery_seq, delivery_person," // +"delivery_date, rcvd_by, rcvd_date, invoice_no," // + "first_name,mid_name,sur_name " // + " FROM vw_inv_delivered_orders " // + " WHERE 1=1 AND delivery_qty <> 0 "; string srchSQL = " SELECT DISTINCT org_id, order_no, delivery_seq, delivery_person," + "delivery_date, rcvd_by, rcvd_date, invoice_no," + "first_name,mid_name,sur_name " + " FROM vw_inv_delivered_orders " + " WHERE 1=1 AND total_delivered > total_returned "; //AND delivery_qty > total_returned List <OracleParameter> paramArray = new List <OracleParameter>(); if (objSrchDo.OrderNo.Trim() != "") { srchSQL = srchSQL + " AND ORDER_NO =:order_no "; paramArray.Add(Utilities.GetOraParam(":order_no", objSrchDo.OrderNo, OracleDbType.Varchar2, ParameterDirection.Input)); } return(SqlHelper.ExecuteDataset(CommandType.Text, srchSQL, Module.OAS, paramArray.ToArray()).Tables[0]); } catch (Exception ex) { throw ex; } }
public static List <ATTInvDeliveryOrder> SrchDeliveredOrder(ATTInvSrchDeliveryOrder objSrchDo) { try { List <ATTInvDeliveryOrder> lst = new List <ATTInvDeliveryOrder>(); DataTable tbl = new DataTable(); tbl = DLLInvSrchDeliveryOrder.SrchDeliveredOrder(objSrchDo); foreach (DataRow row in tbl.Rows) { ATTInvDeliveryOrder obj = new ATTInvDeliveryOrder(); obj.OrgID = int.Parse(row["ORG_ID"].ToString()); obj.OrderNo = row["ORDER_NO"].ToString(); obj.DeliverySeq = int.Parse(row["DELIVERY_SEQ"].ToString()); obj.DeliveryPerson = row["DELIVERY_PERSON"].ToString(); obj.DeliveryDate = row["DELIVERY_DATE"].ToString(); obj.ReceiverID = int.Parse(row["RCVD_BY"].ToString()); obj.ReceiverName = row["FIRST_NAME"].ToString() + (row["MID_NAME"].ToString() == "" ? "" : " " + row["MID_NAME"].ToString()) + (row["SUR_NAME"].ToString() == "" ? "" : " " + row["SUR_NAME"].ToString()); obj.ReceivedDate = row["RCVD_DATE"].ToString(); obj.InvoiceNo = row["INVOICE_NO"].ToString(); lst.Add(obj); } return(lst); } catch (Exception ex) { throw(ex); } }
protected void btnSearch_Click(object sender, EventArgs e) { try { ATTInvSrchDeliveryOrder objSrchDo = new ATTInvSrchDeliveryOrder(); if (ddlUnit_srch.SelectedIndex > 0) { objSrchDo.UnitID = int.Parse(ddlUnit_srch.SelectedValue); } if (txtOrderNo_srch.Text != "") { objSrchDo.OrderNo = txtOrderNo_srch.Text; } LoadSearchedData(objSrchDo); } catch (Exception ex) { throw (ex); } }