protected void Btn_search_Click(object sender, EventArgs e)
{
string category = DropDownList_category.SelectedItem.ToString();
GridView_stock.DataSource = StoreBusinessLogic.GetStockByCategory(category);
GridView_stock.DataBind();
}
protected void OnRowDeleting(object sender, GridViewDeleteEventArgs e)
{
string suppcode = Convert.ToString(GridView_supplier.DataKeys[e.RowIndex].Values[0]);
StoreBusinessLogic.DeleteSupplier(suppcode);
bindgrid();
}
protected void OnRowDeleting(object sender, GridViewDeleteEventArgs e)
{
string deptcode = Convert.ToString(GridView_department.DataKeys[e.RowIndex].Values[0]);
StoreBusinessLogic.DeleteDepartment(deptcode);
bindgrid();
}
protected void Page_Load(object sender, EventArgs e)
{
if (Session["sign"].ToString() == "")
{
Response.Redirect("~/LoginNew.aspx");
}
Boolean results = empauthentication.SupAuthentication(Session["sign"].ToString());
if (results == false)
{
Response.Redirect("~/LoginNew.aspx");
}
btn_Notification.Enabled = false;
int id = (int)Session["id"];
GridView1.DataSource = StoreBusinessLogic.GetAdjustbYidSuper(id);
GridView1.DataBind();
for (int i = 0; i < GridView1.Rows.Count - 1; i++)
{
if (GridView1.Rows[i].Cells[7].ToString() == "NULL" || GridView1.Rows[i].Cells[7].ToString() == "")
{
btn_Notification.Enabled = true;
}
break;
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (Session["sign"].ToString() == "")
{
Response.Redirect("~/LoginNew.aspx");
}
if (!IsPostBack)
{
List <RequestSTATUS> RequestList = StoreBusinessLogic.GetRetriecvalStatus();
if (RequestList.Count == 0)
{
lb_Inform.Text = "No Request Now";
}
else
{
GridView1.DataSource = StoreBusinessLogic.GetRetriecvalStatus();
GridView1.DataBind();
}
}
Boolean results = empauthentication.ClerkAuthentication(Session["sign"].ToString());
if (results == false)
{
Response.Redirect("~/LoginNew.aspx");
}
}
//Delete
protected void OnRowDeleting(object sender, GridViewDeleteEventArgs e)
{
POnum = Convert.ToInt32(TextBox5.Text);
string itemCode = GridView1.DataKeys[e.RowIndex].Values[0].ToString();
StoreBusinessLogic.DeleteItem(POnum, itemCode);
BindGrid(POnum);
}
protected void Button1_Click(object sender, EventArgs e)
{
int RequestID = 0;
string Description = "";
int RequestQty = 0;
int CollectionQty = 0;
try
{
if (GridView1.Rows.Count > 0)
{
foreach (GridViewRow row in GridView1.Rows)
{
RequestID = Int32.Parse((row.FindControl("Label1") as Label).Text);
Description = (row.FindControl("Label2") as Label).Text;
RequestQty = Int32.Parse((row.FindControl("Label3") as Label).Text);
CollectionQty = Int32.Parse((row.FindControl("textbox1") as TextBox).Text);
if (CollectionQty > RequestQty || CollectionQty < 0)
{
Session["count"] = 1;
}
}
}
else
{
lb_Inform.Text = "No Request now";
}
}
catch (Exception ex)
{
lb_Inform.Text = "Please input Positive Integer";
}
if (Convert.ToInt32(Session["count"]) == 1)
{
lb_Inform.Text = "CollectionQty can not more than RequestQty or be negative";
Session["count"] = 0;
}
else
{
try
{
foreach (GridViewRow row in GridView1.Rows)
{
RequestID = Int32.Parse((row.FindControl("Label1") as Label).Text);
Description = (row.FindControl("Label2") as Label).Text;
RequestQty = Int32.Parse((row.FindControl("Label3") as Label).Text);
CollectionQty = Int32.Parse((row.FindControl("textbox1") as TextBox).Text);
StoreBusinessLogic.UpdateOrder(RequestID, Description, RequestQty, CollectionQty);
}
Response.Redirect("~/StorePage/Retrieval Form.aspx");
}
catch (Exception ex)
{
lb_Inform.Text = "Please input Positive Integer";
}
}
}
protected void Button1_Click(object sender, EventArgs e)
{
try
{
if (GridView1.Rows.Count > 0)
{
foreach (GridViewRow row in GridView1.Rows)
{
int RequestID = Int32.Parse((row.FindControl("Label1") as Label).Text);
string ItemCode = (row.FindControl("Label2") as Label).Text;
string s = (row.FindControl("textbox1") as TextBox).Text;
string a = (row.FindControl("Label5") as Label).Text;
int CollectionQty = Convert.ToInt32(a);
int DisbursementQty = Convert.ToInt32(s);
if (DisbursementQty > CollectionQty || DisbursementQty < 0)
{
Session["count"] = 1;
}
}
}
else
{
lb_Inform.Text = "No pending Disbursment Now";
}
}
catch (Exception ex)
{
lb_Inform.Text = "Please input Positive Integer";
Button1.Enabled = true;
}
if (Convert.ToInt32(Session["count"]) == 1)
{
lb_Inform.Text = "DisbursementQty can not more than CollectionQty or be negative";
Session["count"] = 0;
}
else
{
try
{
foreach (GridViewRow row in GridView1.Rows)
{
int RequestID = Int32.Parse((row.FindControl("Label1") as Label).Text);
string ItemCode = (row.FindControl("Label2") as Label).Text;
string s = (row.FindControl("textbox1") as TextBox).Text;
int DisbursementQty = Convert.ToInt32(s);
StoreBusinessLogic.Disburse(RequestID, ItemCode, DisbursementQty);
}
Response.Redirect("~/StorePage/Disbursement List.aspx");
}
catch (Exception ex)
{
lb_Inform.Text = "Please input Positive Integer";
}
}
}
protected void Btn_add_Click(object sender, EventArgs e)
{
string suppcode = TB_suppCode.Text;
string suppname = TB_suppName.Text;
string contacttitle = TB_contactTitle.Text;
string contactname = TB_contactName.Text;
string phone = TB_phone.Text;
string fax = TB_fax.Text;
string address = TB_address.Text;
string postcode = TB_postalCode.Text;
string gst = TB_gst.Text;
StoreBusinessLogic.AddNewSupplier(suppcode, suppname, contacttitle,
contactname, phone, fax, address, postcode, gst);
}
protected void Btn_add_Click(object sender, EventArgs e)
{
string deptcode = TB_deptCode.Text;
string deptname = TB_deptName.Text;
string contactname = TB_contactName.Text;
string phone = TB_phone.Text;
string fax = TB_fax.Text;
string headname = TB_headName.Text;
string collectionpoint = TB_collectionPoint.Text;
string repname = TB_repName.Text;
string headtitle = TB_headTitle.Text;
string contacttitle = TB_contactTitle.Text;
StoreBusinessLogic.AddNewDepartment(deptcode, deptname, contactname, phone,
fax, headname, collectionpoint, repname, contacttitle, headtitle);
Label1.Text = "Add Successful";
}
//Place order
protected void Button2_Click(object sender, EventArgs e)
{
try
{
foreach (GridViewRow row in GridView1.Rows)
{
if (row.Visible == true)
{
int POnum = Convert.ToInt32(Label16.Text);
string ItemCode = (row.FindControl("Label7") as Label).Text;
string Category = (row.FindControl("Label8") as Label).Text;
string desp = (row.FindControl("Label9") as Label).Text;
int qty = Convert.ToInt32((row.FindControl("TextBox1") as TextBox).Text);
string suppCode = (row.FindControl("Label14") as Label).Text;
double price = Convert.ToDouble((row.FindControl("Label15") as Label).Text);
int orderedQty;
using (Model1 entities = new Model1())
{
Stock s = entities.Stocks.Where(p => p.ItemCode == ItemCode).First <Stock>();
orderedQty = Convert.ToInt32(s.OrderedQty) + qty;
}
if (qty >= 0)
{
StoreBusinessLogic.AddPO(POnum, ItemCode, desp, qty, price, suppCode);
StoreBusinessLogic.UpdateStock(ItemCode, orderedQty);
PoNo();
BindGrid();
Label18.Text = "Successful";
}
else
{
Label18.Text = "Please input Positive Integer";
}
}
}
PoNo();
string supp = DropDownList1.SelectedValue.ToString();
BindGrid(supp);
Label17.Text = "";
}
catch (Exception ex)
{
Label18.Text = "Invalid PO number!";
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
GridView1.DataSource = StoreBusinessLogic.GetAVListMan();
GridView1.DataBind();
}
if (Session["sign"].ToString() == "")
{
Response.Redirect("~/LoginNew.aspx");
}
Boolean results = empauthentication.ManagerAuthentication(Session["sign"].ToString());
if (results == false)
{
Response.Redirect("~/LoginNew.aspx");
}
}
protected void Page_Load(object sender, EventArgs e)
{
btn_Notification.Enabled = false;
int id = (int)Session["id"];
GridView1.DataSource = StoreBusinessLogic.GetAdjustbYidMang(id);
GridView1.DataBind();
if (Session["sign"].ToString() == "")
{
Response.Redirect("~/LoginNew.aspx");
}
Boolean results = empauthentication.ManagerAuthentication(Session["sign"].ToString());
if (results == false)
{
Response.Redirect("~/LoginNew.aspx");
}
}
protected void GridView1_SelectedIndexChanged(object sender, EventArgs e)
{
Model1 ctx = new Model1();
int avnumber = int.Parse(GridView1.SelectedRow.Cells[1].Text);
string itemcode = GridView1.SelectedRow.Cells[2].Text;
StoreBusinessLogic.EditAdjust(avnumber, itemcode, "Approved");
lab_successful.Text = "Change Successful";
AdjustmentVoucher A = ctx.AdjustmentVouchers.Where(x => x.AVnumber == avnumber).First();
A.ABName = Session["sign"].ToString();
User u = ctx.Users.Where(x => x.UserName == A.ABName).First();
A.ApproveBy = u.UserID;
ctx.SaveChanges();
btn_Notification.Enabled = true;
Session["CRName"] = A.CRName;
Session["content"] = Session["content"].ToString() + itemcode.ToString() + ",";
}
protected void Page_Load(object sender, EventArgs e)
{
btn_InformSupplier.Enabled = false;
if (!IsPostBack)
{
GridView_supplier.DataSource = StoreBusinessLogic.AllSupplier();
GridView_supplier.DataBind();
}
if (Session["sign"].ToString() == "")
{
Response.Redirect("~/LoginNew.aspx");
}
Boolean results = empauthentication.ClerkAuthentication(Session["sign"].ToString());
if (results == false)
{
Response.Redirect("~/LoginNew.aspx");
}
}
protected void OnRowUpdating(object sender, GridViewUpdateEventArgs e)
{
GridViewRow row = GridView_department.Rows[e.RowIndex];
string deptcode = Convert.ToString(GridView_department.DataKeys[e.RowIndex].Values[0]);
string deptname = (row.FindControl("TextBox1") as TextBox).Text;
string contacttitle = (row.FindControl("TextBox2") as TextBox).Text;
string contactname = (row.FindControl("TextBox3") as TextBox).Text;
string phone = (row.FindControl("TextBox4") as TextBox).Text;
string fax = (row.FindControl("TextBox5") as TextBox).Text;
string headtitle = (row.FindControl("TextBox6") as TextBox).Text;
string headname = (row.FindControl("TextBox7") as TextBox).Text;
string collectionpoint = (row.FindControl("TextBox8") as TextBox).Text;
string repname = (row.FindControl("TextBox9") as TextBox).Text;
Departmentcode = deptcode;
List <string> list = new List <string>()
{
deptcode, deptname, contacttitle, contactname, phone, fax, headtitle, headname, collectionpoint,
repname
};
foreach (string c in list)
{
if (c == "" || c == null)
{
Session["count"] = 1;
}
}
if (Convert.ToInt32(Session["count"]) == 1)
{
Label11.Text = "Infomation is not complete";
Session["count"] = 0;
}
else
{
StoreBusinessLogic.EditDepartment(deptcode, deptname, contactname,
phone, fax, headname, collectionpoint, repname, contacttitle, headtitle);
GridView_department.EditIndex = -1;
bindgrid();
btn_Inform.Enabled = true;
Btn_addNew.Enabled = true;
}
}
protected void OnRowUpdating(object sender, GridViewUpdateEventArgs e)
{
GridViewRow row = GridView_supplier.Rows[e.RowIndex];
string suppcode = Convert.ToString(GridView_supplier.DataKeys[e.RowIndex].Values[0]);
string suppname = (row.FindControl("TextBox1") as TextBox).Text;
string contacttitle = (row.FindControl("TextBox2") as TextBox).Text;
string contactname = (row.FindControl("TextBox3") as TextBox).Text;
string phone = (row.FindControl("TextBox4") as TextBox).Text;
string fax = (row.FindControl("TextBox5") as TextBox).Text;
string address = (row.FindControl("TextBox6") as TextBox).Text;
string postcode = (row.FindControl("TextBox7") as TextBox).Text;
string gst = (row.FindControl("TextBox8") as TextBox).Text;
Suppliercode = suppcode;
List <string> list = new List <string>()
{
suppcode, suppname, contacttitle, contactname, phone, fax, address, postcode, gst,
};
foreach (string c in list)
{
if (c == "" || c == null)
{
Session["count"] = 1;
}
}
if (Convert.ToInt32(Session["count"]) == 1)
{
Label10.Text = "Infomation is not complete";
Session["count"] = 0;
}
else
{
StoreBusinessLogic.EditSupplier(suppcode, suppname, contacttitle, contactname,
phone, fax, address, postcode, gst);
GridView_supplier.EditIndex = -1;
bindgrid();
btn_InformSupplier.Enabled = true;
Btn_addNew.Enabled = true;
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (Session["sign"].ToString() == "")
{
Response.Redirect("~/LoginNew.aspx");
}
if (!IsPostBack)
{
PoNo();
//BindGrid();
DropDownList1.DataSource = StoreBusinessLogic.ListSupp();
DropDownList1.DataTextField = "SuppCode";
DropDownList1.DataValueField = "SuppCode";
DropDownList1.DataBind();
}
Boolean results = empauthentication.ClerkAuthentication(Session["sign"].ToString());
if (results == false)
{
Response.Redirect("~/LoginNew.aspx");
}
}
//Add
protected void Button1_Click(object sender, EventArgs e)
{
try
{
int POnum = Int32.Parse(TextBox5.Text);
string ItemCode = TextBox1.Text;
string desp = DropDownList2.SelectedValue.ToString();
int qty = Int32.Parse(TextBox2.Text);
double price = double.Parse(TextBox3.Text);
string suppCode;
if (GridView1.Rows.Count <= 0)
{
suppCode = Label8.Text;
StoreBusinessLogic.AddPO(POnum, ItemCode, desp, qty, price, suppCode);
BindGrid(POnum);
}
else
{
PurchaseOrder po = ctx.PurchaseOrders.Where(p => p.POnumber == POnum).First();
if (Label8.Text.ToString() == po.SuppCode)
{
suppCode = Label8.Text;
StoreBusinessLogic.AddPO(POnum, ItemCode, desp, qty, price, suppCode);
BindGrid(POnum);
}
else
{
Label7.Text = "Please add same supplier to one purchaseOrder";
}
}
}
catch (Exception ex)
{
Label7.Text = "Please Input Valid Quantity";
}
}
protected void Button2_Click(object sender, EventArgs e)
{
int DOnum;
int POnum;
string ItemCode;
string desp;
int POQty;
int DeliveredQty;
string suppcode;
int currentQty;
int orderedQty;
try
{
if (GridView1.Rows.Count > 0)
{
foreach (GridViewRow row in GridView1.Rows)
{
DOnum = Convert.ToInt32(TextBox2.Text);
POnum = Convert.ToInt32(TextBox1.Text);
ItemCode = (row.FindControl("Label8") as Label).Text;
desp = (row.FindControl("Label9") as Label).Text;
POQty = Convert.ToInt32((row.FindControl("Label11") as Label).Text);
DeliveredQty = Convert.ToInt32((row.FindControl("TextBox4") as TextBox).Text);
suppcode = TextBox3.Text;
if (DeliveredQty > POQty || DeliveredQty < 0)
{
Session["count"] = 1;
}
}
}
else
{
Label17.Text = "Delivery Order Successfully";
}
}
catch (Exception EX)
{
Label17.Text = "Invalid DeliveredQty!";
}
if (Convert.ToInt32(Session["count"]) == 1)
{
Label17.Text = "Invalid DeliveredQty!";
Session["count"] = 0;
}
else
{
try
{
foreach (GridViewRow row in GridView1.Rows)
{
DOnum = Convert.ToInt32(TextBox2.Text);
POnum = Convert.ToInt32(TextBox1.Text);
ItemCode = (row.FindControl("Label8") as Label).Text;
desp = (row.FindControl("Label9") as Label).Text;
POQty = Convert.ToInt32((row.FindControl("Label11") as Label).Text);
DeliveredQty = Convert.ToInt32((row.FindControl("TextBox4") as TextBox).Text);
suppcode = TextBox3.Text;
using (Model1 entities = new Model1())
{
Stock s = entities.Stocks.Where(p => p.ItemCode == ItemCode).First <Stock>();
currentQty = Convert.ToInt32(s.CurrentQty);
orderedQty = Convert.ToInt32(s.OrderedQty);
}
StoreBusinessLogic.AddDO(DOnum, POnum, ItemCode, desp, POQty, DeliveredQty, suppcode);
currentQty = currentQty + DeliveredQty;
orderedQty = orderedQty - DeliveredQty;
StoreBusinessLogic.UpdateStock(ItemCode, currentQty, orderedQty);
}
Session["count"] = 2;
Response.Redirect("Delivered Items.aspx");
}
catch (Exception EX)
{
Label17.Text = "Invalid DeliveredQty!";
}
}
}
private void bindgrid()
{
GridView_department.DataSource = StoreBusinessLogic.AllDepartment();
GridView_department.DataBind();
}
private void bindgrid()
{
GridView_supplier.DataSource = StoreBusinessLogic.AllSupplier();
GridView_supplier.DataBind();
}
//Gridview
private void BindGrid(int POnum)
{
GridView1.DataSource = StoreBusinessLogic.ListPoBy(POnum);
GridView1.DataBind();
}
public ProductController()
{
_business = new ProductBusinessLogic();
_store = new StoreBusinessLogic();
}
public StoreController()
{
_business = new StoreBusinessLogic();
}
private void BindGrid(string supp)
{
GridView1.DataSource = StoreBusinessLogic.GetPOListAll(supp);
GridView1.DataBind();
}
