public ReturnData AJAX_Update(int idAddress, int idCustomer, int idCountry, int idProvince, int idCity, int idDistrict, string peopleName, string name, string address, string phone, string postalCode, string additionalInformation, bool active) { try { DataClassesDataContext db = new DataClassesDataContext(); TBAddress data = db.TBAddresses.Where(x => !x.Deflag && x.IDCustomer == idCustomer && x.IDAddress == idAddress).FirstOrDefault(); if (data == null) { return(ReturnData.MessageFailed("Data not found", null)); } data.IDCountry = idCountry; data.IDProvince = idProvince; data.IDCity = idCity; data.IDDistrict = idDistrict; data.Name = name; data.Address = address; data.Phone = phone; data.PeopleName = peopleName; data.PostalCode = postalCode; data.AdditionalInformation = additionalInformation; data.Active = active; data.DateLastUpdate = DateTime.Now; db.SubmitChanges(); return(ReturnData.MessageSuccess("Address has been updated successfully", null)); } catch (Exception ex) { Class_Log_Error log = new Class_Log_Error(); log.Insert(ex.Message, ex.StackTrace); return(ReturnData.MessageFailed(ex.Message, null)); } }
public dynamic Dynamic_GetAll_ByIDCustomer(int idCustomer) { try { DataClassesDataContext db = new DataClassesDataContext(); return(db.TBAddresses.Where(x => !x.Deflag && x.IDCustomer == idCustomer && !x.TBCustomer.Deflag).Select(x => new { x.IDCustomer, x.IDAddress, x.Address, x.IDCity, x.IDCountry, x.IDDistrict, x.IDProvince, x.Name, x.Phone, x.PostalCode, x.PeopleName, CityName = x.TBCity.Name, DistrictName = x.TBDistrict.Name, ProvinceName = x.TBProvince.Name, CountryName = x.TBCountry.Name })); } catch (Exception ex) { Class_Log_Error log = new Class_Log_Error(); log.Insert(ex.Message, ex.StackTrace); return(null); } }
public dynamic Dynamic_GetDetail_ByIDPaymentConfirmation(int idPaymentConfirmation) { try { DataClassesDataContext db = new DataClassesDataContext(); return(db.TBPayment_Confirmations.Where(x => x.IDPaymentConfirmation == idPaymentConfirmation).Select(x => new { x.IDPaymentConfirmation, x.Image, x.Name, x.Email, x.Amount, x.Bank, x.Notes, x.PaymentDate, x.PhoneNumber, x.ReferenceNumber, }).FirstOrDefault()); } catch (Exception ex) { Class_Log_Error log = new Class_Log_Error(); log.Insert(ex.Message, ex.StackTrace); return(null); } }