public StateTypeVo update(StateTypeVo input, int? stateTypeId= null) { using (var db = new MainDb()) { if (stateTypeId == null) stateTypeId = input.stateTypeId; var res = db.stateTypes.FirstOrDefault(e => e.stateTypeId == stateTypeId); if (res == null) return null; input.created = res.created; // input.createdBy = res.createdBy; db.Entry(res).CurrentValues.SetValues(input); db.SaveChanges(); return res; } }
public StateTypeVo insert(StateTypeVo input) { using (var db = new MainDb()) { db.stateTypes.Add(input); db.SaveChanges(); return input; } }
public BusinessCategoryLookupVo insert(BusinessCategoryLookupVo input) { using (var db = new MainDb()) { db.businessCategoryLookups.Add(input); db.SaveChanges(); return input; } }
public JobTypeVo insert(JobTypeVo input) { using (var db = new MainDb()) { db.jobTypes.Add(input); db.SaveChanges(); return input; } }
public OptionTypeVo insert(OptionTypeVo input) { using (var db = new MainDb()) { db.optionTypes.Add(input); db.SaveChanges(); return input; } }
public BusinessCategoryLookupVo update(BusinessCategoryLookupVo input, Guid? businessCategoryLookupId= null) { using (var db = new MainDb()) { if (businessCategoryLookupId == null) businessCategoryLookupId = input.businessCategoryLookupId; var res = db.businessCategoryLookups.FirstOrDefault(e => e.businessCategoryLookupId == businessCategoryLookupId); if (res == null) return null; input.created = res.created; // input.createdBy = res.createdBy; db.Entry(res).CurrentValues.SetValues(input); db.SaveChanges(); return res; } }
public ImageVo update(ImageVo input, Guid? imageId= null) { using (var db = new MainDb()) { if (imageId == null) imageId = input.imageId; var res = db.images.FirstOrDefault(e => e.imageId == imageId); if (res == null) return null; input.created = res.created; // input.createdBy = res.createdBy; db.Entry(res).CurrentValues.SetValues(input); db.SaveChanges(); return res; } }
public ListingVo update(ListingVo input, Guid? listingId= null) { using (var db = new MainDb()) { if (listingId == null) listingId = input.listingId; var res = db.listings.FirstOrDefault(e => e.listingId == listingId); if (res == null) return null; input.created = res.created; // input.createdBy = res.createdBy; db.Entry(res).CurrentValues.SetValues(input); db.SaveChanges(); return res; } }
public PropertyListingTypeVo update(PropertyListingTypeVo input, int? propertyListingTypeId= null) { using (var db = new MainDb()) { if (propertyListingTypeId == null) propertyListingTypeId = input.propertyListingTypeId; var res = db.propertyListingTypes.FirstOrDefault(e => e.propertyListingTypeId == propertyListingTypeId); if (res == null) return null; input.created = res.created; // input.createdBy = res.createdBy; db.Entry(res).CurrentValues.SetValues(input); db.SaveChanges(); return res; } }
public PropertyListingTypeVo insert(PropertyListingTypeVo input) { using (var db = new MainDb()) { db.propertyListingTypes.Add(input); db.SaveChanges(); return input; } }
public BusinessServiceTypeVo insert(BusinessServiceTypeVo input) { using (var db = new MainDb()) { db.businessServiceTypes.Add(input); db.SaveChanges(); return input; } }
public CountryTypeVo insert(CountryTypeVo input) { using (var db = new MainDb()) { db.countryTypes.Add(input); db.SaveChanges(); return input; } }
public JobCategoryTypeVo update(JobCategoryTypeVo input, int? jobCategoryTypeId= null) { using (var db = new MainDb()) { if (jobCategoryTypeId == null) jobCategoryTypeId = input.jobCategoryTypeId; var res = db.jobCategoryTypes.FirstOrDefault(e => e.jobCategoryTypeId == jobCategoryTypeId); if (res == null) return null; input.created = res.created; // input.createdBy = res.createdBy; db.Entry(res).CurrentValues.SetValues(input); db.SaveChanges(); return res; } }
public MemberRoleLookupVo update(MemberRoleLookupVo input, Guid? memberRoleLookupId= null) { using (var db = new MainDb()) { if (memberRoleLookupId == null) memberRoleLookupId = input.memberRoleLookupId; var res = db.memberRoleLookups.FirstOrDefault(e => e.memberRoleLookupId == memberRoleLookupId); if (res == null) return null; input.created = res.created; // input.createdBy = res.createdBy; db.Entry(res).CurrentValues.SetValues(input); db.SaveChanges(); return res; } }
public ImageVo insert(ImageVo input) { using (var db = new MainDb()) { db.images.Add(input); db.SaveChanges(); return input; } }
public MemberRoleLookupVo insert(MemberRoleLookupVo input) { using (var db = new MainDb()) { db.memberRoleLookups.Add(input); db.SaveChanges(); return input; } }
public CarModelTypeVo insert(CarModelTypeVo input) { using (var db = new MainDb()) { db.carModelTypes.Add(input); db.SaveChanges(); return input; } }
public ListingVo insert(ListingVo input) { using (var db = new MainDb()) { db.listings.Add(input); db.SaveChanges(); return input; } }
public CarVo update(CarVo input, Guid? carId= null) { using (var db = new MainDb()) { if (carId == null) carId = input.carId; var res = db.cars.FirstOrDefault(e => e.carId == carId); if (res == null) return null; input.created = res.created; // input.createdBy = res.createdBy; db.Entry(res).CurrentValues.SetValues(input); db.SaveChanges(); return res; } }