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