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