/// <summary>
/// Method to update Food Product Attribute
/// </summary>
/// <param name="objGbMProductAttribute"></param>
public string[] UpdFoodProductAttribute(GbMProductAttribute objGbMProductAttribute)
{
try
{
SqlParameter[] parameter =
{
new SqlParameter("@ProductDetailId", objGbMProductAttribute.ProductId),
new SqlParameter("@BasePrice", objGbMProductAttribute.BasePrice),
new SqlParameter("@IsDefault", objGbMProductAttribute.IsDefault),
new SqlParameter("@IsActive", objGbMProductAttribute.IsActive),
new SqlParameter("@CrtBy", objGbMProductAttribute.CrtBy),
new SqlParameter("@CrtIP", objGbMProductAttribute.CrtIp),
new SqlParameter("@ErrorMsg", SqlDbType.VarChar, 50)
{
Direction = ParameterDirection.Output
},
new SqlParameter("@ErrorDesc", SqlDbType.VarChar, 500)
{
Direction = ParameterDirection.Output
}
};
return(FSC_Helper.ExecuteNonQueryOutputResult(FSC_Helper.ConnectionStringLocalTransaction,
CommandType.StoredProcedure, DBConstant.PROC_PRODUCT_UPDFOODPRODUCTATTRIBUTE, new string[] { "@ErrorMsg", "@ErrorDesc" }, parameter));
}
catch (Exception ex)
{
throw ex;
}
}
/// <summary>
/// Method to insert and update Food Product
/// </summary>
/// <param name="objGbMProduct"></param>
public string[] InsUpdFoodProduct(GbMProduct objGbMProduct, DataTable dtProductAttributes)
{
try
{
SqlParameter[] parameter =
{
new SqlParameter("@ProductId", objGbMProduct.ProductId),
new SqlParameter("@CategoryId", objGbMProduct.CategoryId),
new SqlParameter("@VendorId", objGbMProduct.VendorId),
new SqlParameter("@ProductName", objGbMProduct.ProductName),
new SqlParameter("@ProductDesc", objGbMProduct.ProductDesc),
new SqlParameter("@BasePrice", objGbMProduct.BasePrice),
new SqlParameter("@BaseCurrencyId", objGbMProduct.BaseCurrencyId),
new SqlParameter("@VegNonVeg", objGbMProduct.VegNonVeg),
new SqlParameter("@ImageURL", objGbMProduct.ImageURL),
new SqlParameter("@IsAllowedToCustomise", objGbMProduct.IsAllowedToCustomise),
new SqlParameter("@Udt_FoodProduct_Attributes", dtProductAttributes),
new SqlParameter("@IsActive", objGbMProduct.IsActive),
new SqlParameter("@CrtBy", objGbMProduct.CrtBy),
new SqlParameter("@CrtIP", objGbMProduct.CrtIp),
new SqlParameter("@ErrorMsg", SqlDbType.VarChar, 50)
{
Direction = ParameterDirection.Output
},
new SqlParameter("@ErrorDesc", SqlDbType.VarChar, 500)
{
Direction = ParameterDirection.Output
}
};
return(FSC_Helper.ExecuteNonQueryOutputResult(FSC_Helper.ConnectionStringLocalTransaction,
CommandType.StoredProcedure, DBConstant.PROC_PRODUCT_INSUPDFOODPRODUCT, new string[] { "@ErrorMsg", "@ErrorDesc" }, parameter));
}
catch (Exception ex)
{
throw ex;
}
}