public ActionResult Update(Int32 id, HttpPostedFileBase fileUpload, FormCollection f)
{
try
{
if (ModelState.IsValid)
{
m_objSUPPLIER = db.SUPPLIERS.Find(id);
//Upload File
if (fileUpload != null)
{
string _fileNameRandom = m_STRING_RANDOM_IMAGE.RandomString();
m_objSUPPLIER.IMAGE = "~/Images/ADMIN/SUPPLIERS/" + _fileNameRandom + fileUpload.FileName;
string _path = Path.Combine(Server.MapPath("~/Images/ADMIN/SUPPLIERS/" + _fileNameRandom + fileUpload.FileName));
fileUpload.SaveAs(_path);
}
m_objSUPPLIER.IDX = int.Parse(f.Get("IDX").ToString());
db.SaveChanges();
}
else
{
TempData["VB_ErrorCreate"] = "Thêm không thành công, kiểm tra lại dữ liệu.";
}
return(RedirectToAction("ManagingSuppliers", "Admin"));
}
catch (Exception ex)
{
return(RedirectToAction("Http404", "Error")); // 404
}
}
public ActionResult Create(SUPPLIER collection)
{
try
{
using (var client = new HttpClient())
{
client.BaseAddress = new Uri("http://localhost:31766/api/");
//HTTP POST
var postTask = client.PostAsJsonAsync <SUPPLIER>("Supplierapi", collection);
postTask.Wait();
var result = postTask.Result;
if (result.IsSuccessStatusCode)
{
return(RedirectToAction("Index"));
}
}
return(RedirectToAction("Index"));
}
catch
{
return(View());
}
}
private void btnAddCustomer_Click(object sender, RoutedEventArgs e)
{
SUPPLIER supplier = new SUPPLIER();
if (txtFullName.Text != string.Empty && txtAddress.Text != string.Empty && cboSupplierStatus.Text != string.Empty)
{
supplier.SUPPLIER_NAME = txtFullName.Text;
supplier.SUPPLIER_ADDRESS = txtAddress.Text;
supplier.SUPPLIER_CONTACT_NO = Convert.ToInt64(txtContactNo1.Text);
supplier.SUPPLIER_TYPE = Convert.ToInt32(cmbSupplierType.SelectedValue);
supplier.SUPPLIER_STATUS = Convert.ToInt32(cboSupplierStatus.SelectedValue);
data.Insert <SUPPLIER>(supplier);
BindSuppliers();
}
else
{
MessageBox.Show("Please Fill All the mandatory fields");
return;
}
Common.ClearAllControls <TextBox>(addSupplier, 1);
Common.ClearAllControls <ComboBox>(addSupplier);
MessageBox.Show("Supplier Added Succesfully");
}
public async Task <IHttpActionResult> PutSUPPLIER(string id, SUPPLIER sUPPLIER)
{
if (!ModelState.IsValid)
{
return(BadRequest(ModelState));
}
if (id != sUPPLIER.SUPLNO)
{
return(BadRequest());
}
db.Entry(sUPPLIER).State = EntityState.Modified;
try
{
await db.SaveChangesAsync();
}
catch (DbUpdateConcurrencyException)
{
if (!SUPPLIERExists(id))
{
return(NotFound());
}
else
{
throw;
}
}
return(StatusCode(HttpStatusCode.NoContent));
}
public async Task <ActionResult> CreateSupplier(SUPPLIER i)
{
try
{
SUPPLIER Value = new SUPPLIER();
if (ModelState.IsValid)
{
TryUpdateModel(Value);
using (var client = new HttpClient())
{
client.BaseAddress = new Uri(Baseurl);
client.DefaultRequestHeaders.Clear();
client.DefaultRequestHeaders.Accept.Add(new MediaTypeWithQualityHeaderValue("application/json"));
var myContent = JsonConvert.SerializeObject(Value);
var buffer = System.Text.Encoding.UTF8.GetBytes(myContent);
ByteArrayContent byteContent = new ByteArrayContent(buffer);
HttpResponseMessage Res = await client.PostAsJsonAsync <SUPPLIER>("api/SUPPLIERS/", Value);
SUPPLIER SupplierInfo = new SUPPLIER();
if (Res.IsSuccessStatusCode)
{
var SupplierResponse = Res.Content.ReadAsStringAsync().Result;
SupplierInfo = JsonConvert.DeserializeObject <SUPPLIER>(SupplierResponse);
return(RedirectToAction("Index"));
}
}
}
}
catch (Exception e)
{
throw e;
}
return(View());
}
private void btnNewSupplier_Click(object sender, EventArgs e)
{
SUPPLIER s = (sUPPLIERBindingSource.AddNew() as SUPPLIER);
s.DATE_OF_REGISTER = DateTime.UtcNow;
NewSupplier = true;
}
public ActionResult Search(FormCollection f)
{
try
{
if (!string.IsNullOrEmpty(Session["SUPPLIER"].ToString()))
{
Session["SUPPLIER"] = "DEFAULT";
Session["SUPPLIER_MODEL"] = db.SUPPLIERS.Find(20);
}
string key = f.Get("txtKeySearch").ToString().Trim();
SUPPLIER _SUPPLIER = (SUPPLIER)Session["SUPPLIER_MODEL"];
List <PRODUCT> _lstPRODUCT = db.PRODUCTS.Where(n => (n.PRODUCT_CODE.Contains(key) || n.PRODUCT_NAME.Contains(key))).ToList();
ViewBag.KeySearch = key;
ViewBag.NumProduct = _lstPRODUCT.Count;
ViewBag.ListSupplier = new SelectList(db.SUPPLIERS.OrderByDescending(n => n.SUPPLIER_ID).ToList(), "Supplier_ID", "SUPPLIER_NAME");
ViewBag.ListCategory = new SelectList(db.CATEGORIES.OrderByDescending(n => n.CATEGORY_ID).ToList(), "Category_ID", "CATEGORY_NAME");
Session["KeySearch"] = key;
return(View(_lstPRODUCT));
}
catch (Exception ex)
{
return(RedirectToAction("Http404", "Error")); // 404
}
}
public void deleteSupplier(string id)
{
SUPPLIER obj = UShopDB.SUPPLIERs.Where(o => o.SUPPLIER_ID == Convert.ToInt32(id)).SingleOrDefault();
obj.RECORD_STATUS = "D";
UShopDB.SubmitChanges();
}
public IHttpActionResult PutSUPPLIER(int id, SUPPLIER sUPPLIER)
{
if (!ModelState.IsValid)
{
return(BadRequest(ModelState));
}
if (id != sUPPLIER.ID_SUPPLIER)
{
return(BadRequest());
}
db.Entry(sUPPLIER).State = EntityState.Modified;
try
{
db.SaveChanges();
}
catch (DbUpdateConcurrencyException)
{
if (!SUPPLIERExists(id))
{
return(NotFound());
}
else
{
throw;
}
}
return(StatusCode(HttpStatusCode.NoContent));
}
public JsonResult Edit(string para01, string para02, string para03)
{
string id = para01;
string name = para02;
string number = para03;
SUPPLIER sUPPLIER = db.SUPPLIER.Find(id);
sUPPLIER.SUPPLIER_ID = id;
sUPPLIER.SUPPLIER_NAME = name;
sUPPLIER.PHONE_NUMBER = number;
db.Entry(sUPPLIER).State = EntityState.Modified;
try
{
db.SaveChanges();
}
catch (Exception ex)
{
throw;
}
var list = db.SUPPLIER.Select(n => new { SUPPLIER_ID = n.SUPPLIER_ID, SUPPLIER_NAME = n.SUPPLIER_NAME, PHONE_NUMBER = n.PHONE_NUMBER });
return(Json(new { code = 0, msg = "", count = 1000, data = list }, JsonRequestBehavior.AllowGet));
}
public void DeleteSupplier(string SuplNo)
{
SUPPLIER supplierEntity = _context.SUPPLIERs.Find(SuplNo);
_context.SUPPLIERs.Remove(supplierEntity);
_context.SaveChanges();
}
public SUPPLIER GetSUPPLIERFromReader(IDataReader reader)
{
try
{
SUPPLIER sUPPLIER = new SUPPLIER
(
(int)reader["SUPPLIERID"],
reader["SUPPLIERNAME"].ToString(),
reader["SUPPLIERADDRESS1"].ToString(),
reader["SUPPLIERADDRESS2"].ToString(),
reader["SUPPLIERCITY"].ToString(),
(char)reader["SUPPLIERSTATE"],
reader["SUPPLIERZIP"].ToString(),
reader["SUPPLIERPHONE"].ToString(),
(DateTime)reader["CREATED_ON"],
reader["CREATED_BY"].ToString(),
(DateTime)reader["UPDATED_ON"],
reader["UPDATED_BY"].ToString()
);
return(sUPPLIER);
}
catch (Exception ex)
{
return(null);
}
}
public IHttpActionResult PostSUPPLIER(SUPPLIER sUPPLIER)
{
if (!ModelState.IsValid)
{
return(BadRequest(ModelState));
}
db.SUPPLIERs.Add(sUPPLIER);
try
{
db.SaveChanges();
}
catch (DbUpdateException)
{
if (SUPPLIERExists(sUPPLIER.SUPLNO))
{
return(Conflict());
}
else
{
throw;
}
}
return(CreatedAtRoute("DefaultApi", new { id = sUPPLIER.SUPLNO }, sUPPLIER));
}
public SupplierDTO createSupplier(SupplierDTO supplierDTO)
{
try
{
Db.Ado.BeginTran();
SUPPLIER supplier = new SUPPLIER();
supplier.NAME = supplierDTO._name;
supplier.PHONE = supplierDTO._phone;
supplier.CREDIT_LEVEL = supplierDTO._credit_level;
Db.Insertable(supplier).IgnoreColumns(it => new { it.SUPPLIER_ID }).ExecuteCommand();
var cid = Db.Ado.SqlQuery <int>("select ISEQ$$_75582.currval from dual");
var id = cid[0];
Db.Ado.CommitTran();
supplierDTO._supplier_id = id;
return(supplierDTO);
}
catch (Exception e)
{
Db.Ado.RollbackTran();
return(null);
}
}
public IHttpActionResult PutSUPPLIER(string id, SUPPLIER sUPPLIER)
{
//if (!ModelState.IsValid)
//{
// return BadRequest(ModelState);
//}
if (id != sUPPLIER.SUPLNO)
{
return(BadRequest());
}
try
{
db.SaveChanges();
}
catch (DbUpdateConcurrencyException)
{
if (!SUPPLIERExists(id))
{
return(NotFound());
}
else
{
throw;
}
}
return(StatusCode(HttpStatusCode.NoContent));
}
public IHttpActionResult PostSUPPLIER(SUPPLIER sUPPLIER)
{
//if (!ModelState.IsValid)
//{
// return BadRequest(ModelState);
//}
var d = db.SUPPLIERs.Include(X => X.POMASTERs).First();
var e = new POMASTER {
PONO = "PO" + sUPPLIER.SUPLNO.Substring(2, 2), PODATE = DateTime.Now
};
d.POMASTERs.Add(e);
db.Entry(sUPPLIER).State = EntityState.Modified;
db.SUPPLIERs.Add(sUPPLIER);
try
{
db.SaveChanges();
}
catch (DbUpdateException)
{
if (SUPPLIERExists(sUPPLIER.SUPLNO))
{
return(Conflict());
}
else
{
throw;
}
}
return(CreatedAtRoute("DefaultApi", new { id = sUPPLIER.SUPLNO }, sUPPLIER));
}
// DELETE api/values/5
public void Delete(string id)
{
SUPPLIER supplierOld = dbContext.SUPPLIERs.Where(a => a.SUPLNO == id).FirstOrDefault();
dbContext.Entry(supplierOld).State = System.Data.Entity.EntityState.Deleted;
dbContext.SaveChanges();
}
public void Put([FromBody] SUPPLIER item)
{
using (PODbEntities db = new PODbEntities())
{
db.Entry(item).State = System.Data.Entity.EntityState.Modified;
db.SaveChanges();
}
}
public void Post([FromBody] SUPPLIER item)
{
using (PODbEntities db = new PODbEntities())
{
db.SUPPLIERs.Add(item);
db.SaveChanges();
}
}
public void saveSupplier(SUPPLIER obj)
{
_model.addSupplier(obj);
if (_view != null)
{
_view.loadSuppliers(_model.loadSupplier());
}
}
public ActionResult DeleteConfirmed(string id)
{
SUPPLIER sUPPLIER = db.SUPPLIERS.Find(id);
db.SUPPLIERS.Remove(sUPPLIER);
db.SaveChanges();
return(RedirectToAction("Index"));
}
public static SUPPLIER GetSUPPLIERByID(int id)
{
SUPPLIER sUPPLIER = new SUPPLIER();
SqlSUPPLIERProvider sqlSUPPLIERProvider = new SqlSUPPLIERProvider();
sUPPLIER = sqlSUPPLIERProvider.GetSUPPLIERByID(id);
return(sUPPLIER);
}
public ActionResult DeleteConfirmed(int id)
{
SUPPLIER supplier = db.SUPPLIERS.Single(s => s.ID == id);
db.SUPPLIERS.DeleteObject(supplier);
db.SaveChanges();
return(RedirectToAction("Index"));
}
public ActionResult DeleteSupplier(SUPPLIER _supplier)
{
if (ModelState.IsValid)
{
supplier.DeleteSupplier(_supplier.SUPLNO);
return(RedirectToAction("DisplaySuppliers"));
}
return(View());
}
public HttpResponseMessage CreateSupplier(SupplierModel _SupplierModel)
{
try
{
SUPPLIER sup = new SUPPLIER();
sup.SUPPLIER_CODE = _SupplierModel.SUPPLIER_CODE;
sup.SUPPLIER_NAME = _SupplierModel.SUPPLIER_NAME;
sup.ADDRESS = _SupplierModel.ADDRESS;
sup.VAT_NUMBER = _SupplierModel.VAT_NUMBER;
sup.POSTCODE = _SupplierModel.POSTCODE;
sup.COUNTRY = _SupplierModel.COUNTRY;
sup.WEBSITE = _SupplierModel.WEBSITE;
sup.VAT_TYPE = _SupplierModel.VAT_TYPE;
sup.PRICE_TYPE = _SupplierModel.PRICE_TYPE;
//sup.DATES_STARTED = _SupplierModel.DATE_STARTED;
sup.DYNAMIC_DISC = _SupplierModel.DYNAMIC_DISC;
sup.SEND_MAIL = _SupplierModel.SEND_MAIL;
//sup.COMPANY_ID = _SupplierModel.COMPANY_ID;
sup.SUPPLIER_INACTIVE = _SupplierModel.SUPPLIER_INACTIVE;
sup.REGISTERED = _SupplierModel.REGISTERED;
sup.DUNS_NO = _SupplierModel.DUNS_NO;
sup.STATEMENT = _SupplierModel.STATEMENT;
sup.IS_CUSTOMER = _SupplierModel.IS_CUSTOMER;
sup.DATE_STARTED = _SupplierModel.DATE_STARTED;
//sup.LAST_PAYMENT = _SupplierModel.LAST_PAYMENT;
sup.CASH_ACC = _SupplierModel.CASH_ACC;
//sup.AVG_PMT_DAY = _SupplierModel.AVG_PMT_DAY;
sup.DEF_PMT_DAY = _SupplierModel.DEF_PMT_DAY;
sup.GROUP = _SupplierModel.GROUP;
sup.GROUP_DESC = _SupplierModel.GROUP_DESC;
sup.SUB_CONTRACTOR = _SupplierModel.SUB_CONTRACTOR;
sup.CONTACT_TYPE = _SupplierModel.CONTACT_TYPE;
sup.CONTACT_NAME = _SupplierModel.CONTACT_NAME;
sup.CONTACT_SALUTATION = _SupplierModel.CONTACT_SALUTATION;
sup.CONTACT_PHONE_NO = _SupplierModel.CONTACT_PHONE_NO;
sup.CONTACT_EXTN_NO = _SupplierModel.CONTACT_EXTN_NO;
sup.CONTACT_MOBILE_NO = _SupplierModel.CONTACT_MOBILE_NO;
sup.CONTACT_FAX = _SupplierModel.CONTACT_FAX;
sup.EMAIL = _SupplierModel.EMAIL;
sup.SKYPE = _SupplierModel.SKYPE;
//sup.CREDIT_LIMIT = _SupplierModel.CREDIT_LIMIT;
sup.IS_DELETE = false;
sup.STATUS = "Un-Saved";
db.SUPPLIERs.Add(sup);
db.SaveChanges();
}
catch (Exception)
{
throw;
}
return(Request.CreateResponse(HttpStatusCode.OK, "success"));
}
public ActionResult EditSupplier(SUPPLIER item)
{
if (ModelState.IsValid)
{
supplier.UpdateSupplier(item);
return(RedirectToAction("DisplaySuppliers"));
}
return(View());
}
public bool test(string id)
{
SUPPLIER sUPPLIER = db.SUPPLIER.Find(id);
if (sUPPLIER != null)
{
return(true);
}
return(false);
}
//
// GET: /ManagingSuppliers/Edit/5
public ActionResult Edit(int id = 0)
{
SUPPLIER supplier = db.SUPPLIERS.Find(id);
if (supplier == null)
{
return(HttpNotFound());
}
return(View(supplier));
}
public void AddSupplier(Supplier supplier)
{
using (var db = new StoreDbContext())
{
SUPPLIER sup = Mapper.Map <SUPPLIER>(supplier);
db.Set <SUPPLIER>().Add(sup);
db.SaveChanges();
}
}
public IHttpActionResult GetSUPPLIER(int id)
{
SUPPLIER sUPPLIER = db.SUPPLIER.Find(id);
if (sUPPLIER == null)
{
return(NotFound());
}
return(Ok(sUPPLIER));
}
public ContactViewModel Convert(SUPPLIER supplierToConvert)
{
ContactViewModel contactViewModel = new ContactViewModel();
contactViewModel.xeroContactId = supplierToConvert.ext_key;
contactViewModel.accountNumber = supplierToConvert.supplier1;
if (string.IsNullOrEmpty(supplierToConvert.ext_key1))
{
//if(string.IsNullOrEmpty(supplierToConvert.name.Trim()))
//{
// throw new SupplierNameIsEmptyException("The name of supplier " + supplierToConvert.supplier1 + " is empty. Please check the date and try again.");
//}
if(!(DoesNameAlreadyExistInXero(supplierToConvert.name.Trim())))
{
contactViewModel.name = supplierToConvert.name.Trim();
}
else
{
throw new SupplierNameAlreadyExistException("The name of supplier " + supplierToConvert.supplier1 + " is already used as a name for a contact in Xero. The name of a contact must be unique. Please check the data and try agian.");
}
}
else
{
contactViewModel.name = supplierToConvert.ext_key1;
}
contactViewModel.address1 = supplierToConvert.address1.Trim();
contactViewModel.address2 = supplierToConvert.address2.Trim();
contactViewModel.address3 = supplierToConvert.address3.Trim();
contactViewModel.postalcode = supplierToConvert.postcode.Trim();
contactViewModel.addressType = "STREET";
contactViewModel.phone = supplierToConvert.phone.Trim();
contactViewModel.mobileNumber = supplierToConvert.mphone.Trim();
contactViewModel.faxNumber = supplierToConvert.fax.Trim();
contactViewModel.defaultCurrency = supplierToConvert.currency.Trim();
contactViewModel.contactName = supplierToConvert.contact.Trim();
contactViewModel.isArchived = supplierToConvert.rec_del.GetValueOrDefault();
try
{
contactViewModel.email = GetSplitedEmailAddress(supplierToConvert.email, supplierToConvert.supplier1);
}
catch (NotVailidEmailException)
{
throw;
}
return contactViewModel;
}
