protected void Page_Load(object sender, EventArgs e)
{
ProcessLogFileName = @"Excel\" + Session["UserName"].ToString() + "ProcessLog.txt";
if (!Page.IsPostBack)
{
//RunByLabel.Text = Session["UserName"].ToString();
CatBegTextBox.Focus();
btnAccept.Visible = false;
ProcessPanel.Visible = false;
ActionPanel.Visible = false;
ActionSubmitButt.Visible = false;
PrintButt.Visible = false;
SKUPanel.Visible = false;
FactorPrompt.Visible = false;
CPRFactor.Text = "1";
Session["PageOp"] = "";
string FullFilePath = Server.MapPath(ProcessLogFileName);
using (StreamWriter sw = new StreamWriter(FullFilePath))
{
sw.WriteLine("Branch Stocking Analysis started at " + DateTime.Now.ToLongDateString() + " " + DateTime.Now.ToLongTimeString());
}
LoadBranches();
}
else
{
SKUPanel.Height = int.Parse(yh.Text.ToString()) - 90;
ActionPanel.Height = int.Parse(yh.Text.ToString()) - 90;
ResultsUpdatePanel.Update();
}
ScriptManager1.AsyncPostBackTimeout = 1200;
//ScriptManager1.SetFocus(CatBegTextBox);
ScriptManager1.RegisterAsyncPostBackControl(BranchListButt);
//lblErrorMessage.Text = Session["PageOp"];
}
protected void ItemSearchButt_Click(object sender, ImageClickEventArgs e)
{
BindSKUGrid();
ResultsUpdatePanel.Update();
CatBegTextBox.Focus();
FactorPrompt.Visible = false;
//FindUpdatePanel.Update();
}
public void ClearBranches(Object sender, EventArgs e)
{
if (Session["BranchTable"] != null)
{
try
{
dt = (DataTable)Session["BranchTable"];
dt.Rows.Clear();
BranchGrid.DataSource = dt;
BranchGrid.DataBind();
Session["BranchTable"] = dt;
}
catch { };
}
CatBegTextBox.Focus();
}
protected void BranchCommand(object source, GridViewCommandEventArgs e)
{
ClearPageMessages();
CatBegTextBox.Focus();
dt = (DataTable)Session["BranchTable"];
if (e.CommandName == "Del")
{
int index = Convert.ToInt32(e.CommandArgument);
string BranchToRemove = BranchGrid.Rows[index].Cells[0].Text;
dt.Rows.RemoveAt(index);
BranchGrid.DataSource = dt;
BranchGrid.DataBind();
Session["BranchTable"] = dt;
}
if (e.CommandName == "Hub")
{
int index = Convert.ToInt32(e.CommandArgument);
DataRow drow = dt.Rows[index];
drow["IsHub"] = !(Boolean)drow["IsHub"];
BranchGrid.DataSource = dt;
BranchGrid.DataBind();
Session["BranchTable"] = dt;
}
if (e.CommandName == "MoveUp")
{
int index = Convert.ToInt32(e.CommandArgument);
if (index > 0)
{
DataRow drow1 = dt.Rows[index];
int oldKey = (int)drow1["SortKey"];
DataRow drow2 = dt.Rows[index - 1];
drow1["SortKey"] = drow2["SortKey"];
drow2["SortKey"] = oldKey;
DataView dv = new DataView(dt, "", "SortKey", DataViewRowState.CurrentRows);
dt = dv.ToTable();
}
BranchGrid.DataSource = dt;
BranchGrid.DataBind();
Session["BranchTable"] = dt;
}
if (e.CommandName == "MoveDown")
{
int index = Convert.ToInt32(e.CommandArgument);
if (index < dt.Rows.Count - 1)
{
DataRow drow1 = dt.Rows[index];
int oldKey = (int)drow1["SortKey"];
DataRow drow2 = dt.Rows[index + 1];
drow1["SortKey"] = drow2["SortKey"];
drow2["SortKey"] = oldKey;
DataView dv = new DataView(dt, "", "SortKey", DataViewRowState.CurrentRows);
dt = dv.ToTable();
}
BranchGrid.DataSource = dt;
BranchGrid.DataBind();
Session["BranchTable"] = dt;
}
if (e.CommandName == "AddToList")
{
int index = Convert.ToInt32(e.CommandArgument);
DataRow workRow = dt.NewRow();
workRow["Code"] = LoaderGrid.Rows[index].Cells[0].Text;
workRow["Name"] = LoaderGrid.Rows[index].Cells[1].Text;
if (dt.Select("Code = '" + workRow["Code"] + "'").Length == 0)
{
if (LoaderGrid.Rows[index].Cells[2].Text == "True")
{
workRow["Hub"] = 1;
workRow["IsHub"] = true;
}
else
{
workRow["Hub"] = 0;
workRow["IsHub"] = false;
}
if (dt.Rows.Count == 0)
{
workRow["SortKey"] = 10000;
}
else
{
workRow["SortKey"] = (int)dt.Rows[dt.Rows.Count - 1]["SortKey"] * 10000;
}
dt.Rows.Add(workRow);
BranchGrid.DataSource = dt;
BranchGrid.DataBind();
Session["BranchTable"] = dt;
}
else
{
lblErrorMessage.Text = "Branch " + workRow["Code"].ToString() + " is already in the list";
}
}
}
public void AddAllBranches(Object sender, EventArgs e)
{
ResetBranches("Branches");
CatBegTextBox.Focus();
}
protected void UpdateItems()
{
string processLog = "Update results at " + DateTime.Now.ToLongTimeString() + "\n";
btnAccept.Visible = false;
ActionSubmitButt.Visible = false;
PrintButt.Visible = false;
string ProcessItem = "";
string ProcessLoc = "";
string ProcessState = "";
string ProcessROP = "";
char[] delimiterChars = { '_' };
int loop1, loop2, processCtr;
System.Collections.Specialized.NameValueCollection coll;
processCtr = 0;
// Scan for checked boxes.
coll = Request.Form;
// Put the names of all keys into a string array.
String[] arr1 = coll.AllKeys;
for (loop1 = 0; loop1 < arr1.Length; loop1++)
{
if (arr1[loop1].StartsWith("ACTSK"))
{
ProcessItem = arr1[loop1].Split(delimiterChars)[1];
ProcessLoc = arr1[loop1].Split(delimiterChars)[2];
ProcessState = arr1[loop1].Split(delimiterChars)[3];
processLog += ProcessItem + " Loc:" + ProcessLoc + " ";
switch (ProcessState)
{
case "A":
processLog += "SVC=K, Stocked=On.";
break;
case "B":
processLog += "SVC=N, Stocked=Off.";
break;
case "C":
processLog += "SKU added, SVC=K, Stocked=On.";
break;
}
ProcessROP = coll[loop1 + 1];
if (ProcessROP != "")
{
processLog += " ROP = " + ProcessROP;
}
int result = SqlHelper.ExecuteNonQuery(connectionString, "[pSKUAnalysisUpd]",
new SqlParameter("@Item", ProcessItem),
new SqlParameter("@Loc", ProcessLoc),
new SqlParameter("@Action", ProcessState),
new SqlParameter("@NewROP", ProcessROP));
processLog += "\n";
processCtr++;
}
}
processLog += processCtr.ToString() + " processed.";
ProcessLogTextBox.Text = processLog;
// Add to Process log
string FullFilePath = Server.MapPath(ProcessLogFileName);
using (StreamWriter sw = new StreamWriter(FullFilePath, true))
{
sw.WriteLine(processLog);
}
SKUPanel.Visible = false;
ProcessPanel.Visible = true;
//BranchPanel.Visible = true;
ActionPanel.Visible = false;
ActionSubmitButt.Visible = false;
Session["PageOp"] = "";
CatBegTextBox.Focus();
if (processCtr == 0)
{
lblErrorMessage.Text = "You did not select any items for updating.";
}
//FindUpdatePanel.Update();
//}
//catch (Exception ex) { }
}
