private bool LoadTabletblGIScSalesHistory(int nextScenarioID, int gISeasonID)
{
clsSeason mySea = new clsSeason();
mySea.GetSeasonByID(gISeasonID);
try
{
if (clsGlobals.SecondSeasonID > 99 && clsGlobals.OriginOfStoredProc == 1)
{
clsSeason mySSea = new clsSeason();
mySSea.GetSeasonByID(clsGlobals.SecondSeasonID);
clsGlobals.SecondSeasonID = mySSea.SXSeasonID;
}
else
{
clsGlobals.SecondSeasonID = -1;
}
clsSilex.RunStoredProcedure(nextScenarioID, mySea.SXSeasonID, clsGlobals.SecondSeasonID, mySea.SXSeasonPrecID);
return(true);
}
catch
{
return(false);
}
}
private void ScenarioTotext(clsScenario Sce)
{
clsSeason mySea = lstSea.GetSeasonByID(Sce.GISeasonID);
txtCode.Text = Convert.ToString(Sce.ScenarioCode);
txtCreatedD.Text = Convert.ToString(Sce.CreatedDate);
txtCreatedU.Text = Convert.ToString(Sce.CreatedByUserID);
txtDesc.Text = Convert.ToString(Sce.ScenarioDesc);
txtModifiedD.Text = Convert.ToString(Sce.ModifiedDate);
txtModifiedU.Text = Convert.ToString(Sce.ModifiedByUserID);
cboStatus.SelectedIndex = Sce.ScenarioStatus;
cboCurrentSaison.SelectedValue = mySea.GISeasonID;
txtPreviousSeason.Text = mySea.SeasonPrecName;
txtModifiedU.Text = clsUser.GetUserName(Sce.ModifiedByUserID);
txtCreatedU.Text = clsUser.GetUserName(Sce.CreatedByUserID);
}
private bool LoadTabletblGIScSalesHistory(int nextScenarioID, int gISeasonID)
{
clsSeason mySea = new clsSeason();
mySea = lstSea.GetSeasonByID(gISeasonID);
try
{
RunStoredProcedure(nextScenarioID, mySea.SXSeasonID, clsGlobals.SecondSeasonID, mySea.SXSeasonPrecID);
return(true);
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
return(false);
}
}
private void UpdateEquivalentProducts()
{
int numberSeasons = 0;
lstPequ.GetAllEquivalentProducts();
foreach (clsProductEqui myPeq in lstPequ.Elements)
{
clsSeason seasonScenario = new clsSeason();
clsSeason seasonPeque = new clsSeason();
seasonScenario.GetSeasonByID(clsGlobals.GISeasonID);
seasonPeque.GetSeasonByID(myPeq.SeasonID);
numberSeasons = seasonScenario.NumberSeasons(seasonPeque);
if (numberSeasons > 0)
{
UpdateItems(myPeq, numberSeasons);
}
}
}
private void LoadScenarioInformation()
{
mySce.GetScenarioByID(clsGlobals.GIPar.ScenarioID);
lstSea.GetAllSeasons();
mySea = lstSea.GetSeasonByID(mySce.GISeasonID);
txtRef1.Text = mySce.ReferenceNo1;
txtRef2.Text = mySce.ReferenceNo2;
txtVOMessage.Text = mySce.VOMessage;
txtVONote.Text = mySce.VONote;
txtCode.Text = mySce.ScenarioCode;
txtDesc.Text = mySce.ScenarioDesc;
txtCurrentSeasons.Text = mySea.SeasonName;
txtSeasonsPrevious.Text = mySea.SeasonPrecName;
cboStatus.SelectedValue = mySce.ScenarioStatus;
cboBillFrom.SelectedValue = mySce.VendorID.ToString();
cboCollection.SelectedValue = mySce.CollectionID.ToString();
cboDivision.SelectedValue = mySce.DivisionID.ToString();
cboPurchaseType.SelectedValue = mySce.PurchaseTypeID.ToString();
cboSeason.SelectedValue = mySce.GISeasonID;
cboWhs.SelectedValue = mySce.DefaultWarehouseID.ToString();
dtpShipDate.Value = mySce.ExpShippingDate;
dtpArrivalDate.Value = mySce.ExpArrivalDate;
}
protected void ddlAction_SelectedIndexChanged(object sender, EventArgs e)
{
string str = ((Label)((DropDownList)sender).Parent.FindControl("lblddlActionSeasonID")).Text;
string ddlSelectedValue = ((DropDownList)sender).SelectedValue;
if (ddlSelectedValue == "Edit")
{
funClearData();
int SeasonID = 0;
int.TryParse(str, out SeasonID);
LinkButton btn = sender as LinkButton;
clsSeason cs = new clsSeason();
clsSeasonController csc = new clsSeasonController();
DataTable dt = new DataTable();
dt = csc.GetSeasonDataBySeasonID(SeasonID);
if (dt.Rows.Count > 0)
{
hidRegID.Value = dt.Rows[0]["SeasonID"].ToString();
ddlCountry.SelectedValue = dt.Rows[0]["CountryID"].ToString();
txtSeasonTitle.Text = dt.Rows[0]["SeasonName"].ToString();
txtSeasonDescription.Text = dt.Rows[0]["SeasonDesc"].ToString();
txtSeasonStartDate.Text = dt.Rows[0]["StartDate"].ToString();
if (dt.Rows[0]["EndDate"].ToString() != "01/01/0001" && dt.Rows[0]["EndDate"].ToString() != "01/01/1900")
{
txtSeasonEndDate.Text = dt.Rows[0]["EndDate"].ToString();
}
txtSeasonLogoName.Text = dt.Rows[0]["SeasonLogoName"].ToString();
SeasonLogoImage.ImageUrl = dt.Rows[0]["SeasonLogoFile"].ToString();
string ufname = dt.Rows[0]["SeasonLogoFile"].ToString().Replace(" ", "");
SeasonLogoFile.ResolveUrl("ufname");
if (dt.Rows[0]["ActiveFlagId"].ToString() == "1")
{
ChkIsActive.Checked = true;
}
else
{
ChkIsActive.Checked = false;
}
if (dt.Rows[0]["ShowFlagId"].ToString() == "1")
{
ChkIsShow.Checked = true;
}
else
{
ChkIsShow.Checked = false;
}
mainContentSeason.Visible = true;
PnlGridSeason.Visible = false;
btnUpdateSeason.Visible = true;
btnSaveSeason.Visible = false;
}
}
else if (ddlSelectedValue == "Delete")
{
//Page.ClientScript.RegisterStartupScript(this.GetType(), "", "javascript:confirm('Are You Sure? Want To Delete.');", true);
//Page.ClientScript.RegisterStartupScript(this.GetType(), "confirm", "javascript:Confirmation();", true);
//int competition_Id = 0;
//int.TryParse(str, out competition_Id);
//CompRegInfo.DeleteCompetitionReg(competition_Id);
//FillGridView();
}
}
