public int insSchedule(PrevHdr tbl) { try { DynamicParameters param; var rst = 0; string sqlcmd; param = new DynamicParameters(); param.Add("@idasset", tbl.idtAsset); for (int i = 0; i < tbl.count; i++) { sqlcmd = "INSERT INTO tPMHeader(idtAsset, tglPM, statusPM)" + " VALUES(@idasset, getdate(), 0) "; rst = _db.Execute(sqlcmd, param); } return(rst); } catch (Exception) { throw; } }
public int updateSchedule(PrevHdr tbl) { try { string tglA = tbl.tgl.Substring(0, 2); string blnA = tbl.tgl.Substring(3, 2); string thnA = tbl.tgl.Substring(6, 4); string newTgl = thnA + "/" + blnA + "/" + tglA; string newActual = ""; if (tbl.tglActual != "" && tbl.tglActual != null) { string tglB = tbl.tglActual.Substring(0, 2); string blnB = tbl.tglActual.Substring(3, 2); string thnB = tbl.tglActual.Substring(6, 4); newActual = thnB + "/" + blnB + "/" + tglB; } DynamicParameters param; string sqlcmd; if (tbl.tglActual != "" && tbl.tglActual != null) { sqlcmd = "update tPMHeader set tglPM=@tglpm, tglActualPM=@tglactual, statusPM=@sts where idHdr=@idnya"; } else { sqlcmd = "update tPMHeader set tglPM=@tglpm, tglActualPM=NULL, statusPM=@sts where idHdr=@idnya"; } param = new DynamicParameters(); param.Add("@tglpm", newTgl); param.Add("@tglactual", newActual); param.Add("@idnya", tbl.idHdr); param.Add("@sts", tbl.status); var rst = _db.Execute(sqlcmd, param); return(rst); } catch (Exception) { throw; } }
public int updateSchedule(PrevHdr tbl) { WipRepository FixedAsset = new WipRepository(); return(FixedAsset.updateSchedule(tbl)); }