public int delAsset(MMRFixedAsset tbl)
{
try
{
string tglA = tbl.dDelete.Substring(0, 2);
string blnA = tbl.dDelete.Substring(3, 2);
string thnA = tbl.dDelete.Substring(6, 4);
string newDate = thnA + "/" + blnA + "/" + tglA;
string StartDate = thnA + "/" + blnA + "/01";
DynamicParameters param;
string sqlcmd;
sqlcmd = "update tAsset set fisDelete=1, dDelete=@tgl, dStartDelete=@awaltgl, cBuktiDelete=@bukti where id=@idnya";
param = new DynamicParameters();
param.Add("@idnya", tbl.id);
param.Add("@tgl", newDate);
param.Add("@awaltgl", StartDate);
param.Add("@bukti", tbl.cBuktiDelete);
var rst = _db.Execute(sqlcmd, param);
return(rst);
}
catch (Exception)
{
throw;
}
}
public int updAssetArea(MMRFixedAsset tbl)
{
try
{
string refnomer = "";
string NewCode = tbl.cINVCOde.Substring(0, 9);
string thnB = tbl.dMMRDate.Substring(8, 2);
string thnA = tbl.dMMRDate.Substring(6, 4);
string CodeArea = tbl.cArea;
int iThnB = Convert.ToInt16(thnA);
//--tbl.cInvTypeKode = cInvGroup
refnomer = NewCode + '.' + CodeArea + '.' + thnB + ValRecord(iThnB, "cArea", "tAsset", CodeArea);
DynamicParameters param;
string sqlcmd;
sqlcmd = "update tAsset set cArea=@area, cUrut=@nourut where id=@idnya";
param = new DynamicParameters();
param.Add("@idnya", tbl.id);
param.Add("@area", tbl.cArea);
param.Add("@nourut", refnomer);
var rst = _db.Execute(sqlcmd, param);
return(rst);
}
catch (Exception)
{
throw;
}
}
public int insPM(MMRFixedAsset tbl)
{
try
{
DynamicParameters param;
string sqlcmd;
sqlcmd = "update tAsset set fisMachine=1 where id=@idnya";
param = new DynamicParameters();
param.Add("@idnya", tbl.cINVCOde);
var rst = _db.Execute(sqlcmd, param);
return(rst);
}
catch (Exception)
{
throw;
}
}
public int insManualAsset(MMRFixedAsset tbl)
{
try
{
DynamicParameters param;
var rst = 0;
string sqlcmd;
string refnomer = "";
string tglA = tbl.dMMRDate.Substring(0, 2);
string blnA = tbl.dMMRDate.Substring(3, 2);
string thnA = tbl.dMMRDate.Substring(6, 4);
string thnB = tbl.dMMRDate.Substring(8, 2);
string newDate = thnA + "/" + blnA + "/" + tglA;
string NewName = tbl.cINVCOde;
double Newharga = tbl.ihargabelirp;
string CodeArea = tbl.cArea;
int iThnB = Convert.ToInt16(thnA);
string NewCode = tbl.cDescription.Substring(0, 9);
refnomer = NewCode + '.' + CodeArea + '.' + thnB + ValRecord(iThnB, "cArea", "tAsset", CodeArea);
param = new DynamicParameters();
param.Add("@tglmr", newDate);
param.Add("@item", NewName);
param.Add("@tipe", tbl.cInvTypeKode);
param.Add("@rate", tbl.Rate);
param.Add("@price", Newharga);
param.Add("@nourut", refnomer);
param.Add("@carea", CodeArea);
sqlcmd = "INSERT INTO tAsset(dMMRDate, cInvName, cInvGroup, cArea, iRate, cUrut, iQty, iHargaperPcs, HargaTot, fisMachine)" +
" VALUES(@tglmr, @item, @tipe, @carea, @rate, @nourut, 1, @price, @price, 0) ";
rst = _db.Execute(sqlcmd, param);
return(rst);
}
catch (Exception)
{
throw;
}
}
public int insAsset(MMRFixedAsset tbl)
{
try
{
DynamicParameters param;
var rst = 0;
string sqlcmd;
string tglA = tbl.dMMRDate.Substring(0, 2);
string blnA = tbl.dMMRDate.Substring(3, 2);
string thnA = tbl.dMMRDate.Substring(6, 4);
string thnB = tbl.dMMRDate.Substring(8, 2);
string newDate = thnA + "/" + blnA + "/" + tglA;
string NewCode = tbl.cINVCOde;
string NewCodeVal = tbl.cINVCOde.Substring(0, 9);
double valrate = ValRate(NewCodeVal);
double Newharga = tbl.ihargabelirp;
int iThnB = Convert.ToInt16(thnA);
param = new DynamicParameters();
param.Add("@tglmr", newDate);
param.Add("@item", NewCode);
param.Add("@tipe", tbl.cInvTypeKode);
param.Add("@rate", valrate);
param.Add("@qty", tbl.iQty);
param.Add("@price", Newharga);
for (int i = 0; i < tbl.iQty; i++)
{
sqlcmd = "INSERT INTO tAsset(dMMRDate, cInvCode, cInvGroup, iRate, iQty, iHargaperPcs)" +
" VALUES(@tglmr, @item, @tipe, @rate, 1, @price) ";
rst = _db.Execute(sqlcmd, param);
}
return(rst);
}
catch (Exception)
{
throw;
}
}
public int insManualAsset(MMRFixedAsset tbl)
{
WipRepository FixedAsset = new WipRepository();
return(FixedAsset.insManualAsset(tbl));
}
public int updAssetArea(MMRFixedAsset tbl)
{
WipRepository FixedAsset = new WipRepository();
return(FixedAsset.updAssetArea(tbl));
}
public int delAsset(MMRFixedAsset tbl)
{
WipRepository FixedAsset = new WipRepository();
return(FixedAsset.delAsset(tbl));
}
