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