public JsonResult SaveTrackItDetails(string affidavitId, string comments) { AffidavitModel aff = new AffidavitModel(); aff.AffidavitId = Convert.ToInt64(affidavitId); aff.Comments = comments; var result = api.SaveTrackItDetails(aff); return(Json(true, JsonRequestBehavior.AllowGet)); }
public bool SaveTrackItDetails(AffidavitModel aff) { try { return(affidavitLogic.SaveTrackItDetails(aff)); } catch (Exception ex) { Log.Error(ex.Message); return(false); } }
public List <AffidavitModel> GetAllAffidavit(string fromDate, string toDate) { List <AffidavitModel> lstAffidavit = new List <AffidavitModel>(); try { using (SqlConnection con = new SqlConnection(ConnectionHelper.ConnectionString)) { //using (SqlCommand cmd = new SqlCommand("getAffidavitList", con)) using (SqlCommand cmd = new SqlCommand("PROC_GETAFFIDAVIT_SWP", con)) { cmd.Parameters.AddWithValue("@FROMDATE", SqlDbType.NVarChar).Value = fromDate; cmd.Parameters.AddWithValue("@TODATE", SqlDbType.NVarChar).Value = toDate; cmd.CommandType = CommandType.StoredProcedure; con.Open(); SqlDataReader dataReader = cmd.ExecuteReader(); if (dataReader.HasRows) { while (dataReader.Read()) { AffidavitModel affidavit = new AffidavitModel(); affidavit.AffidavitId = String.IsNullOrEmpty(dataReader["AffidavitID"].ToString()) ? 0 : int.Parse(dataReader["AffidavitID"].ToString()); affidavit.PropertyAddress = Convert.ToString(dataReader["PropertyAddress"]); affidavit.OwnerName = Convert.ToString(dataReader["OwnerName"]); affidavit.InspectorName = Convert.ToString(dataReader["InspectorName"]); affidavit.NewOwner = Convert.ToString(dataReader["NewOwner"]); affidavit.PropertyId = Convert.ToString(dataReader["PropertyId"]); affidavit.Status = Convert.ToString(dataReader["Status"]); affidavit.StatusId = String.IsNullOrEmpty(dataReader["StatusId"].ToString()) ? 0 : int.Parse(dataReader["StatusId"].ToString()); affidavit.InspectionDate = Convert.ToString(dataReader["InspectionDate"]); affidavit.IsHighlightOwner = String.IsNullOrEmpty(dataReader["IsHighlightOwner"].ToString()) ? false : Convert.ToBoolean(dataReader["IsHighlightOwner"]); lstAffidavit.Add(affidavit); } } } } } catch (Exception ex) { Log.Error(ex); lstAffidavit = null; } return(lstAffidavit); }
public bool SaveTrackItDetails(AffidavitModel aff) { context = new SWPostEntities(); FormsAndFinalInspections form = new FormsAndFinalInspections(); try { form.AffidavitId = aff.AffidavitId; form.Comments = aff.Comments; form.RequestedDate = DateTime.Now; context.FormsAndFinalInspections.Add(form); context.SaveChanges(); } catch (Exception ex) { throw ex; } return(true); }