public bool CheckItemStatus(DTO.Item Ob)
{
SqlCommand cmd = new SqlCommand();
SqlDataReader sdr = null;
bool status = false;
try
{
cmd.CommandText = "sp_Item";
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@ItemName", Ob.ItemName);
cmd.Parameters.AddWithValue("@BranchId", Ob.BranchId);
cmd.Parameters.AddWithValue("@Flag", "14");
sdr = PrjClass.ExecuteReader(cmd);
if (sdr.Read())
{
status = true;
}
else
{
status = false;
}
}
catch (Exception ex) { }
finally
{
sdr.Close();
sdr.Dispose();
cmd.Dispose();
}
return(status);
}
public DataSet BindGrid(DTO.Item Ob)
{
DataSet ds = new DataSet();
SqlCommand cmd = new SqlCommand();
cmd.CommandText = "sp_Item";
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@BranchId", Ob.BranchId);
cmd.Parameters.AddWithValue("@Flag", "9");
ds = PrjClass.GetData(cmd);
return(ds);
}
public string DeleteSubItem(DTO.Item Ob)
{
SqlCommand cmd = new SqlCommand();
cmd.CommandText = "sp_Item";
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@OldItemName", Ob.OldItemName);
cmd.Parameters.AddWithValue("@BranchId", Ob.BranchId);
cmd.Parameters.AddWithValue("@Flag", "5");
Common.Result = PrjClass.ExecuteNonQuery(cmd);
return(Common.Result);
}
protected void btnDelete_ServerClick(object sender, EventArgs e)
{
bool success = false;
Item = SaveValue();
Common.Result = BAL.BALFactory.Instance.BAL_Item.DeleteNewItem(Item);
success = true;
if (success)
{
lblError.InnerText = "Item has been deleted.";
}
}
public string DeleteNewItem(DTO.Item Ob)
{
SqlCommand cmd = new SqlCommand();
cmd.CommandText = "sp_Item";
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@BranchId", Ob.BranchId);
cmd.Parameters.AddWithValue("@ItemId", Ob.ID);
cmd.Parameters.AddWithValue("@ItemSubItemRef", Ob.SubItemRefID);
cmd.Parameters.AddWithValue("@ItemCategoryId", Ob.CategoryID);
cmd.Parameters.AddWithValue("@ItemVariationId", Ob.VariationId);
cmd.Parameters.AddWithValue("@Flag", "11");
Common.Result = PrjClass.ExecuteNonQuery(cmd);
return(Common.Result);
}
public void SaveDefPrcAndRate(ref DTO.Item Item, string branchId, bool isUpdating, int rateListId)
{
SqlCommand sqlCommand = new SqlCommand
{
CommandText = "sp_Item",
CommandType = CommandType.StoredProcedure
};
sqlCommand.Parameters.AddWithValue("@BranchId", branchId);
sqlCommand.Parameters.AddWithValue("@ItemName", Item.ItemName.ToUpperInvariant());
sqlCommand.Parameters.AddWithValue("@PrcCode", Item.DefaultPrc);
sqlCommand.Parameters.AddWithValue("@ItemRate", Item.DefaultRate);
sqlCommand.Parameters.AddWithValue("@RateListId", rateListId);
sqlCommand.Parameters.AddWithValue("@Flag", !isUpdating ? 15 : 16);
if (PrjClass.ExecuteNonQuery(sqlCommand) != "Record Saved")
{
throw new DataException("Couldn't' save the default records!");
}
}
protected void btnSave_ServerClick(object sender, EventArgs e)
{
bool success = false;
Item = SaveValue();
if (Item.ID == "0" || Item.ID == "")
{
Common.Result = BAL.BALFactory.Instance.BAL_Item.SaveNewItem(Item);
}
else
{
Common.Result = BAL.BALFactory.Instance.BAL_Item.UpdateNewItem(Item);
}
success = true;
if (success)
{
lblError.InnerText = "Item has been saved successfully.";
}
}
private void btnImport_Click(object sender, EventArgs e)
{
DTO.Item item = null;
foreach (DTO.Item temp in lstItem)
{
if (temp.Nameitem.Equals(txtItem.Text))
{
item = temp;
break;
}
}
if (item != null)
{
lstDetail.Add(new DTO.DetailBill(item.Nameitem, (int)nudAmount.Value, item.Price));
}
txtItem.ResetText();
nudAmount.Value = 1;
cbbListItem.Items.Add(lstDetail[lstDetail.Count - 1].Item);
}
public string SaveItem(DTO.Item Ob)
{
if (CheckIfItemCodeExits(Ob.ItemCode, Ob.BranchId) == false)
{
SqlCommand cmd = new SqlCommand();
cmd.CommandText = "sp_Item";
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@ItemName", Ob.ItemName);
cmd.Parameters.AddWithValue("@NoOfItem", Ob.NoOfItem);
cmd.Parameters.AddWithValue("@ItemCode", Ob.ItemCode);
cmd.Parameters.AddWithValue("@BranchId", Ob.BranchId);
cmd.Parameters.AddWithValue("@Unit", Ob.VariationId);
cmd.Parameters.AddWithValue("@Flag", "1");
Common.Result = PrjClass.ExecuteNonQuery(cmd);
}
else
{
Common.Result = "Item code already exists Please Provide a Unique Item Code";
}
return(Common.Result);
}
public DataSet SearchItem(DTO.Item Ob)
{
return(DAL.DALFactory.Instance.DAL_Item.SearchItem(Ob));
}
public void InsertNewItem(DTO.Item item)
{
int tid = Convert.ToInt16(DALConnect.Instance.ExecuteQueryDataSet("select titemid from TYPE_ITEMS where typeitem = N'" + item.Typeitem + "'", CommandType.Text).Tables[0].Rows[0]["titemid"]);
DALConnect.Instance.MyExecuteNonQuery("insert into ITEMS(titemid, nameitem, price, amount) values(" + tid + ", N'" + item.Nameitem + "', " + item.Price + "," + item.Amount + ");", CommandType.Text);
}
public void UpdateItem(DTO.Item item)
{
int tid = Convert.ToInt16(DALConnect.Instance.ExecuteQueryDataSet("select titemid from TYPE_ITEMS where typeitem = N'" + item.Typeitem + "'", CommandType.Text).Tables[0].Rows[0]["titemid"]);
DALConnect.Instance.MyExecuteNonQuery("update ITEMS set titemid = " + tid + ", nameitem = N'" + item.Nameitem + "',price = " + item.Price + ", amount = " + item.Amount + " where iid =" + item.Id, CommandType.Text);
}
public bool CheckItemStatus(DTO.Item Ob)
{
return(DAL.DALFactory.Instance.DAL_Item.CheckItemStatus(Ob));
}
public string SaveItem(DTO.Item Ob)
{
return(DAL.DALFactory.Instance.DAL_Item.SaveItem(Ob));
}
public string UpdateNewItem(DTO.Item Ob)
{
return(DAL.DALFactory.Instance.DAL_Item.UpdateNewItem(Ob));
}
public DataSet FillTextBox(DTO.Item Ob)
{
return(DAL.DALFactory.Instance.DAL_Item.FillTextBox(Ob));
}
public DataSet BindGrid(DTO.Item Ob)
{
return(DAL.DALFactory.Instance.DAL_Item.BindGrid(Ob));
}
public string DeleteSubItem(DTO.Item Ob)
{
return(DAL.DALFactory.Instance.DAL_Item.DeleteSubItem(Ob));
}
public DataSet ShowAllItem(DTO.Item Ob)
{
return(DAL.DALFactory.Instance.DAL_Item.ShowAllItem(Ob));
}
