public IActionResult InsertProd([FromBody] FixedPriceProduct prod)
{
Dictionary <string, object> jsonData = new Dictionary <string, object>();
try
{
var crt_user = User.FindFirst("Account").Value;
var fxpRepos = HttpContext.RequestServices.GetService <FixedPriceRepository>();
fxpRepos.InsertProd(prod, crt_user);
jsonData["status"] = "OK";
}
catch (Exception ex)
{
jsonData.Clear();
jsonData.Add("status", "FAIL");
jsonData.Add("msg", ex.Message);
}
return(Json(jsonData));
}
public static void UpdateFixedPriceProduct(FixedPriceProduct fp_prod, string upd_user)
{
try
{
string sqlStmt = @"INSERT INTO b2b.b2d_fixedprice_prod(company_xid, prod_no, prod_name, upd_user, upd_datetime)
VALUES (:company_xid, :prod_no, :prod_name, :upd_user, now())";
NpgsqlParameter[] sqlParams = new NpgsqlParameter[] {
new NpgsqlParameter("company_xid", fp_prod.COMPANY_XID),
new NpgsqlParameter("prod_no", fp_prod.PROD_NO),
new NpgsqlParameter("prod_name", fp_prod.PROD_NAME),
new NpgsqlParameter("crt_user", upd_user)
};
NpgsqlHelper.ExecuteNonQuery(Website.Instance.SqlConnectionString, CommandType.Text, sqlStmt, sqlParams);
}
catch (Exception ex)
{
Website.Instance.logger.FatalFormat("{0}.{1}", ex.Message, ex.StackTrace);
throw ex;
}
}
public void InsertProd(FixedPriceProduct prod, string crt_user)
{
FixedPriceDAL.InsertFixedPriceProduct(prod, crt_user);
}
