public Affidavit GetAffidavitDetails_SWP(long affidavitID)
{
Affidavit affidavit = new Affidavit();
try
{
affidavit = context.Affidavit.Include("AffidavitHistory.AffidavitStatus").Include("AffidavitStatus").Include("Inspector").Where(x => x.AffidavitID == affidavitID).FirstOrDefault();
}
//try
//{
// using (SqlConnection con = new SqlConnection(ConnectionHelper.ConnectionString))
// {
// using (SqlCommand cmd = new SqlCommand("sp_getAffidavitDetails_swp", con))
// {
// cmd.Parameters.AddWithValue("@affidavitId", SqlDbType.NVarChar).Value = affidavitID;
// cmd.CommandType = CommandType.StoredProcedure;
// con.Open();
// SqlDataReader dataReader = cmd.ExecuteReader();
// if (dataReader.HasRows)
// {
// while (dataReader.Read())
// {
// affidavit.AffidavitID = String.IsNullOrEmpty(dataReader["AffidavitID"].ToString()) ? 0 : int.Parse(dataReader["AffidavitID"].ToString());
// affidavit.New_Aff = dataReader["New_Aff"].ToString();
// affidavit.QtrSection = dataReader["QtrSection"].ToString();
// affidavit.InspectorName = dataReader["InspectorName"].ToString();
// affidavit.PropertyDescription = dataReader["PropertyDescription"].ToString();
// affidavit.map_id = dataReader["map_id"].ToString();
// affidavit.post_dt = String.IsNullOrEmpty(dataReader["post_dt"].ToString()) ? (DateTime?)null : DateTime.Parse(dataReader["post_dt"].ToString());// DateTime.Parse(dataReader["post_dt"].ToString());
// affidavit.acct_period = String.IsNullOrEmpty(dataReader["acct_period"].ToString()) ? 0 : int.Parse(dataReader["acct_period"].ToString());
// affidavit.property_id = dataReader["property_id"].ToString();
// affidavit.property_id2 = dataReader["property_id2"].ToString();
// affidavit.property_desc = dataReader["property_desc"].ToString();
// affidavit.aff_status = String.IsNullOrEmpty(dataReader["aff_status"].ToString()) ? 0 : int.Parse(dataReader["aff_status"].ToString());
// affidavit.owner_name = dataReader["owner_name"].ToString();
// affidavit.attn1 = dataReader["attn1"].ToString();
// affidavit.attn2 = dataReader["attn2"].ToString();
// affidavit.st_no = dataReader["st_no"].ToString();
// affidavit.district = dataReader["district"].ToString();
// affidavit.st_name = dataReader["st_name"].ToString();
// affidavit.designator = dataReader["designator"].ToString();
// affidavit.city = dataReader["city"].ToString();
// affidavit.zip = dataReader["zip"].ToString();
// //affidavit.inspector_no = String.IsNullOrEmpty(dataReader["inspector_no"].ToString()) ? 0 : int.Parse(dataReader["inspector_no"].ToString());
// affidavit.inspector_name = dataReader["inspector_name"].ToString();
// affidavit.city_owned_flag = dataReader["city_owned_flag"].ToString();
// affidavit.owner_resident_flag = dataReader["owner_resident_flag"].ToString();
// affidavit.service_req_flag = dataReader["service_req_flag"].ToString();
// affidavit.rep_by_city = dataReader["rep_by_city"].ToString();
// affidavit.rep_by_owner = dataReader["rep_by_owner"].ToString();
// affidavit.partial_repair = dataReader["partial_repair"].ToString();
// affidavit.vacant_lot_flag = dataReader["vacant_lot_flag"].ToString();
// affidavit.vacant_desc = dataReader["vacant_desc"].ToString();
// affidavit.repair_dt = String.IsNullOrEmpty(dataReader["repair_dt"].ToString()) ? (DateTime?)null : DateTime.Parse(dataReader["repair_dt"].ToString());// DateTime.Parse(dataReader["repair_dt"].ToString());
// affidavit.billed_dt = String.IsNullOrEmpty(dataReader["billed_dt"].ToString()) ? (DateTime?)null : DateTime.Parse(dataReader["billed_dt"].ToString());// DateTime.Parse(dataReader["billed_dt"].ToString());
// affidavit.bill_flag = dataReader["bill_flag"].ToString();
// affidavit.hold_until_dt = String.IsNullOrEmpty(dataReader["hold_until_dt"].ToString()) ? (DateTime?)null : DateTime.Parse(dataReader["hold_until_dt"].ToString());// DateTime.Parse(dataReader["hold_until_dt"].ToString());
// affidavit.permit_no = String.IsNullOrEmpty(dataReader["permit_no"].ToString()) ? 0 : int.Parse(dataReader["permit_no"].ToString());
// affidavit.permit_issued = dataReader["permit_issued"].ToString();
// affidavit.permit_extended = dataReader["permit_extended"].ToString();
// affidavit.date_issued = String.IsNullOrEmpty(dataReader["date_issued"].ToString()) ? (DateTime?)null : DateTime.Parse(dataReader["date_issued"].ToString());// DateTime.Parse(dataReader["date_issued"].ToString());
// affidavit.date_expired = String.IsNullOrEmpty(dataReader["date_expired"].ToString()) ? (DateTime?)null : DateTime.Parse(dataReader["date_expired"].ToString());// DateTime.Parse(dataReader["date_expired"].ToString());
// affidavit.contractor = dataReader["contractor"].ToString();
// affidavit.builder_board_no = dataReader["builder_board_no"].ToString();
// affidavit.license_no = dataReader["license_no"].ToString();
// affidavit.date_cancelled = String.IsNullOrEmpty(dataReader["date_cancelled"].ToString()) ? (DateTime?)null : DateTime.Parse(dataReader["date_cancelled"].ToString());
// affidavit.cancelled_by = dataReader["cancelled_by"].ToString();
// affidavit.status = dataReader["status"].ToString();
// affidavit.last_action = dataReader["last_action"].ToString();
// affidavit.date_added = String.IsNullOrEmpty(dataReader["date_added"].ToString()) ? (DateTime?)null : DateTime.Parse(dataReader["date_added"].ToString());
// affidavit.date_updated = String.IsNullOrEmpty(dataReader["date_updated"].ToString()) ? (DateTime?)null : DateTime.Parse(dataReader["date_updated"].ToString());
// affidavit.notes = dataReader["notes"].ToString();
// affidavit.NEW_AFF = dataReader["NEW_AFF"].ToString();
// affidavit.NEW_ClearWalk = String.IsNullOrEmpty(dataReader["NEW_ClearWalk"].ToString()) ? false : bool.Parse(dataReader["NEW_ClearWalk"].ToString());
// affidavit.NEW_RepairDueDate = String.IsNullOrEmpty(dataReader["NEW_RepairDueDate"].ToString()) ? (DateTime?)null : DateTime.Parse(dataReader["NEW_RepairDueDate"].ToString());
// affidavit.sent_dt = String.IsNullOrEmpty(dataReader["sent_dt"].ToString()) ? (DateTime?)null : DateTime.Parse(dataReader["sent_dt"].ToString());
// }
// }
// }
// }
//}
catch (Exception ex)
{
Log.Error(ex);
affidavit = new Affidavit();
}
return(affidavit);
}
/// <summary>
/// this method will get list of affidavit
/// </summary>
/// <returns></returns>
//public List<sw_posting> GetAffidavitList()
//{
// List<sw_posting> result = new List<sw_posting>();
public List <Affidavit> GetAffidavitList()
{
List <Affidavit> result = new List <Affidavit>();
try
{
using (SqlConnection con = new SqlConnection(ConnectionHelper.ConnectionString))
{
//using (SqlCommand cmd = new SqlCommand("getAffidavitList", con))
using (SqlCommand cmd = new SqlCommand("sp_getAffidavitList_swp", con))
{
cmd.CommandType = CommandType.StoredProcedure;
con.Open();
SqlDataReader dataReader = cmd.ExecuteReader();
if (dataReader.HasRows)
{
while (dataReader.Read())
{
Affidavit affidavit = new Affidavit();
affidavit.AffidavitID = String.IsNullOrEmpty(dataReader["AffidavitID"].ToString()) ? 0 : int.Parse(dataReader["AffidavitID"].ToString());
affidavit.InspectorId = String.IsNullOrEmpty(dataReader["InspectorId"].ToString()) ? 0 : int.Parse(dataReader["InspectorId"].ToString());
affidavit.InspectionDate = String.IsNullOrEmpty(dataReader["InspectionDate"].ToString()) ? (DateTime?)null : DateTime.Parse(dataReader["InspectionDate"].ToString());
affidavit.Status = String.IsNullOrEmpty(dataReader["Status"].ToString()) ? 0 : int.Parse(dataReader["Status"].ToString());
affidavit.VisioDiagram = dataReader["VisioDiagram"] + "";
affidavit.TrackIT = dataReader["TrackIT"] + "";
affidavit.RNO = dataReader["RNO"] + "";
affidavit.QtrSection = dataReader["QtrSection"] + "";
affidavit.PropertyID = dataReader["PropertyID"] + "";
affidavit.LegalDesc = dataReader["LegalDesc"] + "";
affidavit.Owner1 = dataReader["Owner1"] + "";
affidavit.Owner2 = dataReader["Owner2"] + "";
affidavit.Owner3 = dataReader["Owner3"] + "";
affidavit.OwnerAddress = dataReader["OwnerAddress"] + "";
affidavit.OwnerCity = dataReader["OwnerCity"] + "";
affidavit.OwnerState = dataReader["OwnerState"] + "";
affidavit.OwnerZip = dataReader["OwnerZip"] + "";
affidavit.SiteAddress = dataReader["SiteAddress"] + "";
affidavit.SiteStreetNumber = dataReader["SiteStreetNumber"] + "";
affidavit.SiteDistrict = dataReader["SiteDistrict"] + "";
affidavit.SiteStreetName = dataReader["SiteStreetName"] + "";
affidavit.SiteStreetDesignator = dataReader["SiteStreetDesignator"] + "";
affidavit.SiteCity = dataReader["SiteCity"] + "";
affidavit.SiteZip = dataReader["SiteZip"] + "";
affidavit.CityRepair = dataReader["CityRepair"] + "";
affidavit.OwnerRepair = dataReader["OwnerRepair"] + "";
affidavit.ContractorRepair = dataReader["ContractorRepair"] + "";
affidavit.RepairDueDate = String.IsNullOrEmpty(dataReader["RepairDueDate"].ToString()) ? (DateTime?)null : DateTime.Parse(dataReader["RepairDueDate"].ToString());
affidavit.RepairNoticeSentDate = String.IsNullOrEmpty(dataReader["RepairNoticeSentDate"].ToString()) ? (DateTime?)null : DateTime.Parse(dataReader["RepairNoticeSentDate"].ToString());
affidavit.RepairNoticeSentBy = dataReader["RepairNoticeSentBy"] + "";
affidavit.CityRepairStart = dataReader["CityRepairStart"] + "";
affidavit.CityRepairBy = dataReader["CityRepairBy"] + "";
affidavit.HoldUntilDate = String.IsNullOrEmpty(dataReader["HoldUntilDate"].ToString()) ? (DateTime?)null : DateTime.Parse(dataReader["HoldUntilDate"].ToString());
affidavit.HoldUntilBy = dataReader["HoldUntilBy"] + "";
affidavit.permit_no = String.IsNullOrEmpty(dataReader["permit_no"].ToString()) ? 0 : int.Parse(dataReader["permit_no"].ToString());
affidavit.permit_issued = dataReader["permit_issued"] + "";
affidavit.permit_extended = dataReader["permit_extended"] + "";
affidavit.PermitIssuedDate = String.IsNullOrEmpty(dataReader["PermitIssuedDate"].ToString()) ? (DateTime?)null : DateTime.Parse(dataReader["PermitIssuedDate"].ToString());
affidavit.PermitExpiredDate = String.IsNullOrEmpty(dataReader["PermitExpiredDate"].ToString()) ? (DateTime?)null : DateTime.Parse(dataReader["PermitExpiredDate"].ToString());
affidavit.contractor = dataReader["contractor"] + "";
affidavit.builder_board_no = dataReader["builder_board_no"] + "";
affidavit.date_cancelled = String.IsNullOrEmpty(dataReader["date_cancelled"].ToString()) ? (DateTime?)null : DateTime.Parse(dataReader["date_cancelled"].ToString());
affidavit.cancelled_by = dataReader["cancelled_by"] + "";
affidavit.last_action = dataReader["last_action"] + "";
affidavit.CreateDate = String.IsNullOrEmpty(dataReader["CreateDate"].ToString()) ? (DateTime?)null : DateTime.Parse(dataReader["CreateDate"].ToString());
affidavit.LastModifiedDate = String.IsNullOrEmpty(dataReader["LastModifiedDate"].ToString()) ? (DateTime?)null : DateTime.Parse(dataReader["LastModifiedDate"].ToString());
affidavit.LastModifiedBy = dataReader["LastModifiedBy"] + "";
affidavit.notes = dataReader["notes"] + "";
affidavit.VisioRevision = String.IsNullOrEmpty(dataReader["VisioRevision"].ToString()) ? 0 : int.Parse(dataReader["VisioRevision"].ToString());
affidavit.New_Aff = dataReader["New_Aff"] + "";
affidavit.New_RepairDueDate = String.IsNullOrEmpty(dataReader["New_RepairDueDate"].ToString()) ? (DateTime?)null : DateTime.Parse(dataReader["New_RepairDueDate"].ToString());
affidavit.NEW_ClearWalk = String.IsNullOrEmpty(dataReader["NEW_ClearWalk"].ToString()) ? false : Convert.ToBoolean(dataReader["NEW_ClearWalk"]);
result.Add(affidavit);
}
}
}
}
}
catch (Exception ex)
{
Log.Error(ex);
result = null;
}
return(result);
}
