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";
}
}
