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