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)); }