public GenericCollection <PurchaseOrderBE> GetASNStatus(string POList) { string BAMEnvironment = HttpContext.Current.Session["Environment"] != null ? HttpContext.Current.Session["Environment"].ToString() : "UAT"; string corpnetconnection1 = BAMEnvironment == "UAT" ? ConfigurationSettings.AppSettings["UATCorpnetBAMConn"].ToString() : ConfigurationSettings.AppSettings["ProdCorpnetBAMConn"].ToString(); SqlConnection corpnetconnection = new SqlConnection(corpnetconnection1); GenericCollection <PurchaseOrderBE> PurchaseOrderList = new GenericCollection <PurchaseOrderBE>(); try { DataSet ds = null; ds = SqlHelper.ExecuteDataset(corpnetconnection, CommandType.Text, POList); if (ds != null) { if (ds.Tables.Count > 0) { for (int i = 0; i < ds.Tables[0].Rows.Count; i++) { PurchaseOrderBE objBE = new PurchaseOrderBE(); objBE.PONumber = ds.Tables[0].Rows[i]["Field2"].ToString(); objBE.ExtranetStatus = ds.Tables[0].Rows[i]["Status"].ToString(); PurchaseOrderList.Add(i, objBE); } } } } catch (Exception ex) { throw ex; } return(PurchaseOrderList); }
public PurchaseOrderBE LoadPOFiles(string TransactionID) { string BAMEnvironment = HttpContext.Current.Session["Environment"] != null ? HttpContext.Current.Session["Environment"].ToString() : "UAT"; string extranetconnection1 = BAMEnvironment == "UAT" ? ConfigurationSettings.AppSettings["UATExtranetBAMConn"].ToString() : ConfigurationSettings.AppSettings["ProdExtranetBAMConn1"].ToString(); SqlConnection extranetconnection = new SqlConnection(extranetconnection1); PurchaseOrderBE objBE = new PurchaseOrderBE(); try { SqlParameter[] sqlparams = new SqlParameter[2]; sqlparams[0] = new SqlParameter("@TxnID", TransactionID); sqlparams[1] = new SqlParameter("@type", "Files"); DataSet ds = null; ds = SqlHelper.ExecuteDataset(extranetconnection, CommandType.StoredProcedure, "usp_get_IndividualPODetails", sqlparams); if (ds != null) { if (ds.Tables.Count > 0) { for (int i = 0; i < ds.Tables[0].Rows.Count; i++) { objBE.OagisArchivePath = ds.Tables[0].Rows[i]["OagisFile"].ToString(); objBE.MessageArchivePath = ds.Tables[0].Rows[i]["VO2File"].ToString(); objBE.ConfirmBODArchivePath = ds.Tables[0].Rows[i]["ConfirmBOD"].ToString(); } } } } catch (Exception ex) { throw ex; } return(objBE); }
public PurchaseOrderBE LoadPOFiles(string TransactionID) { PurchaseOrderBE ArchiveBE = new PurchaseOrderBE(); PurchaseOrderDO objDO = new PurchaseOrderDO(); try { ArchiveBE = objDO.LoadPOFiles(TransactionID); } catch (Exception ex) { throw ex; } return(ArchiveBE); }
public GenericCollection <PurchaseOrderBE> GetPurchaseOrdersList(string TaskID, string Partner, DateTime?DateFrom, DateTime?DateTO, string PONumner) { string BAMEnvironment = HttpContext.Current.Session["Environment"] != null ? HttpContext.Current.Session["Environment"].ToString() : "UAT"; string corpnetconnection1 = BAMEnvironment == "UAT" ? ConfigurationSettings.AppSettings["UATCorpnetBAMConn"].ToString() : ConfigurationSettings.AppSettings["ProdCorpnetBAMConn"].ToString(); SqlConnection corpnetconnection = new SqlConnection(corpnetconnection1); GenericCollection <PurchaseOrderBE> PurchaseOrderList = new GenericCollection <PurchaseOrderBE>(); try { SqlParameter[] sqlparams = new SqlParameter[5]; sqlparams[0] = new SqlParameter("@TaskID", TaskID); sqlparams[1] = new SqlParameter("@StartDate", DateFrom != null ? DateFrom : Convert.ToDateTime("1/1/1990")); sqlparams[2] = new SqlParameter("@EndDate", DateTO != null ? DateTO : Convert.ToDateTime("12/31/2050")); sqlparams[3] = new SqlParameter("@Partner", Partner); sqlparams[4] = new SqlParameter("@PONumber", PONumner); DataSet ds = null; ds = SqlHelper.ExecuteDataset(corpnetconnection, CommandType.StoredProcedure, "Get_PODetails", sqlparams); if (ds != null) { if (ds.Tables.Count > 0) { for (int i = 0; i < ds.Tables[0].Rows.Count; i++) { PurchaseOrderBE objBE = new PurchaseOrderBE(); objBE.PONumber = ds.Tables[0].Rows[i]["TransactionID"].ToString(); objBE.TxnType = ds.Tables[0].Rows[i]["TaskID"].ToString(); objBE.CM = ds.Tables[0].Rows[i]["CM"].ToString(); objBE.CorpnetStatus = ds.Tables[0].Rows[i]["POStatus"].ToString(); objBE.ExtranetStatus = "NA"; objBE.PODate = ds.Tables[0].Rows[i]["PODate"].ToString(); objBE.ASNDate = ds.Tables[0].Rows[i]["ASNDate"].ToString(); objBE.ASNDate = objBE.ASNDate != "" ? objBE.ASNDate.Substring(0, 16) : ""; objBE.ASNStatus = ds.Tables[0].Rows[i]["ASNStatus"].ToString(); objBE.GRDate = ds.Tables[0].Rows[i]["GRDate"].ToString(); objBE.GRDate = objBE.GRDate != "" ? objBE.GRDate.Substring(0, 16) : ""; objBE.GRStatus = ds.Tables[0].Rows[i]["GRStatus"].ToString(); PurchaseOrderList.Add(i, objBE); } } } } catch (Exception ex) { throw ex; } return(PurchaseOrderList); }
private void LoadPOFiles(string Archivepath, string TransactionID, string CorpStatus, string ExtStatus, string TxnType, string PONumber, string PODate, string Partner, string IsICOE, string BOD) { PurchaseOrderBC objBC = new PurchaseOrderBC(); PurchaseOrderBE objArchiveBE = objBC.LoadPOFiles(TransactionID); objArchiveBE.PODate = PODate; objArchiveBE.PONumber = PONumber; objArchiveBE.ExtranetStatus = ExtStatus; objArchiveBE.CorpnetStatus = CorpStatus; objArchiveBE.CM = Partner; objArchiveBE.ReferenceID = TransactionID; objArchiveBE.isICOEPartner = IsICOE; objArchiveBE.MessageArchivePath = Archivepath; objArchiveBE.POCBODRcvd = BOD; Session["ArchiveFiles"] = objArchiveBE; Page.ClientScript.RegisterStartupScript(this.GetType(), "CallMyFunction", "ShowNewPage();", true); }
public GenericCollection <PurchaseOrderBE> ModifyExtranetPODetails(string POList, string Type) { string BAMEnvironment = HttpContext.Current.Session["Environment"] != null ? HttpContext.Current.Session["Environment"].ToString() : "UAT"; string extranetconnection1 = BAMEnvironment == "UAT" ? ConfigurationSettings.AppSettings["UATExtranetBAMConn"].ToString() : ConfigurationSettings.AppSettings["ProdExtranetBAMConn1"].ToString(); SqlConnection extranetconnection = new SqlConnection(extranetconnection1); GenericCollection <PurchaseOrderBE> PurchaseOrderList = new GenericCollection <PurchaseOrderBE>(); try { SqlParameter[] sqlparams = new SqlParameter[2]; sqlparams[0] = new SqlParameter("@TxnID", POList); sqlparams[1] = new SqlParameter("@type", Type); DataSet ds = null; ds = SqlHelper.ExecuteDataset(extranetconnection, CommandType.StoredProcedure, "usp_get_IndividualPODetails", sqlparams); if (ds != null) { if (ds.Tables.Count > 0) { for (int i = 0; i < ds.Tables[0].Rows.Count; i++) { PurchaseOrderBE objBE = new PurchaseOrderBE(); objBE.ReferenceID = ds.Tables[0].Rows[i]["TransactionID"].ToString(); objBE.ExtranetStatus = ds.Tables[0].Rows[i]["Status"].ToString(); objBE.POCBODRcvd = ds.Tables[0].Rows[i]["Field5"].ToString(); PurchaseOrderList.Add(i, objBE); } } } } catch (Exception ex) { throw ex; } return(PurchaseOrderList); }