public IHttpActionResult Put_TachGopMa(int id, KHO_INIT_TACH_GOP_MA kHO_INIT_TACH_GOP_MA)
{
if (!ModelState.IsValid)
{
return(BadRequest(ModelState));
}
if (id != kHO_INIT_TACH_GOP_MA.ID)
{
return(BadRequest());
}
using (var db = new ERP_DATABASEEntities())
{
db.Entry(kHO_INIT_TACH_GOP_MA).State = EntityState.Modified;
try
{
db.SaveChanges();
}
catch (DbUpdateConcurrencyException)
{
if (!KHO_INIT_TACH_GOP_MAExists(id))
{
return(NotFound());
}
else
{
throw;
}
}
return(StatusCode(HttpStatusCode.NoContent));
}
}
private bool KHO_INIT_TACH_GOP_MAExists(int id)
{
using (var db = new ERP_DATABASEEntities())
{
return(db.KHO_INIT_TACH_GOP_MA.Count(e => e.ID == id) > 0);
}
}
public ActionResult UpdateKhachHang_SaleHienThoi(HttpPostedFileBase file)
{
using (var db = new ERP_DATABASEEntities())
{
try
{
if (Request != null)
{
HttpPostedFileBase filetonkho = Request.Files["UploadedFile"];
if ((filetonkho != null) && (filetonkho.ContentLength > 0) && !string.IsNullOrEmpty(filetonkho.FileName))
{
string fileName = filetonkho.FileName;
string fileContentType = filetonkho.ContentType;
byte[] fileBytes = new byte[filetonkho.ContentLength];
var data = filetonkho.InputStream.Read(fileBytes, 0, Convert.ToInt32(filetonkho.ContentLength));
//var usersList = new List<Users>();
using (var package = new ExcelPackage(filetonkho.InputStream))
{
var currentSheet = package.Workbook.Worksheets;
var workSheet = currentSheet.First();
var noOfCol = workSheet.Dimension.End.Column;
var noOfRow = workSheet.Dimension.End.Row;
for (int rowIterator = 2; rowIterator <= noOfRow; rowIterator++)
{
var makhachhang = workSheet.Cells[rowIterator, 2].Value.ToString();
var khachhang = db.KH_CHUYEN_SALES.Where(x => x.MA_KHACH_HANG == makhachhang).FirstOrDefault();
if (khachhang != null)
{
if (workSheet.Cells[rowIterator, 4].Value != null)
{
khachhang.SALE_HIEN_THOI = workSheet.Cells[rowIterator, 4].Value.ToString();
}
so_dong_thanh_cong++;
dong = rowIterator - 1;
}
db.SaveChanges();
//dong = rowIterator;
}
}
}
}
}
catch (Exception Ex)
{
ViewBag.Error = " Đã xảy ra lỗi, Liên hệ ngay với admin. " + Environment.NewLine + " Thông tin chi tiết về lỗi:" + Environment.NewLine + Ex;
ViewBag.Information = "Lỗi tại dòng thứ: " + dong;
}
finally
{
ViewBag.Message = "Đã import thành công " + so_dong_thanh_cong + " dòng";
//ViewBag.Dongloi = "dòng lỗi: " + that_bai;
}
return(View("UpdateKhachHang_SaleHienThoi"));
}
}
// GET: BaoCaoKhachHang
public List <Prod_KH_ListKhachKhongMuaGanDay_Result> KH_Khong_Mua_Gan_Day(int page, ThamSo thansotimkiem)
{
using (var db = new ERP_DATABASEEntities())
{
var query = db.Database.SqlQuery <Prod_KH_ListKhachKhongMuaGanDay_Result>("Prod_KH_ListKhachKhongMuaGanDay @macongty, @isadmin, @username, @sotrang", new SqlParameter("macongty", thansotimkiem.macongty), new SqlParameter("isadmin", thansotimkiem.isadmin), new SqlParameter("username", thansotimkiem.ussername), new SqlParameter("sotrang", page));
var result = query.ToList();
return(result);
}
}
// private ERP_DATABASEEntities db = new ERP_DATABASEEntities();
// GET: api/Api_TachGopMaHang
public List <Prod_KHO_TachGopMa_Result> Get_DS_TachGop()
{
using (var db = new ERP_DATABASEEntities())
{
var query = db.Database.SqlQuery <Prod_KHO_TachGopMa_Result>("Prod_KHO_TachGopMa");
var data = query.ToList();
return(data);
}
}
public IHttpActionResult Get_Detail_TachGopMa(int id)
{
using (var db = new ERP_DATABASEEntities())
{
KHO_INIT_TACH_GOP_MA kHO_INIT_TACH_GOP_MA = db.KHO_INIT_TACH_GOP_MA.Find(id);
if (kHO_INIT_TACH_GOP_MA == null)
{
return(NotFound());
}
return(Ok(kHO_INIT_TACH_GOP_MA));
}
}
public IHttpActionResult DeleteLichLamViec(int id)
{
using (var db = new ERP_DATABASEEntities())
{
var query = db.NV_LICH_LAM_VIEC.Where(x => x.ID == id).FirstOrDefault();
if (query != null)
{
db.NV_LICH_LAM_VIEC.Remove(query);
}
db.SaveChanges();
return(Ok(id));
}
}
public IHttpActionResult Post_TachGopMa(KHO_INIT_TACH_GOP_MA kHO_INIT_TACH_GOP_MA)
{
if (!ModelState.IsValid)
{
return(BadRequest(ModelState));
}
using (var db = new ERP_DATABASEEntities())
{
db.KHO_INIT_TACH_GOP_MA.Add(kHO_INIT_TACH_GOP_MA);
db.SaveChanges();
return(CreatedAtRoute("DefaultApi", new { id = kHO_INIT_TACH_GOP_MA.ID }, kHO_INIT_TACH_GOP_MA));
}
}
public IHttpActionResult Delete_TachGopMa(int id)
{
using (var db = new ERP_DATABASEEntities())
{
KHO_INIT_TACH_GOP_MA kHO_INIT_TACH_GOP_MA = db.KHO_INIT_TACH_GOP_MA.Find(id);
if (kHO_INIT_TACH_GOP_MA == null)
{
return(NotFound());
}
db.KHO_INIT_TACH_GOP_MA.Remove(kHO_INIT_TACH_GOP_MA);
db.SaveChanges();
return(Ok(kHO_INIT_TACH_GOP_MA));
}
}
