public IActionResult TransferBysite(int id, string site, string item, decimal qty)
{
IActionResult response = Unauthorized();
TranSectionFixAsset tran = new TranSectionFixAsset();
var checkdata = _context.tranSectionFixAsset.Where(a => a.TranSectionFixAssetId == id && a.FixAccNo == item && a.site == site && a.FixAssetQty == qty).ToList();
if (checkdata == null)
{
}
else
{
foreach (var std in checkdata as IList <TranSectionFixAsset> )
{
tran = std;
}
}
return(Ok(tran));
}
public async Task <IActionResult> TransferBysiteConfirm(int id, string site, decimal qty, string etc, string selectType)
{
IActionResult response = Unauthorized();
var transectionold = await _context.tranSectionFixAsset.Where(a => a.TranSectionFixAssetId == id).FirstAsync();
TranSectionFixAsset transectionNew = new TranSectionFixAsset();
if (transectionold == null)
{
}
else
{
var now = DateTime.Now;
transectionNew.FixAccNo = transectionold.FixAccNo;
transectionNew.FixAssetQty = qty;
transectionNew.FixAssetItem = transectionold.FixAssetItem;
transectionNew.FixAssetItem2 = transectionold.FixAssetItem2;
transectionNew.site = site;
transectionNew.TransectionDate = now;
transectionNew.ActionData = "<button data-fixaccno-type='" + transectionold.FixAccNo + "' data-qty-type='" + qty + "' data-site-type='" + site + "' onclick='reclassdata(this)' class='btn btn-info btn-sm'>Move</button>";
transectionNew.TransectionType = selectType;
transectionNew.TransectionBy = HttpContext.Session.GetString("Username");
transectionNew.TransectionEtc = etc;
try
{
transectionold.ActionData = "<button data-dataId-type='" + transectionold.TranSectionFixAssetId + "' data-fixaccno-type='" + transectionold.FixAccNo + "' data-qty-type='" + (transectionold.FixAssetQty - qty) + "' data-site-type='" + transectionold.site + "' onclick='reclassdata(this)' class='btn btn-info btn-sm'>Move</button>";
transectionold.FixAssetQty = transectionold.FixAssetQty - qty;
_context.Update(transectionold);
await _context.SaveChangesAsync();
}
catch (DbUpdateConcurrencyException)
{
}
try
{
_context.tranSectionFixAsset.Add(transectionNew);
await _context.SaveChangesAsync();
}
catch (DbUpdateConcurrencyException)
{
}
var username = HttpContext.Session.GetString("Username");
var editdata = _context.tranSectionFixAsset.Where(a => a.FixAccNo == transectionNew.FixAccNo && a.TransectionBy == username && a.TransectionEtc == etc && a.FixAssetQty == qty && a.site == site && a.TransectionDate == now).ToList();
try
{
TranSectionFixAsset tranedit = new TranSectionFixAsset();
if (editdata != null)
{
foreach (var data in editdata as IList <TranSectionFixAsset> )
{
tranedit = data;
tranedit.ActionData = "<button data-dataId-type='" + data.TranSectionFixAssetId + "' data-fixaccno-type='" + data.FixAccNo + "' data-qty-type='" + qty + "' data-site-type='" + data.site + "' onclick='reclassdata(this)' class='btn btn-info btn-sm'>Move</button>";
}
_context.Update(tranedit);
await _context.SaveChangesAsync();
}
}
catch
{
}
}
return(Ok());
}
public async Task <IActionResult> TransectionData(string FixAccNo, string FixAssetName, string FixAssetName1, string SiteName, int qty, string TransectionType, string TransectionEtc)
{
IActionResult response = Unauthorized();
TranSectionFixAsset tran = new TranSectionFixAsset();
var now = DateTime.Now;
tran.FixAccNo = FixAccNo;
tran.FixAssetQty = qty;
tran.FixAssetItem = FixAssetName;
tran.FixAssetItem2 = FixAssetName1;
tran.site = SiteName;
tran.TransectionDate = now;
tran.ActionData = "<button data-fixaccno-type='" + FixAccNo + "' data-qty-type='" + qty + "' data-site-type='" + SiteName + "' onclick='reclassdata(this)' class='btn btn-info btn-sm'>Move</button>";
tran.TransectionType = TransectionType;
tran.TransectionBy = HttpContext.Session.GetString("Username");
tran.TransectionEtc = TransectionEtc;
_context.tranSectionFixAsset.Add(tran);
await _context.SaveChangesAsync();
var username = HttpContext.Session.GetString("Username");
var editdata = _context.tranSectionFixAsset.Where(a => a.FixAccNo == FixAccNo && a.TransectionBy == username && a.TransectionEtc == TransectionEtc && a.FixAssetQty == qty && a.site == SiteName && a.TransectionDate == now).ToList();
try
{
TranSectionFixAsset tranedit = new TranSectionFixAsset();
if (editdata != null)
{
foreach (var data in editdata as IList <TranSectionFixAsset> )
{
tranedit = data;
tranedit.ActionData = "<button data-dataId-type='" + data.TranSectionFixAssetId + "' data-fixaccno-type='" + FixAccNo + "' data-qty-type='" + qty + "' data-site-type='" + SiteName + "' onclick='reclassdata(this)' class='btn btn-info btn-sm'>Move</button>";
}
_context.Update(tranedit);
await _context.SaveChangesAsync();
}
}
catch
{
}
var sumdata = _context.tranSectionFixAsset.Where(c => c.FixAccNo == FixAccNo).Sum(p => p.FixAssetQty);
var checkdata = _context.fixAccessDataTmps.Where(a => a.FixAccNo == FixAccNo).ToList();
foreach (var std1 in checkdata as IList <FixAccessDataTmp> )
{
if (FixAccNo == std1.FixAccNo)
{
std1.FATransfer = sumdata;
std1.LastModifi = DateTime.Now;
try
{
_context.Update(std1);
await _context.SaveChangesAsync();
}
catch (DbUpdateConcurrencyException)
{
}
}
}
return(Ok(tran));
}
