public BE_Json UpdateProduct([FromBody] BE_Product bE_Product)
{
BE_Json objJson = null;
var objListaAux = string.Empty;
try
{
BL_Product bL_Product = new BL_Product();
bL_Product.connectionString = AppConfig.DbConnection;
objListaAux = JsonConvert.SerializeObject(bL_Product.UpdateProduct(bE_Product));
objJson = new BE_Json();
objJson.data = (objListaAux == "null") ? "No se pudo editar el producto: El código ya existe" : objListaAux;
objJson.status = (objListaAux == "null") ? CManager.RESULTADO_WCF.ERROR : CManager.RESULTADO_WCF.OK;
}
catch (Exception ex)
{
objJson = new BE_Json();
objJson.data = "Hubo en error en servidor:" + ex.Message + ";" + ex.StackTrace + ";" + ex.ToString();
objJson.status = CManager.RESULTADO_WCF.ERROR;
objJson.status = CManager.RESULTADO_WCF.ERROR;
}
finally
{
objListaAux = null;
}
return(objJson);
}
public BE_Json CreateProduct([FromBody] BE_Product bE_Product)
{
logger.Debug("Ingresando CreateProduct step 1 : " + JsonConvert.SerializeObject(bE_Product));
BE_Json objJson = null;
var objListaAux = string.Empty;
try
{
BL_Product bL_Product = new BL_Product();
bL_Product.connectionString = AppConfig.DbConnection;
logger.Debug("CreateProduct step 2");
objListaAux = JsonConvert.SerializeObject(bL_Product.CreateProduct(bE_Product));
logger.Debug("CreateProduct step 3");
objJson = new BE_Json();
objJson.data = (objListaAux == "null") ? "No de pudo crear el producto: El código ya existe" : objListaAux;
objJson.status = (objListaAux == "null")?CManager.RESULTADO_WCF.ERROR:CManager.RESULTADO_WCF.OK;
logger.Debug("CreateProduct step 4");
}
catch (Exception ex)
{
logger.Fatal(ex, "CreateProduct " + ex.Message);
objJson = new BE_Json();
objJson.data = "Hubo en error en servidor:" + ex.Message + ";" + ex.StackTrace + ";" + ex.ToString();
objJson.status = CManager.RESULTADO_WCF.ERROR;
}
finally
{
objListaAux = null;
}
logger.Debug("CreateProduct step 5");
return(objJson);
}
public BE_Json GetProductByTypeId(string productTypeIdList)
{
BE_Json objJson = null;
var objListaAux = string.Empty;
try
{
BL_Product bL_Product = new BL_Product();
bL_Product.connectionString = AppConfig.DbConnection;
objListaAux = JsonConvert.SerializeObject(bL_Product.GetProductByTypeId(productTypeIdList));
objJson = new BE_Json();
objJson.data = objListaAux;
objJson.status = CManager.RESULTADO_WCF.OK;
}
catch (Exception ex)
{
objJson = new BE_Json();
objJson.data = "Hubo en error en servidor:" + ex.Message + ";" + ex.StackTrace + ";" + ex.ToString();
objJson.status = CManager.RESULTADO_WCF.ERROR;
objJson.status = CManager.RESULTADO_WCF.ERROR;
}
finally
{
objListaAux = null;
}
return(objJson);
}
// TODO: adding validation to the textboxes
private void btnSave_Click(object sender, RoutedEventArgs e)
{
BL_Product.Save(Model, LanguageList.SingleOrDefault(lang => lang.ISO == "eng").Id);
if (MessageBox.Show("Product saved", "Product saved", MessageBoxButton.OK) == MessageBoxResult.OK)
{
this.Visibility = Visibility.Collapsed;
}
}
private void BindData()
{
datasource = new ObservableCollection <ProductOverView>(BL_Product.GetAllOverView());
// datasource.CollectionChanged += DataSourceChanged;
dgrdProducts.ItemsSource = datasource;
dgrdProducts.DataContext = datasource;
}
public JsonResult BindTable()
{
BL_Product fillTable = new BL_Product();
return(new JsonResult {
Data = fillTable.GetData(), JsonRequestBehavior = JsonRequestBehavior.AllowGet, MaxJsonLength = 86753090
});
}
public JsonResult Rebind_Data(int id)
{
BL_Product fill_data = new BL_Product();
return(new JsonResult {
Data = fill_data.Bind_From_Table(id), JsonRequestBehavior = JsonRequestBehavior.AllowGet, MaxJsonLength = 86753090
});
}
public ProductDetail(int productID)
{
InitializeComponent();
Product model = BL_Product.GetProduct(productID);
Model = model;
int englishId = BL_Language.GetEnglishLanguages().Id;
LocalizeProduct = model.Localize_Product.Single(lcp => lcp.Language_ID == englishId);
this.DataContext = this;
}
private static void Delete(BE_Product BE_Product)
{
try
{
BL_Product BL_Product = new BL_Product();
BL_Product.connectionString = ConfigurationManager.ConnectionStrings["pagosapp"].ConnectionString;;
int result = BL_Product.DeleteProduct(BE_Product.productId);
}
catch (Exception ex)
{
throw ex;
}
}
public static void Update(BE_Product BE_Product)
{
try
{
BL_Product BL_Product = new BL_Product();
BL_Product.connectionString = ConfigurationManager.ConnectionStrings["pagosapp"].ConnectionString;;
BE_Product result = BL_Product.UpdateProduct(BE_Product);
}
catch (Exception ex)
{
throw;
}
}
public static BE_Product create(BE_Product view)
{
try
{
BL_Product BL_Product = new BL_Product();
//view..UserAudit = "carlosaban";
BL_Product.connectionString = ConfigurationManager.ConnectionStrings["pagosapp"].ConnectionString;;
BE_Product result = BL_Product.CreateProduct(view);
return(result);
}
catch (Exception ex)
{
throw ex;
}
}
public JsonResult Bind_HSNCODE(string prefix)
{
BL_Product bl_hsn = new BL_Product();
List <Product> search_hsn = new List <Product>();
DataSet ds = bl_hsn.Bind_HSN(prefix);
foreach (DataRow dr in ds.Tables[0].Rows)
{
search_hsn.Add(new Product
{
HSNSACCode = dr["HSNCode"].ToString(),
});
}
return(new JsonResult {
Data = search_hsn, JsonRequestBehavior = JsonRequestBehavior.AllowGet, MaxJsonLength = 86753090
});
}
public static List <VE_Product> get()
{
try
{
BL_Product BL_Product = new BL_Product();
BL_Product.connectionString = ConfigurationManager.ConnectionStrings["pagosapp"].ConnectionString;;
List <VE_Product> list = BL_Product.GetProduct();
return(list);
}
catch (Exception ex)
{
throw;
}
//return new List<VE_Product>();
}
public JsonResult Bind_Cat(string prefix)
{
BL_Product bl_cat = new BL_Product();
List <Product> search_cat = new List <Product>();
DataSet ds = bl_cat.Bind_Category(prefix, "%");
foreach (DataRow dr in ds.Tables[0].Rows)
{
search_cat.Add(new Product
{
category = dr["ProductCategoryName"].ToString(),
categoryID = dr["ProductCategoryID"].ToString(),
});
}
return(new JsonResult {
Data = search_cat, JsonRequestBehavior = JsonRequestBehavior.AllowGet, MaxJsonLength = 86753090
});
}
public JsonResult Bind_Gen(string prefix)
{
BL_Product bl_gen = new BL_Product();
List <Product> search_gen = new List <Product>();
DataSet ds = bl_gen.Bind_Generic(prefix, "%");
foreach (DataRow dr in ds.Tables[0].Rows)
{
search_gen.Add(new Product
{
generic = dr["GenericName"].ToString(),
genericID = dr["GenericID"].ToString(),
});
}
return(new JsonResult {
Data = search_gen, JsonRequestBehavior = JsonRequestBehavior.AllowGet, MaxJsonLength = 86753090
});
}
public JsonResult Bind_Pack(string prefix)
{
BL_Product bl_packp = new BL_Product();
List <Product> search_pack = new List <Product>();
DataSet ds = bl_packp.Bind_Packing(prefix, "%");
foreach (DataRow dr in ds.Tables[0].Rows)
{
search_pack.Add(new Product
{
packing = dr["ProductUnitName"].ToString(),
packingID = dr["ProductUnitID"].ToString(),
});
}
return(new JsonResult {
Data = search_pack, JsonRequestBehavior = JsonRequestBehavior.AllowGet, MaxJsonLength = 86753090
});
}
public JsonResult Bind_productComp(string prefix)
{
BL_Product bl_productComp = new BL_Product();
List <Product> search_productComp = new List <Product>();
DataSet ds = bl_productComp.Bind_Prod_Company(prefix, "%");
foreach (DataRow dr in ds.Tables[0].Rows)
{
search_productComp.Add(new Product
{
productCompany = dr["ProductCompanyName"].ToString(),
productCompanyID = dr["ProductCompanyNameID"].ToString(),
});
}
return(new JsonResult {
Data = search_productComp, JsonRequestBehavior = JsonRequestBehavior.AllowGet, MaxJsonLength = 86753090
});
}
