public List <StudentPersonalCare> GetList(int PersonId) { List <StudentPersonalCare> personalCate = new List <StudentPersonalCare>(); DataTable dt = dbc.GetDataTable("SELECT * FROM vw_StudentPersonalCare WHERE StudentId=" + PersonId); dbc.CloseConnection(); foreach (DataRow dr in dt.Rows) { StudentPersonalCare pc = new StudentPersonalCare(); pc.StudentPersonalCareId = (int)dr["StudentPersonalCareId"]; pc.StudentId = (int)dr["StudentId"]; pc.Item = dr["Item"].ToString(); pc.Assistance = dr["Assistance"].ToString(); pc.Comments = dr["Comments"].ToString(); pc.Frequency = dr["Frequency"].ToString(); personalCate.Add(pc); } return(personalCate); }
public void Update(StudentPersonalCare pc) { CommonFunctions.UpdateApostrophe(pc); StringBuilder sb = new StringBuilder(); sb.Append("UPDATE StudentPersonalCare SET "); sb.Append("Item='" + pc.Item + "'"); sb.Append(",Assistance='" + pc.Assistance + "'"); if (pc.Comments != null && pc.Comments != string.Empty) { sb.Append(",Comments='" + pc.Comments + "'"); } else { sb.Append(",Comments=null"); } sb.Append(",Frequency='" + pc.Frequency + "'"); sb.Append(" WHERE StudentPersonalCareId =" + pc.StudentPersonalCareId); string sql = sb.ToString(); dbc.ExecuteCommand(sql); }
public void Add(StudentPersonalCare pc, int StudentId) { CommonFunctions.UpdateApostrophe(pc); StringBuilder sb = new StringBuilder(); sb.Append("INSERT INTO StudentPersonalCare (StudentId,Frequency,Item,Assistance,Comments) VALUES ("); sb.Append(StudentId); sb.Append(",'" + pc.Frequency + "'"); sb.Append(",'" + pc.Item + "'"); sb.Append(",'" + pc.Assistance + "'"); if (pc.Comments != null && pc.Comments != string.Empty) { sb.Append(",'" + pc.Comments + "'"); } else { sb.Append(",null"); } sb.Append(")"); string sql = sb.ToString(); dbc.ExecuteCommand(sql); }