public Tuple <long, string> AddNewJobsite(NewJobsiteModel jobsite)
{
CRSF newJobsite = new CRSF()
{
site_name = jobsite.JobsiteName,
customer_auto = jobsite.CustomerId,
site_suburb = jobsite.City,
site_postcode = jobsite.PostCode,
site_state = jobsite.State,
site_country = jobsite.Country,
created_date = DateTime.UtcNow,
CreatedByUserId = jobsite.CreatedByUserId,
FullAddress = jobsite.FullAddress,
DealerId = 4, // TrackTreads
type_auto = jobsite.JobsiteTypeId
};
using (var context = new SharedContext())
{
context.CRSF.Add(newJobsite);
try
{
context.SaveChanges();
}
catch (Exception e)
{
return(Tuple.Create(Convert.ToInt64(-1), "Failed to create jobsite. "));
}
}
return(Tuple.Create(newJobsite.crsf_auto, "Jobsite added successfully. "));
}
public async Task <NewJobsiteModel> GetJobsiteDetails(long jobsiteId)
{
var jobsite = await _context.CRSF.Where(j => j.crsf_auto == jobsiteId).FirstOrDefaultAsync();
if (jobsite == null)
{
return(null);
}
var response = new NewJobsiteModel()
{
JobsiteName = jobsite.site_name,
CustomerId = jobsite.customer_auto,
City = jobsite.site_suburb,
PostCode = jobsite.site_postcode,
State = jobsite.site_state,
Country = jobsite.site_country,
CreatedByUserId = jobsite.CreatedByUserId == null ? 0 : (long)jobsite.CreatedByUserId,
FullAddress = jobsite.FullAddress,
JobsiteTypeId = jobsite.type_auto ?? 0
};
return(response);
}
