public DataSet fetchpricelist(DTO.NewPriceLists Ob)
{
SqlCommand cmd = new SqlCommand();
DataSet ds = new DataSet();
cmd.CommandText = "sp_itempricelist";
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@BranchId", Ob.BranchId);
ds = PrjClass.GetData(cmd);
cmd.Dispose();
return(ds);
}
public string SaveNewItemprice(DTO.NewPriceLists Ob)
{
string Result = string.Empty;
SqlCommand cmd = new SqlCommand();
cmd.CommandText = "sp_itempricelistinsertdata";
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@ItemCode", Ob.ItemCode);
cmd.Parameters.AddWithValue("@BranchId", Ob.BranchId);
cmd.Parameters.AddWithValue("@ItemSubItemRef", Ob.SubItemRefID);
cmd.Parameters.AddWithValue("@ItemCategoryId", Ob.CategoryID);
cmd.Parameters.AddWithValue("@ItemVariationId", Ob.VariationId);
cmd.Parameters.AddWithValue("@Processid", Ob.Processid);
cmd.Parameters.AddWithValue("@Price", Ob.Price);
cmd.Parameters.AddWithValue("@DateCreated", Ob.DateCreated);
cmd.Parameters.AddWithValue("@DateModified", Ob.DateModified);
cmd.Parameters.AddWithValue("@Active", Ob.Active);
cmd.Parameters.AddWithValue("@Flag", 1);
Result = PrjClass.ExecuteNonQuery(cmd);
cmd.Dispose();
return(Result);
}
public string SaveNewItemprice(DTO.NewPriceLists Ob)
{
return(DAL.DALFactory.Instance.DAL_NewPriceLists.SaveNewItemprice(Ob));
}
public DataSet fetchpricelist(DTO.NewPriceLists Ob)
{
return(DAL.DALFactory.Instance.DAL_NewPriceLists.fetchpricelist(Ob));
}
public DataSet fetchpricelistcoloumvaluecountvalue(DTO.NewPriceLists Ob)
{
return(DAL.DALFactory.Instance.DAL_NewPriceLists.fetchpricelistcoloumvaluecountvalue(Ob));
}
