public void Update(bd_emp emp) { try { _db.bd_emp.AddOrUpdate(emp); _db.SaveChanges(); } catch (Exception ex) { throw ex; } }
public void Save(bd_emp emp) { try { var maxEmp = _db.bd_emp.Max(x => x.EMP_CODE); emp.EMP_CODE = maxEmp + 1; _db.bd_emp.Add(emp); _db.SaveChanges(); } catch (Exception ex) { } }
public bd_emp Delete(int EMP_CODE) { var del = new bd_emp(); try { var emp = Convert.ToInt32(EMP_CODE); del = _db.bd_emp.Where(x => x.EMP_CODE == emp).FirstOrDefault(); _db.bd_emp.Remove(del); _db.SaveChanges(); } catch (Exception ex) { throw ex; } return(del); }
public async System.Threading.Tasks.Task <HttpResponseMessage> Save() { try { if (!Request.Content.IsMimeMultipartContent()) { throw new HttpResponseException(HttpStatusCode.UnsupportedMediaType); } var provider = await Request.Content.ReadAsMultipartAsync <InMemoryMultipartFormDataStreamProvider>(new InMemoryMultipartFormDataStreamProvider()); //access form data NameValueCollection formData = provider.FormData; //access files IList <HttpContent> files = provider.Files; HttpContent file1 = files[0]; var thisFileName = file1.Headers.ContentDisposition.FileName.Trim('\"'); var stream = new MemoryStream(); await file1.CopyToAsync(stream); service.SaveFile(stream, thisFileName); CultureInfo provide = CultureInfo.InvariantCulture; var sa = new bd_emp(); //sa.EMP_CODE = Convert.ToInt64(formData["EMP_CODE"]); // var date = formData["BIRTH_DAY"]; sa.BIRTH_DAY = DateTime.ParseExact(formData["BIRTH_DAY"], "yyyy-MM-dd", provide); sa.FIRST_NAME = formData["FIRST_NAME"]; sa.LAST_NAME = formData["LAST_NAME"]; sa.NICK_NAME = formData["NICK_NAME"]; sa.PHOTO_PATH = thisFileName; dbHelper.Save(sa); // dbHelper.Delete(EMP_CODE); return(aReturnData("Success")); } catch (Exception ex) { return(aReturnError(ex.Message)); } }