public bool AddFieldStaffComment(CommentRequest infData) { try { var query = string.Format(@"INSERT INTO StaffNote (FieldStaffID,Date,Comments,InfantID) VALUES({0},'{1}','{2}',{3})", infData.Userid, DateTime.Now, infData.Comment, infData.infantId); dbService.ExecuteNonQuery(query); return(true); } catch { return(false); } }
public bool DeleteFieldStaff(int userid) { try { var query = string.Format(@"Update UserDetails Set IsDeleted = 1 where UserId = {0}", userid); dbService.ExecuteNonQuery(query); return(true); } catch { return(false); } }
public InfantDetailsResponse AddInfant(InfantRequest infData) { try { var query = string.Format("update infantDetails set GuardianId = {0} where InfantId={1}", infData.GuardianId, infData.InfantId); dbService.ExecuteNonQuery(query); return(GetInfantDetailsForAdd(infData.InfantId)); } catch { return(null); } }