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