public bool UpdateWorkHistory(WorkHistory workHistory)
{
string sql = "update WorkHistory set ProjectName= '" + workHistory.ProjectName + "', ContractAmount = " + workHistory.ContractAmount + ", StartDate = '" + workHistory.StartDate + "', " +
"EndDate = '" + workHistory.EndDate + "', DelayStatus = '" + workHistory.DelayStatus + "', SettlementAmount = " + workHistory.SettlementAmount +
" where CompanyId = " + workHistory.CompanyId + " and ProjectId = " + workHistory.ProjectId;
int i = DBHelper.ExecuteNonQuery(sql);
if (i == 1)
{
return(true);
}
else
{
return(false);
}
}
public bool AddWorkHistory(WorkHistory workHistory)
{
string sql = @"declare @mid int
select @mid = max(projectId)+1 from CompanyId where CompanyId = " + workHistory.CompanyId + ";";
sql += " insert into WorkHistory values(" + workHistory.CompanyId + ", @mid, '" + workHistory.ProjectName + "', " + workHistory.ContractAmount + ", " +
" '" + workHistory.StartDate + "', '" + workHistory.EndDate + "', '" + workHistory.DelayStatus + "'," + workHistory.SettlementAmount + ");";
int i = DBHelper.ExecuteNonQuery(sql);
if (i == 1)
{
return(true);
}
else
{
return(false);
}
}
