public static int RecomendApprovePurchaseOrder(ATTInvPurchaseOrder objPo) { try { return(DLLInvPurchaseOrder.RecomendApprovePurchaseOrder(objPo)); } 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 int CheckPurOrderAvailability(ATTInvPurchaseOrder objPo, OracleTransaction Tran) { try { string chkPurOrderSQL = "SELECT CHECK_PUR_ORDER_AVAILABILITY(" + objPo.OrgID + ",'" + objPo.OrderNo + "')" + "FROM DUAL"; DataSet ds = SqlHelper.ExecuteDataset(Tran, CommandType.Text, chkPurOrderSQL); DataTable tbl = new DataTable(); tbl = (DataTable)ds.Tables[0]; int orderCount = int.Parse(tbl.Rows[0][0].ToString()); return(orderCount); } catch (Exception ex) { throw (ex); } }
protected void btnSubmit_Click(object sender, EventArgs e) { try { if (Session["CurrentDate"] != null && txtODate_RDT.Text != "") { if (CompareDate(Session["CurrentDate"].ToString(), txtODate_RDT.Text)) { bool flag = true; ATTInvPurchaseOrder objPo = new ATTInvPurchaseOrder(); objPo.OrgID = orgID; //objPo.UnitID = int.Parse(ddlUnit_rqd.SelectedValue); objPo.OrderNo = txtOrderNo_rqd.Text; objPo.OrderDate = txtODate_RDT.Text; objPo.SupplierID = int.Parse(ddlSupplier_rqd.SelectedValue); objPo.EntryBy = entryBy; objPo.Action = "A"; if (Session["PoDetail"] != null) { if (((List <ATTInvPurchaseOrderDetail>)Session["PoDetail"]).Count > 0) { objPo.lstPurchaseOrderDetail = (List <ATTInvPurchaseOrderDetail>)Session["PoDetail"]; } else { flag = false; } } else { flag = false; } if (flag) { int saveConfirm = BLLInvPurchaseOrder.SavePurchaseOrder(objPo); if (saveConfirm == 0) { ClearControls(); this.lblStatusMessageTitle.Text = "खरिद अर्डर "; this.lblStatusMessage.Text = "सफलतापूर्वक सेभ भयो!!!"; this.programmaticModalPopup.Show(); } else if (saveConfirm == -1) { this.lblStatusMessageTitle.Text = "खरिद अर्डर "; this.lblStatusMessage.Text = "अर्डर नंम्बर पहिला नै प्रयोग भइसक्यो!!!"; this.programmaticModalPopup.Show(); } else { this.lblStatusMessageTitle.Text = "खरिद अर्डर "; this.lblStatusMessage.Text = "सेभ गर्दा वाधा उत्पन्न भयो!!!"; this.programmaticModalPopup.Show(); } } else { this.lblStatusMessageTitle.Text = "खरिद अर्डर "; this.lblStatusMessage.Text = "कृपया खरिद गर्ने आइटम छान्नुहोस् ।!!!"; this.programmaticModalPopup.Show(); } } else { this.lblStatusMessageTitle.Text = "खरिद अर्डर "; this.lblStatusMessage.Text = "अर्डर मिति नागीसक्यो !!! त्यसैले अर्को अर्डर मिति राख्नुहोस्"; this.programmaticModalPopup.Show(); } } else { this.lblStatusMessageTitle.Text = "खरिद अर्डर "; this.lblStatusMessage.Text = "कृपया मिति राख्नुहोस् ।!!!"; this.programmaticModalPopup.Show(); } } catch (Exception ex) { this.lblStatusMessageTitle.Text = "Error Status"; this.lblStatusMessage.Text = ex.Message; this.programmaticModalPopup.Show(); } }
public static bool SavePurchaseOrderDetail(ATTInvPurchaseOrder objPo, OracleTransaction Tran) { try { string sp = ""; foreach (ATTInvPurchaseOrderDetail objPoDetail in objPo.lstPurchaseOrderDetail) { if (objPoDetail.Action == "A") { sp = "sp_inv_add_purchase_order_det"; } else if (objPoDetail.Action == "E") { sp = "sp_inv_edit_purchase_order_det"; } else if (objPoDetail.Action == "D") { sp = "sp_inv_del_purchase_order_det"; } if (objPoDetail.Action != "N" && sp != "") { objPoDetail.OrgID = objPo.OrgID; objPoDetail.UnitID = objPo.UnitID; objPoDetail.OrderNo = objPo.OrderNo; objPoDetail.EntryBy = objPo.EntryBy; List <OracleParameter> paramArray = new List <OracleParameter>(); paramArray.Add(Utilities.GetOraParam(":p_org_id", objPoDetail.OrgID, OracleDbType.Int64, ParameterDirection.Input)); paramArray.Add(Utilities.GetOraParam(":p_order_no", objPoDetail.OrderNo, OracleDbType.Varchar2, ParameterDirection.Input)); paramArray.Add(Utilities.GetOraParam(":p_items_category_id", objPoDetail.ItemsCategoryID, OracleDbType.Int64, ParameterDirection.Input)); paramArray.Add(Utilities.GetOraParam(":p_items_sub_category_id", objPoDetail.ItemsSubCategoryID, OracleDbType.Int64, ParameterDirection.Input)); paramArray.Add(Utilities.GetOraParam(":p_items_id", objPoDetail.ItemsID, OracleDbType.Int64, ParameterDirection.Input)); paramArray.Add(Utilities.GetOraParam(":p_seq_no", objPoDetail.SeqNo, OracleDbType.Int64, ParameterDirection.InputOutput)); if (sp != "sp_inv_del_purchase_order_det") { paramArray.Add(Utilities.GetOraParam(":p_manu_company", objPoDetail.ManuCompany, OracleDbType.Varchar2, ParameterDirection.Input)); paramArray.Add(Utilities.GetOraParam(":p_manu_date", objPoDetail.ManuDate, OracleDbType.Varchar2, ParameterDirection.Input)); paramArray.Add(Utilities.GetOraParam(":p_brand", objPoDetail.Brand, OracleDbType.Varchar2, ParameterDirection.Input)); paramArray.Add(Utilities.GetOraParam(":p_total_quantity", objPoDetail.TotalQty, OracleDbType.Int64, ParameterDirection.Input)); paramArray.Add(Utilities.GetOraParam(":p_unit_price", objPoDetail.UnitPrice, OracleDbType.Double, ParameterDirection.Input)); // paramArray.Add(Utilities.GetOraParam(":p_specifications", objPoDetail.Specification, OracleDbType.Varchar2, ParameterDirection.Input)); paramArray.Add(Utilities.GetOraParam(":p_entry_by", objPoDetail.EntryBy, OracleDbType.Varchar2, ParameterDirection.Input)); } SqlHelper.ExecuteNonQuery(Tran, CommandType.StoredProcedure, sp, paramArray.ToArray()); sp = ""; } } return(true); } catch (Exception ex) { throw (ex); } }
protected void btnSubmit_Click(object sender, EventArgs e) { try { if (i == 0)//to prevent the event below from executing more than 1 time { bool flag = true; ArrayList arrPoDetailInfo = new ArrayList(); if (type == 0) { if (Session["arrPoDetailInfo"] != null) { arrPoDetailInfo = (ArrayList)Session["arrPoDetailInfo"]; } } else if (type == 1) { if (Session["arrPoRecmDetailInfo"] != null) { arrPoDetailInfo = (ArrayList)Session["arrPoRecmDetailInfo"]; } } else if (type == 2) { if (Session["arrPoApprvDetailInfo"] != null) { arrPoDetailInfo = (ArrayList)Session["arrPoApprvDetailInfo"]; } } ATTInvPurchaseOrder objPo = new ATTInvPurchaseOrder(); objPo.OrgID = int.Parse(arrPoDetailInfo[0].ToString()); //objPo.UnitID = int.Parse(arrPoDetailInfo[1].ToString()); objPo.OrderNo = arrPoDetailInfo[4].ToString(); objPo.SupplierID = int.Parse(ddlSupplier.SelectedValue); objPo.OrderDate = txtOrderDate.Text; objPo.EntryBy = arrPoDetailInfo[6].ToString(); objPo.Type = int.Parse(arrPoDetailInfo[7].ToString()); if (arrPoDetailInfo[8].ToString() != "") { objPo.RecBy = int.Parse(arrPoDetailInfo[8].ToString()); } else { objPo.RecBy = null; } objPo.RecDate = arrPoDetailInfo[9].ToString(); objPo.RecYesNo = arrPoDetailInfo[10].ToString(); if (chkRecomend_rqd.Checked == true && txtRecomendDate_RDT.Text != "") { if (objPo.Type == 1) { objPo.RecYesNo = "Y"; objPo.RecDate = txtRecomendDate_RDT.Text; objPo.RecBy = int.Parse(arrPoDetailInfo[11].ToString()); } else if (objPo.Type == 2) { objPo.AppYesNo = "Y"; objPo.AppDate = txtRecomendDate_RDT.Text; objPo.AppBy = int.Parse(arrPoDetailInfo[11].ToString()); } } else { objPo.Type = 0; objPo.Action = "E"; } if (type == 0) { if (((List <ATTInvPurchaseOrderDetail>)Session["PoUpdDetail"]).Count > 0) { objPo.lstPurchaseOrderDetail = (List <ATTInvPurchaseOrderDetail>)Session["PoUpdDetail"]; } } else if (type == 1) { if (((List <ATTInvPurchaseOrderDetail>)Session["PoRecmUpdDetail"]).Count > 0) { objPo.lstPurchaseOrderDetail = (List <ATTInvPurchaseOrderDetail>)Session["PoRecmUpdDetail"]; } } else if (type == 2) { if (((List <ATTInvPurchaseOrderDetail>)Session["PoApprvUpdDetail"]).Count > 0) { objPo.lstPurchaseOrderDetail = (List <ATTInvPurchaseOrderDetail>)Session["PoApprvUpdDetail"]; } } else { flag = false; } if (flag) { int?updateConfirm = null; if (objPo.Type == 0) { updateConfirm = BLLInvPurchaseOrder.SavePurchaseOrder(objPo); } else if (objPo.Type == 1 || objPo.Type == 2) { updateConfirm = BLLInvPurchaseOrder.RecomendApprovePurchaseOrder(objPo); } if (updateConfirm == 0) { ClearItemsDetailControls(); this.lblStatusMessageTitle.Text = "खरिद अर्डर "; this.lblStatusMessage.Text = "सफलतापूर्वक परिर्वतन भयो!!!"; this.programmaticModalPopup.Show(); } else if (updateConfirm == 1) { ClearItemsDetailControls(); this.lblStatusMessageTitle.Text = "खरिद अर्डर "; this.lblStatusMessage.Text = "सफलतापूर्वक सिफारिस भयो।"; this.programmaticModalPopup.Show(); } else if (updateConfirm == 2) { ClearItemsDetailControls(); this.lblStatusMessageTitle.Text = "खरिद अर्डर "; this.lblStatusMessage.Text = "सफलतापूर्वक प्रमाणित भयो।"; this.programmaticModalPopup.Show(); } else { this.lblStatusMessageTitle.Text = "खरिद अर्डर "; this.lblStatusMessage.Text = "वाधा उत्पन्न भयो!!!"; this.programmaticModalPopup.Show(); } } i++; OnBubbleClick(e); } } catch (Exception ex) { throw (ex); } }
public static int RecomendApprovePurchaseOrder(ATTInvPurchaseOrder objPo) { GetConnection GetConn = new GetConnection(); OracleConnection DBConn = GetConn.GetDbConn(Module.OAS); OracleTransaction Tran = DBConn.BeginTransaction(); try { string sp = ""; int countPoDetail = objPo.lstPurchaseOrderDetail.Count; if (objPo.Type == 1) { sp = "SP_INV_REC_PURCHASE_ORDER"; } else if (objPo.Type == 2) { sp = "SP_INV_APP_PURCHASE_ORDER"; } if (objPo.Type != null && sp != "") { List <OracleParameter> paramArray = new List <OracleParameter>(); paramArray.Add(Utilities.GetOraParam(":p_org_id", objPo.OrgID, OracleDbType.Int64, ParameterDirection.Input)); // paramArray.Add(Utilities.GetOraParam(":p_unit_id", objPo.UnitID, OracleDbType.Int64, ParameterDirection.Input)); paramArray.Add(Utilities.GetOraParam(":p_order_no", objPo.OrderNo, OracleDbType.Varchar2, ParameterDirection.Input)); if (objPo.Type == 1) { paramArray.Add(Utilities.GetOraParam(":p_rec_by", objPo.RecBy, OracleDbType.Int64, ParameterDirection.Input)); paramArray.Add(Utilities.GetOraParam(":p_rec_date", objPo.RecDate, OracleDbType.Varchar2, ParameterDirection.Input)); paramArray.Add(Utilities.GetOraParam(":p_rec_yes_no", objPo.RecYesNo, OracleDbType.Varchar2, ParameterDirection.Input)); } else if (objPo.Type == 2) { paramArray.Add(Utilities.GetOraParam(":p_app_by", objPo.AppBy, OracleDbType.Int64, ParameterDirection.Input)); paramArray.Add(Utilities.GetOraParam(":p_app_date", objPo.AppDate, OracleDbType.Varchar2, ParameterDirection.Input)); paramArray.Add(Utilities.GetOraParam(":p_app_yes_no", objPo.AppYesNo, OracleDbType.Varchar2, ParameterDirection.Input)); } SqlHelper.ExecuteNonQuery(Tran, CommandType.StoredProcedure, sp, paramArray.ToArray()); paramArray.Clear(); } if (countPoDetail > 0) { DLLInvPurchaseOrderDetail.SavePurchaseOrderDetail(objPo, Tran); } Tran.Commit(); if (objPo.Type == 1) { return(1); } else if (objPo.Type == 2) { return(2); } else { return(3); } } catch (Exception ex) { throw(ex); } }
public static int SavePurchaseOrder(ATTInvPurchaseOrder objPo) { GetConnection GetConn = new GetConnection(); OracleConnection DBConn = GetConn.GetDbConn(Module.OAS); OracleTransaction Tran = DBConn.BeginTransaction(); try { if (objPo.Action == "A") { int orderCount = CheckPurOrderAvailability(objPo, Tran); if (orderCount > 0) { Tran.Commit(); return(-1); } } string sp = ""; int countPoDetail = objPo.lstPurchaseOrderDetail.Count; if (objPo.Action == "A") { sp = "sp_inv_add_purchase_order"; } else if (objPo.Action == "E") { sp = "sp_inv_edit_purchase_order"; } if (objPo.Action != "N" && sp != "") { OracleParameter[] paramArray = new OracleParameter[11]; paramArray[0] = Utilities.GetOraParam(":p_org_id", objPo.OrgID, OracleDbType.Int64, ParameterDirection.Input); paramArray[1] = Utilities.GetOraParam(":p_order_no", objPo.OrderNo, OracleDbType.Varchar2, ParameterDirection.Input); paramArray[2] = Utilities.GetOraParam(":p_order_date", objPo.OrderDate, OracleDbType.Varchar2, ParameterDirection.Input); paramArray[3] = Utilities.GetOraParam(":p_suppliers_id", objPo.SupplierID, OracleDbType.Int64, ParameterDirection.Input); paramArray[4] = Utilities.GetOraParam(":p_rec_by", objPo.RecBy, OracleDbType.Int64, ParameterDirection.Input); paramArray[5] = Utilities.GetOraParam(":p_rec_date", objPo.RecDate, OracleDbType.Varchar2, ParameterDirection.Input); paramArray[6] = Utilities.GetOraParam(":p_rec_yes_no", objPo.RecYesNo, OracleDbType.Varchar2, ParameterDirection.Input); paramArray[7] = Utilities.GetOraParam(":p_app_by", objPo.AppBy, OracleDbType.Int64, ParameterDirection.Input); paramArray[8] = Utilities.GetOraParam(":p_app_date", objPo.AppDate, OracleDbType.Varchar2, ParameterDirection.Input); paramArray[9] = Utilities.GetOraParam(":p_app_yes_no", objPo.AppYesNo, OracleDbType.Varchar2, ParameterDirection.Input); paramArray[10] = Utilities.GetOraParam(":p_entry_by", objPo.EntryBy, OracleDbType.Varchar2, ParameterDirection.Input); SqlHelper.ExecuteNonQuery(Tran, CommandType.StoredProcedure, sp, paramArray); } if (countPoDetail > 0) { DLLInvPurchaseOrderDetail.SavePurchaseOrderDetail(objPo, Tran); } Tran.Commit(); return(0); } catch (Exception ex) { Tran.Rollback(); throw (ex); } finally { GetConn.CloseDbConn(); } }