public IActionResult Update([FromBody]CrudViewModel<SalesType> payload)
{
SalesType salesType = payload.value;
_context.SalesType.Update(salesType);
_context.SaveChanges();
return Ok(salesType);
}
private void btn_save_Click(object sender, EventArgs e)
{
ValidateInput();
SalesType type = new SalesType();
type.Id = int.Parse(lbl_id.Text.Trim());
type.Code = txt_code.Text.Trim().ToUpper();
type.Name = txt_des.Text.Trim();
if (CheckExistingRepository.CheckForExistingSalesType(txt_code.Text.Trim().ToUpper()))
{
if (MessageBox.Show("Do you want to update this record?", Messaging.MessageCaption, MessageBoxButtons.YesNo, MessageBoxIcon.Question) == DialogResult.Yes)
{
repo.Update(type);
GetData();
}
}
else
{
if (MessageBox.Show("Do you want to insert this record?", Messaging.MessageCaption, MessageBoxButtons.YesNo, MessageBoxIcon.Question) == DialogResult.Yes)
{
repo.Save(type);
GetData();
}
}
}
public Context(SalesType t)
{
config.Add("mormal", "DesignPattern._02策略模式2.CashNormal");
config.Add("rebate", "DesignPattern._02策略模式2.CashRebate");
config.Add("cashreturn", "DesignPattern._02策略模式2.CashReturn");
if (t == SalesType.mormal)
{
//s = new CashNormal();
}
else if (t == SalesType.cashreturn)
{
//s = new CashReturn();
m = 300;
j = 100;
}
else if (t == SalesType.rebate)
{
//s = new CashRebate();
rate = 0.8m;
}
Assembly asm = Assembly.GetExecutingAssembly();
string className;
config.TryGetValue(t.ToString(), out className);
s = (Strategy)asm.CreateInstance(className);
}
public IActionResult Insert([FromBody] CrudViewModel <SalesType> payload)
{
SalesType salesType = payload.value;
_context.SalesType.Add(salesType);
_context.SaveChanges();
return(Ok(salesType));
}
public async Task <IActionResult> GetBySalesType(SalesType salesType)
{
var items = await _deliveryVehicleRepository.AllIncluding(x => x.Vehicle).Where(x => x.SalesType == salesType).ToListAsync();
var results = Mapper.Map <IEnumerable <DeliveryVehicleViewModel> >(items);
return(Ok(results));
}
public IActionResult Insert([FromBody] CrudViewModel <SalesType> payload)
{
SalesType value = payload.value;
var result = _functionalService.Insert <SalesType>(value);
value = (SalesType)result.Data;
return(Ok(value));
}
public ActionResult DeleteConfirmed(int id)
{
SalesType salesType = db.SalesTypes.Find(id);
db.SalesTypes.Remove(salesType);
db.SaveChanges();
return(RedirectToAction("Index"));
}
public ActionResult Edit(SalesType item)
{
if (ModelState.IsValid)
{
CH.Edit <SalesType>(item);
return(RedirectToAction("Index"));
}
return(View(item));
}
public ActionResult Edit([Bind(Include = "id,sales_type,tax_included,factor,inactive")] SalesType salesType)
{
if (ModelState.IsValid)
{
db.Entry(salesType).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(salesType));
}
public ActionResult Edit([Bind(Include = "SalesTypeId,Name")] SalesType salesType)
{
if (ModelState.IsValid)
{
db.Entry(salesType).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(salesType));
}
public IActionResult Remove([FromBody] CrudViewModel <SalesType> payload)
{
SalesType salesType = _context.SalesType
.Where(x => x.SalesTypeId == (int)payload.key)
.FirstOrDefault();
_context.SalesType.Remove(salesType);
_context.SaveChanges();
return(Ok(salesType));
}
public ActionResult Create([Bind(Include = "SalesTypeId,Name")] SalesType salesType)
{
if (ModelState.IsValid)
{
db.SalesTypes.Add(salesType);
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(salesType));
}
private void NavigateDataGrid(string v)
{
SalesType type = repo.Get(int.Parse(v.Trim()));
if (type != null)
{
lbl_id.Text = type.Id.ToString();
txt_code.Text = type.Code;
txt_des.Text = type.Name;
}
}
public ActionResult Create([Bind(Include = "id,sales_type,tax_included,factor,inactive")] SalesType salesType)
{
if (ModelState.IsValid)
{
//db.SalesTypes.Add(salesType);
//db.SaveChanges();
WebServiceFA ws = new WebServiceFA();
ws.InsertSalesType(salesType);
return(RedirectToAction("Create"));
}
return(View(salesType));
}
// GET: SalesTypes/Delete/5
public ActionResult Delete(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
SalesType salesType = db.SalesTypes.Find(id);
if (salesType == null)
{
return(HttpNotFound());
}
return(View(salesType));
}
public Context(SalesType t)
{
if (t == SalesType.mormal)
{
s = new CashNormal();
}
else if (t == SalesType.cashreturn)
{
s = new CashReturn(300, 100);
}
else if (t == SalesType.rebate)
{
s = new CashRebate(0.8m);
}
}
public void Insert(string t, SalesType v)
{
string query = "INSERT INTO " + t + " (sales_type, tax_included, factor, inactive) VALUES('" + v.sales_type + "'," + v.tax_included + "," + v.factor + "," + v.inactive + ")";
//open connection
if (this.OpenConnection() == true)
{
//create command and assign the query and connection from the constructor
MySqlCommand cmd = new MySqlCommand(query, connection);
//Execute command
cmd.ExecuteNonQuery();
//close connection
this.CloseConnection();
}
}
public async Task <ActionResult <SalesType> > Update([FromBody] SalesType payload)
{
SalesType salesType = payload;
try
{
_context.SalesType.Update(salesType);
await _context.SaveChangesAsync();
}
catch (Exception ex)
{
_logger.LogError($"Ocurrio un error: { ex.ToString() }");
return(BadRequest($"Ocurrio un error:{ex.Message}"));
}
return(await Task.Run(() => Ok(salesType)));
}
public HttpResponseMessage Post(FormDataCollection form)
{
var model = new SalesType();
var values = JsonConvert.DeserializeObject <IDictionary>(form.Get("values"));
PopulateModel(model, values);
Validate(model);
if (!ModelState.IsValid)
{
return(Request.CreateErrorResponse(HttpStatusCode.BadRequest, GetFullErrorMessage(ModelState)));
}
var result = _context.SalesTypes.Add(model);
_context.SaveChanges();
return(Request.CreateResponse(HttpStatusCode.Created, result.SalesTypeId));
}
private void UpdateSalesOrder(int salesOrderId)
{
try
{
SalesOrder salesOrder = new SalesOrder();
salesOrder = _context.SalesOrder
.Where(x => x.SalesOrderId.Equals(salesOrderId))
.FirstOrDefault();
SalesType salesType = _context.SalesType.Where(st => st.SalesTypeId == salesOrder.SalesTypeId).SingleOrDefault();
if (salesOrder != null)
{
List <SalesOrderLine> lines = new List <SalesOrderLine>();
lines = _context.SalesOrderLine.Where(x => x.SalesOrderId.Equals(salesOrderId)).ToList();
//update master data by its lines
salesOrder.Amount = lines.Sum(x => x.Amount);
salesOrder.SubTotal = lines.Sum(x => x.SubTotal);
salesOrder.Discount = lines.Sum(x => x.DiscountAmount);
salesOrder.Tax = lines.Sum(x => x.TaxAmount);
double discountPercentage = 0;
if (salesType != null)
{
discountPercentage = salesType.DiscountPercentage;
}
else
{
salesOrder.Total = salesOrder.Freight + lines.Sum(x => x.Total) * (1 - discountPercentage);
}
_context.Update(salesOrder);
_context.SaveChanges();
}
}
catch (Exception)
{
throw;
}
}
private void PopulateModel(SalesType model, IDictionary values)
{
string SALES_TYPE_ID = nameof(SalesType.SalesTypeId);
string DESCRIPTION = nameof(SalesType.Description);
string SALES_TYPE_NAME = nameof(SalesType.SalesTypeName);
if (values.Contains(SALES_TYPE_ID))
{
model.SalesTypeId = Convert.ToInt32(values[SALES_TYPE_ID]);
}
if (values.Contains(DESCRIPTION))
{
model.Description = Convert.ToString(values[DESCRIPTION]);
}
if (values.Contains(SALES_TYPE_NAME))
{
model.SalesTypeName = Convert.ToString(values[SALES_TYPE_NAME]);
}
}
public async Task <ActionResult <SalesType> > Remove([FromBody] SalesType payload)
{
SalesType salesType = new SalesType();
try
{
salesType = _context.SalesType
.Where(x => x.SalesTypeId == (int)payload.SalesTypeId)
.FirstOrDefault();
_context.SalesType.Remove(salesType);
await _context.SaveChangesAsync();
}
catch (Exception ex)
{
_logger.LogError($"Ocurrio un error: { ex.ToString() }");
return(BadRequest($"Ocurrio un error:{ex.Message}"));
}
return(await Task.Run(() => Ok(salesType)));
// return Ok(salesType);
}
public override bool Equals(object obj)
{
return(obj == null || !(obj is Sale) ? false : SalesType.Equals(((Sale)obj).SalesType));
}
public string InsertSalesType(SalesType t)
{
db.Insert("0_sales_types", t);
return("Insertado con exito");
}
public static int Insert(SalesType SalesType)
{
return(WebApi <int> .PostAsync(controllerName, SalesType, "SinglePost").Result);
}
public override int GetHashCode()
{
return(SalesType.GetHashCode());
}
public static bool Update(SalesType SalesType)
{
return(WebApi <bool> .PutAsync(controllerName, SalesType, "Put").Result);
}
private void NewSalesType()
{
SelectedSalesType = new SalesType();
_SalesTypes.Add(SelectedSalesType);
}
public ApiResult <List <SalesType> > GetSalesTypeAll() => new ApiResult <List <SalesType> >(APIResultCode.Success, SalesType.GetAll().ToList());
