protected void Page_Load(object sender, EventArgs e)
{
EmployeeLogic el = new EmployeeLogic();
Employee e2 = el.SelectByID(Convert.ToInt32(Session["EmployeeID"]));
if (!IsPostBack)
{
if (!(e2.Designation.Equals("STOCK MANAGER") || e2.Designation.Equals("STOCK EMPLOYEE") || e2.Designation.Equals("ACCOUNTATANT") || e2.Designation.Equals("HR MANAGER") || e2.Designation.Equals("HR EMPLOYEE")))
{
ProductLogic PL = new ProductLogic();
DataTable dt = PL.SelectAllJoined();
Repeater1.DataSource = dt;
Repeater1.DataBind();
if (dt.Rows.Count == 0)
{
Table1.Visible = false;
Label1.Visible = true;
}
else
{
Table1.Visible = true;
Label1.Visible = false;
}
CustomerLogic cl = new CustomerLogic();
DataTable dt1 = cl.SelectAll();
dt1.Rows.Add(0, "All Customers", null, null, null, null, null, null, null, null, null);
dt1.DefaultView.Sort = "CustomerID";
DropDownList2.DataSource = dt1;
DropDownList2.DataTextField = "Name";
DropDownList2.DataValueField = "CustomerID";
DropDownList2.DataBind();
//DropDownList2.SelectedValue = "All Customers";
}
else
{
Response.Redirect("Access.aspx");
}
}
}
protected void Repeater1_ItemCommand(object source, RepeaterCommandEventArgs e)
{
EmployeeLogic el = new EmployeeLogic();
Employee e2 = el.SelectByID(Convert.ToInt32(Session["EmployeeID"]));
if (!(e2.Designation.Equals("STOCK MANAGER") || e2.Designation.Equals("STOCK EMPLOYEE") || e2.Designation.Equals("ACCOUNTATANT") || e2.Designation.Equals("EMPLOYEE") || e2.Designation.Equals("HR MANAGER") || e2.Designation.Equals("HR EMPLOYEE")))
{
if(e.CommandName.Equals("Product Designed")){
ProductLogic pl = new ProductLogic();
Product p1 = pl.SelectByProductID(Convert.ToInt32(e.CommandArgument));
p1.Status = "Product Designed";
pl.Update(p1);
DataTable dt = pl.SelectAllJoined();
Repeater1.DataSource = dt;
Repeater1.DataBind();
if (dt.Rows.Count == 0)
{
Table1.Visible = false;
Label1.Visible = true;
}
else
{
Table1.Visible = true;
Label1.Visible = false;
}
TransitionLogic tl = new TransitionLogic();
Transition t1 = new Transition();
t1.KeyID = p1.ProductID;
t1.KeyType = "Prod";
t1.TranDate = DateTime.Now;
t1.NewStatus = "Product Designed";
t1.Remarks = ((TextBox)e.Item.FindControl("TextBox2")).Text;
tl.Insert(t1);
}else if(e.CommandName.Equals("Product Sent for client design approval")){
ProductLogic pl = new ProductLogic();
Product p1 = pl.SelectByProductID(Convert.ToInt32(e.CommandArgument));
p1.Status = "Product Sent for client design approval";
pl.Update(p1);
DataTable dt = pl.SelectAllJoined();
Repeater1.DataSource = dt;
Repeater1.DataBind();
if (dt.Rows.Count == 0)
{
Table1.Visible = false;
Label1.Visible = true;
}
else
{
Table1.Visible = true;
Label1.Visible = false;
}
TransitionLogic tl = new TransitionLogic();
Transition t1 = new Transition();
t1.KeyID = p1.ProductID;
t1.KeyType = "Prod";
t1.TranDate = DateTime.Now;
t1.NewStatus = "Product Sent for client design approval";
t1.Remarks = ((TextBox)e.Item.FindControl("TextBox2")).Text;
tl.Insert(t1);
}else if(e.CommandName.Equals("Design approved by client")){
ProductLogic pl = new ProductLogic();
Product p1 = pl.SelectByProductID(Convert.ToInt32(e.CommandArgument));
p1.Status = "Design approved by client";
pl.Update(p1);
DataTable dt = pl.SelectAllJoined();
Repeater1.DataSource = dt;
Repeater1.DataBind();
if (dt.Rows.Count == 0)
{
Table1.Visible = false;
Label1.Visible = true;
}
else
{
Table1.Visible = true;
Label1.Visible = false;
}
TransitionLogic tl = new TransitionLogic();
Transition t1 = new Transition();
t1.KeyID = p1.ProductID;
t1.KeyType = "Prod";
t1.TranDate = DateTime.Now;
t1.NewStatus = "Design approved by client";
t1.Remarks = ((TextBox)e.Item.FindControl("TextBox2")).Text;
tl.Insert(t1);
}else if(e.CommandName.Equals("Trial product prepared")){
ProductLogic pl = new ProductLogic();
Product p1 = pl.SelectByProductID(Convert.ToInt32(e.CommandArgument));
p1.Status = "Trial product prepared";
pl.Update(p1);
DataTable dt = pl.SelectAllJoined();
Repeater1.DataSource = dt;
Repeater1.DataBind();
if (dt.Rows.Count == 0)
{
Table1.Visible = false;
Label1.Visible = true;
}
else
{
Table1.Visible = true;
Label1.Visible = false;
}
TransitionLogic tl = new TransitionLogic();
Transition t1 = new Transition();
t1.KeyID = p1.ProductID;
t1.KeyType = "Prod";
t1.TranDate = DateTime.Now;
t1.NewStatus = "Trial product prepared";
t1.Remarks = ((TextBox)e.Item.FindControl("TextBox2")).Text;
tl.Insert(t1);
}else if(e.CommandName.Equals("Trial product sent for client approval")){
ProductLogic pl = new ProductLogic();
Product p1 = pl.SelectByProductID(Convert.ToInt32(e.CommandArgument));
p1.Status = "Trial product sent for client approval";
pl.Update(p1);
DataTable dt = pl.SelectAllJoined();
Repeater1.DataSource = dt;
Repeater1.DataBind();
if (dt.Rows.Count == 0)
{
Table1.Visible = false;
Label1.Visible = true;
}
else
{
Table1.Visible = true;
Label1.Visible = false;
}
TransitionLogic tl = new TransitionLogic();
Transition t1 = new Transition();
t1.KeyID = p1.ProductID;
t1.KeyType = "Prod";
t1.TranDate = DateTime.Now;
t1.NewStatus = "Trial product sent for client approval";
t1.Remarks = ((TextBox)e.Item.FindControl("TextBox2")).Text;
tl.Insert(t1);
}else if(e.CommandName.Equals("Trial product approved by client")){
ProductLogic pl = new ProductLogic();
Product p1 = pl.SelectByProductID(Convert.ToInt32(e.CommandArgument));
p1.Status = "Trial product approved by client";
pl.Update(p1);
DataTable dt = pl.SelectAllJoined();
Repeater1.DataSource = dt;
Repeater1.DataBind();
if (dt.Rows.Count == 0)
{
Table1.Visible = false;
Label1.Visible = true;
}
else
{
Table1.Visible = true;
Label1.Visible = false;
}
TransitionLogic tl = new TransitionLogic();
Transition t1 = new Transition();
t1.KeyID = p1.ProductID;
t1.KeyType = "Prod";
t1.TranDate = DateTime.Now;
t1.NewStatus = "Trial product approved by client";
t1.Remarks = ((TextBox)e.Item.FindControl("TextBox2")).Text;
tl.Insert(t1);
}else if(e.CommandName.Equals("product approved")){
ProductLogic pl = new ProductLogic();
Product p1 = pl.SelectByProductID(Convert.ToInt32(e.CommandArgument));
p1.Status = "product approved";
pl.Update(p1);
DataTable dt = pl.SelectAllJoined();
Repeater1.DataSource = dt;
Repeater1.DataBind();
if (dt.Rows.Count == 0)
{
Table1.Visible = false;
Label1.Visible = true;
}
else
{
Table1.Visible = true;
Label1.Visible = false;
}
TransitionLogic tl = new TransitionLogic();
Transition t1 = new Transition();
t1.KeyID = p1.ProductID;
t1.KeyType = "Prod";
t1.TranDate = DateTime.Now;
t1.NewStatus = "product approved";
t1.Remarks = ((TextBox)e.Item.FindControl("TextBox2")).Text;
tl.Insert(t1);
}
}
else
{
Response.Redirect("Access.aspx");
}
}
