public int updateJOB(PrevJOB tbl) { try { DynamicParameters param; var rst = 0; string sqlcmd; param = new DynamicParameters(); param.Add("@idDtl", tbl.idDtl); param.Add("@idHdr", tbl.idHdr); param.Add("@desc", tbl.JobDesc); param.Add("@cost", tbl.Cost); sqlcmd = "UPDATE tPMDetail SET JobDesc=@desc, Cost=@cost WHERE idDTL=@idDtl"; rst = _db.Execute(sqlcmd, param); return(rst); } catch (Exception) { throw; } }
public int insJOB(PrevJOB tbl) { try { DynamicParameters param; var rst = 0; string sqlcmd; param = new DynamicParameters(); param.Add("@idHdr", tbl.idHdr); param.Add("@desc", tbl.JobDesc); param.Add("@cost", tbl.Cost); sqlcmd = "INSERT INTO tPMDetail(idHdr, JobDesc, Cost)" + " VALUES(@idHdr, @desc, @cost) "; rst = _db.Execute(sqlcmd, param); return(rst); } catch (Exception) { throw; } }
public int updateJOB(PrevJOB tbl) { WipRepository FixedAsset = new WipRepository(); return(FixedAsset.updateJOB(tbl)); }
public int insJOB(PrevJOB tbl) { WipRepository FixedAsset = new WipRepository(); return(FixedAsset.insJOB(tbl)); }