protected void ItemList_RowDeleting(object sender, GridViewDeleteEventArgs e) { try { hdnUserId.Value = ItemList.DataKeys[e.RowIndex].Values[0].ToString(); } catch (Exception ex) { lblMsg.Text = ex.Message; } if (!string.IsNullOrEmpty(hdnUserId.Value)) { ItemOrProduct dbItem = ItemManager.getItemById(new Guid(hdnUserId.Value)); if (dbItem != null) { bool statusOfDelete = ItemManager.deleteItem(dbItem); hdnUserId.Value = ""; if (statusOfDelete) { lblMsg.Text = "Item Deleted successfully!!"; bindData(); } else { lblMsg.Text = "Unable To perform Desired Operation!!"; } } } }
public static bool insertItem(ItemOrProduct itm, bool isInsert) { bool status = false; if (itm != null) { SampleDatabaseDataContext dc = new SampleDatabaseDataContext(); if (isInsert) { itm.CreatedOn = DateTime.Now; dc.ItemOrProducts.InsertOnSubmit(itm); } else { ItemOrProduct dbItem = dc.ItemOrProducts.Where(x => x.ItemID == itm.ItemID).SingleOrDefault(); dbItem.Name = itm.Name; dbItem.PurchasePrice = itm.PurchasePrice; dbItem.SalesPrice = itm.SalesPrice; dbItem.OpeningQty = itm.OpeningQty; dbItem.InStock = itm.InStock; } dc.SubmitChanges(); status = true; } return(status); }
protected void GridView1_RowUpdating(object sender, GridViewUpdateEventArgs e) { hdnUserId.Value = GridView1.DataKeys[e.RowIndex].Values[0].ToString(); if (!string.IsNullOrEmpty(hdnUserId.Value)) { ItemOrProduct obj = new ItemOrProduct(); obj.ItemID = new Guid(hdnUserId.Value); obj.Name = ((TextBox)GridView1.Rows[e.RowIndex].FindControl("TextBox1")).Text; obj.PurchasePrice = decimal.Parse(((TextBox)GridView1.Rows[e.RowIndex].FindControl("TextBox2")).Text); obj.SalesPrice = decimal.Parse(((TextBox)GridView1.Rows[e.RowIndex].FindControl("TextBox3")).Text); obj.OpeningQty = double.Parse(((TextBox)GridView1.Rows[e.RowIndex].FindControl("TextBox4")).Text); bool status = ItemManager.EditItem(obj); if (status) { bool edit = true; Response.Redirect("ItemList.aspx?edit=" + edit); } else { lblerrormsg.Text = "Editing Failed."; } } }
public static void DeleteItemDetails(Guid itemId) { DataClassesSampleDatabaseDataContext db = new DataClassesSampleDatabaseDataContext(); ItemOrProduct obj = db.ItemOrProducts.Where(x => x.ItemID == itemId).SingleOrDefault(); db.ItemOrProducts.DeleteOnSubmit(obj); db.SubmitChanges(); }
public static bool deleteItem(ItemOrProduct Itm) { bool status = false; if (Itm != null) { SampleDatabaseDataContext dc = new SampleDatabaseDataContext(); ItemOrProduct dbItem = dc.ItemOrProducts.Where(x => x.ItemID == Itm.ItemID).SingleOrDefault(); dc.ItemOrProducts.DeleteOnSubmit(dbItem); dc.SubmitChanges(); status = true; } return(status); }
public static bool AddItem(ItemOrProduct obj) { bool status = false; if (obj != null) { DataClassesSampleDatabaseDataContext db = new DataClassesSampleDatabaseDataContext(); obj.CreatedOn = DateTime.Now; db.ItemOrProducts.InsertOnSubmit(obj); db.SubmitChanges(); status = true; } return(status); }
protected void addBtn_Click(object sender, EventArgs e) { if (string.IsNullOrEmpty(nameTxtBox.Text)) { lblerrormsg.Text = "Name cannot be empty."; nameTxtBox.Focus(); return; } if (string.IsNullOrEmpty(ppriceTxtBox.Text)) { lblerrormsg.Text = "Purchase price cannot be empty."; ppriceTxtBox.Focus(); return; } if (string.IsNullOrEmpty(spriceTxtBox.Text)) { lblerrormsg.Text = "Sales price cannot be empty."; spriceTxtBox.Focus(); return; } if (string.IsNullOrEmpty(qtyTxtBox.Text)) { lblerrormsg.Text = "Quantity cannot be empty."; qtyTxtBox.Focus(); return; } ItemOrProduct obj = new ItemOrProduct(); obj.ItemID = Guid.NewGuid(); obj.Name = nameTxtBox.Text; obj.PurchasePrice = decimal.Parse(ppriceTxtBox.Text); obj.SalesPrice = decimal.Parse(spriceTxtBox.Text); obj.OpeningQty = double.Parse(qtyTxtBox.Text); bool status = ItemManager.AddItem(obj); if (status) { bool message = true; Response.Redirect("~/Web/Item/ItemList.aspx?status=" + message); } }
protected void Page_Load(object sender, EventArgs e) { heading.Text = "ADD Item"; if (!IsPostBack) { hdn_fieldID.Value = Request.QueryString["id"]; if (!string.IsNullOrEmpty(hdn_fieldID.Value)) { ItemOrProduct dbItm = ItemManager.getItemById(new Guid(hdn_fieldID.Value)); if (dbItm != null) { tb_ItemName.Text = dbItm.Name; tb_PurchasePrice.Text = dbItm.PurchasePrice.ToString(); tb_SalesPrice.Text = dbItm.SalesPrice.ToString(); tb_qty.Text = dbItm.OpeningQty.ToString(); if (dbItm.InStock == "Yes") { inStockYes.Checked = true; } else { inStockNo.Checked = true; } btn_save.Text = "Update"; heading.Text = "Update Item"; btn_clear.Visible = false; } } } }
public static bool EditItem(ItemOrProduct obj) { bool status = false; if (obj != null) { DataClassesSampleDatabaseDataContext db = new DataClassesSampleDatabaseDataContext(); ItemOrProduct dbobj = db.ItemOrProducts.Where(x => x.ItemID == obj.ItemID).SingleOrDefault(); if (dbobj != null) { dbobj.Name = obj.Name; dbobj.PurchasePrice = obj.PurchasePrice; dbobj.SalesPrice = obj.SalesPrice; dbobj.OpeningQty = obj.OpeningQty; dbobj.ModifiedOn = DateTime.Now; } db.SubmitChanges(); status = true; } return(status); }
protected void btn_save_Click(object sender, EventArgs e) { if (string.IsNullOrEmpty(tb_ItemName.Text)) { lbl_forMsg.Text = "Item Name cannot Be Empty!!"; tb_ItemName.Focus(); return; } if (string.IsNullOrEmpty(tb_PurchasePrice.Text)) { lbl_forMsg.Text = "Item's purchase price cannot be Empty!!"; tb_PurchasePrice.Focus(); return; } if (string.IsNullOrEmpty(tb_SalesPrice.Text)) { lbl_forMsg.Text = "Item's sales price Field cannot be Empty!!"; tb_SalesPrice.Focus(); return; } if (string.IsNullOrEmpty(tb_qty.Text)) { lbl_forMsg.Text = "Item's Opening Qty Field cannot be Empty!!"; tb_qty.Focus(); return; } bool isInsert; ItemOrProduct item = new ItemOrProduct(); if (!string.IsNullOrEmpty(hdn_fieldID.Value)) { //update isInsert = false; item.ItemID = new Guid(hdn_fieldID.Value); } else { item.ItemID = Guid.NewGuid(); isInsert = true; //insert } try { item.Name = tb_ItemName.Text; } catch (Exception ex) { lbl_forMsg.Text = ex.Message; } try { item.PurchasePrice = decimal.Parse(tb_PurchasePrice.Text); } catch (Exception ex) { lbl_forMsg.Text = ex.Message; } try { item.SalesPrice = decimal.Parse(tb_SalesPrice.Text); } catch (Exception ex) { lbl_forMsg.Text = ex.Message; } try { item.OpeningQty = int.Parse(tb_qty.Text); } catch (Exception ex) { lbl_forMsg.Text = ex.Message; } if (inStockYes.Checked) { item.InStock = "Yes"; } else if (inStockNo.Checked) { item.InStock = "No"; } else { lbl_forMsg.Text = "No Enough Information!! Please Select Availability option (Yes/No)"; return; } bool status = ItemManager.insertItem(item, isInsert); if (status) { clearData(); lbl_forMsg.ForeColor = System.Drawing.Color.Green; if (isInsert) { lbl_forMsg.Text = "Item Inserted Successfully!!"; } else { bool success = true; Response.Redirect("~/Web/Item/ItemList.aspx?status=" + success); } } else { lbl_forMsg.ForeColor = System.Drawing.Color.Red; lbl_forMsg.Text = isInsert ? "Cannot Insert New Record!!" : "Cannot Update Record"; } }