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