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 ReturnData AJAX_BE_Insert(int idRole, string name, string email, string password)
{
try
{
DataClassesDataContext db = new DataClassesDataContext();
if (IsExists(db, email))
{
return(ReturnData.MessageFailed("Email is already registered", null));
}
TBEmployee emp = new TBEmployee();
emp.IDRole = idRole;
emp.Name = name;
emp.Email = email;
emp.Active = true;
emp.Password = EncryptPassword(password);
emp.DateInsert = DateTime.Now;
emp.DateLastUpdate = DateTime.Now;
db.TBEmployees.InsertOnSubmit(emp);
db.SubmitChanges();
return(ReturnData.MessageSuccess("New employee was added", 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_GetAllMenu_ParentNull()
{
try
{
DataClassesDataContext db = new DataClassesDataContext();
return(db.TBMenus.Where(x => x.IDMenuParent == null).Select(x => new
{
x.IDMenu,
x.IDMenuParent,
x.Name,
x.Link,
x.DateInsert,
x.DateLastUpdate,
x.Icon,
AttributeValue = x.Name.Replace(" ", "_").ToLower(),
SubMenu = Dynamic_GetDataBy_IDMenuParent(db, x.IDMenu)
}));
}
catch (Exception ex)
{
Class_Log_Error log = new Class_Log_Error();
log.Insert(ex.Message, ex.StackTrace);
return(null);
}
}
public IEnumerable <dynamic> FE_MultiplePost_SinglePhoto_MultipleCategory(int idPage)
{
try
{
DataClassesDataContext db = new DataClassesDataContext();
var Post = db.TBPageCategory_Posts.Where(x => x.TBPost.IDPage == idPage && !x.TBPost.Deflag).Select(x => new
{
IDPost = x.IDPost,
Photo = x.TBPost.TBPostMedias.FirstOrDefault().MediaUrl,
Title = x.TBPost.Post_Title,
PageTitle = x.TBPost.TBPage.Page_Title,
Description = x.TBPost.Post_Content,
ShortDescription = x.TBPost.Post_ShortContent,
Category = x.TBPageCategory.Name,
Date = x.TBPost.DateInsert,
}).OrderByDescending(x => x.IDPost);
if (Post != null)
{
return(Post);
}
else
{
return(null);
}
}
catch (Exception ex)
{
Class_Log_Error log = new Class_Log_Error();
log.Insert(ex.Message, ex.StackTrace);
return(null);
}
}
public IEnumerable <dynamic> FE_GetAll_PageCategory(int idPage)
{
try
{
DataClassesDataContext db = new DataClassesDataContext();
var PageCategory = db.TBPageCategories.Where(x => x.IDPage == idPage && !x.Deflag).OrderByDescending(x => x.IDPageCategory).AsEnumerable().Select(x => new
{
IDPageCategory = x.IDPageCategory,
IDPage = x.IDPage,
Name = x.Name,
Description = x.Description
});
if (PageCategory != null)
{
return(PageCategory);
}
else
{
return(null);
}
}
catch (Exception ex)
{
Class_Log_Error log = new Class_Log_Error();
log.Insert(ex.Message, ex.StackTrace);
return(null);
}
}
public IEnumerable <dynamic> Dynamic_GetAll(DataClassesDataContext db)
{
try
{
return(db.TBPosts.Where(x => !x.Deflag).AsEnumerable().Select(x => new
{
x.IDPost,
x.IDPage,
x.Post_Title,
x.TBPage.Page_Title,
x.Post_ShortContent,
x.Post_Content,
x.Deflag,
x.Active,
x.DateInsert,
x.DateLastUpdate,
}).ToArray());
}
catch (Exception ex)
{
Class_Log_Error log = new Class_Log_Error();
log.Insert(ex.Message, ex.StackTrace);
return(null);
}
}
public dynamic Dynamic_FE_GetPost_ByIDPageCategory(DataClassesDataContext db, int idPageCategory)
{
try
{
return(db.TBPageCategory_Posts.Where(x => x.IDPageCategory == idPageCategory).AsEnumerable().Select(x => new
{
x.IDPost,
x.TBPost.IDPage,
x.TBPost.Post_Title,
x.TBPost.Post_ShortContent,
x.TBPost.Post_Content,
x.TBPost.Deflag,
x.TBPost.Active,
x.TBPost.DateInsert,
x.TBPost.DateLastUpdate,
Media = x.TBPost.TBPostMedias.Where(y => y.IDPost == x.IDPost).Select(y => y.MediaUrl)
}).FirstOrDefault());
}
catch (Exception ex)
{
Class_Log_Error log = new Class_Log_Error();
log.Insert(ex.Message, ex.StackTrace);
return(null);
}
}
public dynamic Dynamic_GetAll(DataClassesDataContext db)
{
try
{
return(db.TBVouchers.Where(x => !x.Deflag).Select(x => new
{
x.IDVoucher,
x.Name,
x.Code,
x.Description,
x.VoucherType,
x.Value,
x.TotalAvailable,
x.Used,
x.MinimumAmount,
x.StartDate,
x.EndDate,
x.Active
}));
}
catch (Exception ex)
{
Class_Log_Error log = new Class_Log_Error();
log.Insert(ex.Message, ex.StackTrace);
throw;
}
}
public ReturnData AJAX_BE_Login(string email, string password)
{
try
{
using (DataClassesDataContext db = new DataClassesDataContext())
{
var data = db.TBCustomers.Where(x => !x.Deflag && x.Email == email && x.Password == EncryptPassword(password)).FirstOrDefault();
if (data == null)
{
return(ReturnData.MessageFailed("Username/password is incorrect", null));
}
else
{
var token = EncryptToken(email, password);
HttpContext.Current.Response.Cookies.Add(new HttpCookie(System.Configuration.ConfigurationManager.AppSettings["cookieUser"].ToString(), token));
HttpContext.Current.Response.Cookies[System.Configuration.ConfigurationManager.AppSettings["cookieUser"].ToString()].Expires = DateTime.Now.AddMinutes(120);
return(ReturnData.MessageSuccess("OK", token));
}
}
}
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_GetData_ByIDCustomer(int IDCustomer)
{
try
{
DataClassesDataContext db = new DataClassesDataContext();
return(db.TBVouchers.Where(x => !x.Deflag && x.IDCustomer == IDCustomer).Select(x => new
{
x.IDVoucher,
x.Code,
x.Description,
x.EndDate,
x.MinimumAmount,
x.Name,
x.StartDate,
x.Value,
x.VoucherType
}));
}
catch (Exception ex)
{
Class_Log_Error log = new Class_Log_Error();
log.Insert(ex.Message, ex.StackTrace);
return(null);
}
}
public dynamic Dynamic_FE_GetDetail(int idVoucher)
{
try
{
DataClassesDataContext db = new DataClassesDataContext();
dynamic result = db.TBVouchers.Where(x => !x.Deflag && x.IDVoucher == idVoucher).Select(x => new
{
x.IDCustomer,
x.IDVoucher,
x.Name,
x.Code,
x.Description,
x.VoucherType,
Value = Class_Currency.GetPriceConversionCurrency(x.Value),
x.TotalAvailable,
x.Used,
MinimumAmount = Class_Currency.GetPriceConversionCurrency(x.MinimumAmount),
x.StartDate,
x.EndDate,
x.Active
}).FirstOrDefault();
if (result == null)
{
return(ReturnData.MessageFailed("Data not found", null));
}
return(result);
}
catch (Exception ex)
{
Class_Log_Error log = new Class_Log_Error();
log.Insert(ex.Message, ex.StackTrace);
return(null);
}
}
//public Datatable AJAX_GetTable_CustomerAddress(int iDisplayLength, int iDisplayStart, int sEcho, int iSortingCols, int iSortCol, string sSortDir, string search)
//{
// try
// {
// IEnumerable<dynamic> data = Dynamic_GetAll_ByEmail();
// int count = data.Count();
// if (!string.IsNullOrEmpty(search))
// data = data.Where(x =>
// x.FirstName.ToLower().Contains(search.ToLower()) ||
// x.LastName.ToLower().Contains(search.ToLower()) ||
// x.Email.ToLower().Contains(search.ToLower())
// ).ToArray();
// List<Dictionary<string, dynamic>> resultList = new List<Dictionary<string, dynamic>>();
// foreach (dynamic currData in data)
// {
// Dictionary<string, dynamic> newData = new Dictionary<string, dynamic>();
// newData.Add("IDCustomer", currData.IDCustomer);
// newData.Add("Name", currData.FirstName + ' ' + currData.LastName);
// newData.Add("Email", currData.Email);
// newData.Add("Active", currData.Active);
// newData.Add("PhoneNumber", currData.PhoneNumber);
// resultList.Add(newData);
// }
// return OurClass.ParseTable(resultList, count, iDisplayLength, iDisplayStart, sEcho, iSortingCols, iSortCol, sSortDir);
// }
// catch (Exception ex)
// {
// throw;
// }
//}
public ReturnData AJAX_Insert(int idCustomer, int idCountry, int idProvince, int idCity, int idDistrict, string peoplename, string name, string address, string phone, string postalCode, string additionalInformation)
{
try
{
DataClassesDataContext db = new DataClassesDataContext();
TBAddress _newAddress = new TBAddress
{
IDCustomer = idCustomer,
IDCountry = idCountry,
IDProvince = idProvince,
IDCity = idCity,
IDDistrict = idDistrict,
PeopleName = peoplename,
Name = name,
Address = address,
Phone = phone,
PostalCode = postalCode,
AdditionalInformation = additionalInformation,
Active = true,
Deflag = false,
DateInsert = DateTime.Now,
DateLastUpdate = DateTime.Now
};
db.TBAddresses.InsertOnSubmit(_newAddress);
db.SubmitChanges();
return(ReturnData.MessageSuccess("Address submit successfully", _newAddress.IDAddress));
}
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_GetDetail_ByIDAddress_OrderDetail(int idAddress)
{
try
{
DataClassesDataContext db = new DataClassesDataContext();
return(db.TBAddresses.Where(x => x.IDAddress == idAddress && !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,
x.AdditionalInformation,
CityName = x.TBCity.Name,
DistrictName = x.TBDistrict.Name,
ProvinceName = x.TBProvince.Name,
CountryName = x.TBCountry.Name
}).FirstOrDefault());
}
catch (Exception ex)
{
Class_Log_Error log = new Class_Log_Error();
log.Insert(ex.Message, ex.StackTrace);
return(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 ReturnData AJAX_Updates(int idPost, string postTitle, string postShortContent, string postContent)
{
try
{
DataClassesDataContext db = new DataClassesDataContext();
TBPost post = db.TBPosts.Where(x => !x.Deflag && x.IDPost == idPost).FirstOrDefault();
if (post == null)
{
return(ReturnData.MessageFailed("Post not found", null));
}
post.Post_Title = postTitle;
post.Post_ShortContent = postShortContent;
post.Post_Content = postContent;
post.DateLastUpdate = DateTime.Now;
db.SubmitChanges();
return(ReturnData.MessageSuccess("Data 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 ReturnData AJAX_FE_Logout(string token)
{
try
{
using (DataClassesDataContext db = new DataClassesDataContext())
{
if (HttpContext.Current.Request.Cookies[System.Configuration.ConfigurationManager.AppSettings["cookieUser"].ToString()].Value != token)
{
return(ReturnData.MessageFailed("Invalid token!", null));
}
else
{
HttpContext.Current.Response.Cookies[System.Configuration.ConfigurationManager.AppSettings["cookieUser"].ToString()].Expires = DateTime.Now.AddDays(-1);
return(ReturnData.MessageSuccess("OK", 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 ReturnData AJAX_Delete_Photo(int idPostMedia)
{
try
{
using (DataClassesDataContext db = new DataClassesDataContext())
{
TBPostMedia _deleteData = GetDetail_Photo(db, idPostMedia);
if (_deleteData == null)
{
return(ReturnData.MessageFailed("The requested resource does not exist.", null));
}
string _nameBefore = _deleteData.MediaUrl;
db.TBPostMedias.DeleteOnSubmit(_deleteData);
db.SubmitChanges();
OurClass.DeleteFile(_deleteData.MediaUrl, "post");
Dictionary <string, dynamic> _result = new Dictionary <string, dynamic>();
_result.Add("Photos", Dynamic_GetData_Photo_ByIDPost(db, _deleteData.IDPost));
return(ReturnData.MessageSuccess(_nameBefore + " has been successfully deleted.", _result));
}
}
catch (Exception ex)
{
Class_Log_Error log = new Class_Log_Error();
log.Insert(ex.Message, ex.StackTrace);
return(ReturnData.MessageFailed(ex.Message, null));
}
}
public ReturnData AJAX_Delete(int id)
{
try
{
using (DataClassesDataContext db = new DataClassesDataContext())
{
TBLog_Error _deleteData = db.TBLog_Errors.Where(x => x.ID == id).FirstOrDefault();
if (_deleteData == null)
{
return(ReturnData.MessageFailed("The requested resource does not exist.", null));
}
db.TBLog_Errors.DeleteOnSubmit(_deleteData);
db.SubmitChanges();
return(ReturnData.MessageSuccess("Log has been successfully deleted.", 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_GetDetail(DataClassesDataContext db, int idPost)
{
try
{
return(db.TBPosts.Where(x => x.IDPost == idPost).AsEnumerable().Select(x => new
{
x.IDPost,
x.IDPage,
x.Post_Title,
x.Post_ShortContent,
x.Post_Content,
x.Deflag,
x.Active,
x.DateInsert,
x.DateLastUpdate
}).FirstOrDefault());
}
catch (Exception ex)
{
Class_Log_Error log = new Class_Log_Error();
log.Insert(ex.Message, ex.StackTrace);
return(null);
}
}
public ReturnData AJAX_Delete(int idAttribute)
{
try
{
using (DataClassesDataContext db = new DataClassesDataContext())
{
TBAttribute _deleteData = GetDetail(db, idAttribute);
if (_deleteData == null)
{
return(ReturnData.MessageFailed("The requested resource does not exist.", null));
}
string _nameBefore = _deleteData.Name;
_deleteData.Deflag = true;
_deleteData.DateLastUpdate = DateTime.Now;
db.SubmitChanges();
if (_deleteData != null)
{
return(ReturnData.MessageSuccess(_nameBefore + " has been successfully deleted.", null));
}
return(ReturnData.MessageFailed(_nameBefore + " failed to delete.", 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 IEnumerable <dynamic> Dynamic_GetData_Photo_ByIDPost(DataClassesDataContext db, int idPost)
{
try
{
return(Dynamic_Func_GetData_ByIDPost_Photo(db, idPost).AsEnumerable().Select(x => new
{
x.IDPostMedia,
x.IDPost,
x.Title,
x.Description,
Preview = OurClass.ImageExists(x.MediaUrl, "post") ? x.MediaUrl : "noimage.jpg",
x.Active,
x.Deflag,
x.DateInsert,
x.DateLastUpdate
}).ToArray());
}
catch (Exception ex)
{
Class_Log_Error log = new Class_Log_Error();
log.Insert(ex.Message, ex.StackTrace);
return(null);
}
}
public dynamic Dynamic_GetDetail(int idCurrency)
{
try
{
DataClassesDataContext db = new DataClassesDataContext();
return(db.TBCurrencies.Where(x => x.IDCurrency == idCurrency).AsEnumerable().Select(x => new
{
x.IDCurrency,
x.Name,
x.ISOCode,
x.ISOCodeNumeric,
x.Sign,
x.blank,
x.Format,
x.Decimal,
x.ConversionRate,
x.IsDefault,
x.Active,
x.Deflag,
x.DateInsert,
x.DateLastUpdate
}).FirstOrDefault());
}
catch (Exception ex)
{
Class_Log_Error log = new Class_Log_Error();
log.Insert(ex.Message, ex.StackTrace);
return(null);
}
}
public IEnumerable <TBPostMedia> FE_DetailPost_AllPhoto(int idPost)
{
try
{
DataClassesDataContext db = new DataClassesDataContext();
var Post = db.TBPageCategory_Posts.Where(x => x.IDPost == idPost && !x.TBPost.Deflag).OrderByDescending(x => x.IDPost).FirstOrDefault();
var Media = db.TBPostMedias.Where(x => x.IDPost == Post.IDPost).AsEnumerable();
if (Post != null)
{
return(Media);
}
else
{
return(null);
}
}
catch (Exception ex)
{
Class_Log_Error log = new Class_Log_Error();
log.Insert(ex.Message, ex.StackTrace);
return(null);
}
}
public IEnumerable <dynamic> Dynamic_GetAll(DataClassesDataContext db)
{
try
{
return(db.TBCurrencies.Where(x => !x.Deflag).AsEnumerable().Select(x => new
{
x.IDCurrency,
x.Name,
x.ISOCode,
x.ISOCodeNumeric,
x.Sign,
x.blank,
x.Format,
x.Decimal,
x.ConversionRate,
x.IsDefault,
x.Active,
x.Deflag,
x.DateInsert,
x.DateLastUpdate
}).ToArray());
}
catch (Exception ex)
{
Class_Log_Error log = new Class_Log_Error();
log.Insert(ex.Message, ex.StackTrace);
return(null);
}
}
public ReturnData AJAX_GetAll_ByIDRole(int idRole)
{
try
{
DataClassesDataContext db = new DataClassesDataContext();
dynamic data = db.TBRole_OrderStatus.Where(x => x.IDRole == idRole && !x.TBOrder_Status.Deflag).Select(x => new
{
Name = x.TBOrder_Status.Name,
IDOrderStatus = x.TBOrder_Status.IDOrderStatus,
Color = x.TBOrder_Status.Color,
Delivery = x.TBOrder_Status.Delivery,
Logable = x.TBOrder_Status.Logable,
Paid = x.TBOrder_Status.Paid,
SendEmail = x.TBOrder_Status.SendEmail,
Shipped = x.TBOrder_Status.Shipped
});
return(ReturnData.MessageSuccess("OK", data));
}
catch (Exception ex)
{
Class_Log_Error log = new Class_Log_Error();
log.Insert(ex.Message, ex.StackTrace);
return(ReturnData.MessageFailed(ex.Message, null));
}
}
public ReturnData AJAX_BE_Updates(int idCurrency, string name, string isoCode, string isoCodeNumeric, string sign, decimal conversionRate)
{
try
{
DataClassesDataContext db = new DataClassesDataContext();
TBCurrency currency = db.TBCurrencies.Where(x => !x.Deflag && x.IDCurrency == idCurrency).FirstOrDefault();
if (currency == null)
{
return(ReturnData.MessageFailed("Page not found", null));
}
currency.Name = name;
currency.ISOCode = isoCode;
currency.ISOCodeNumeric = isoCodeNumeric;
currency.Sign = sign;
currency.ConversionRate = conversionRate;
currency.DateLastUpdate = DateTime.Now;
db.SubmitChanges();
return(ReturnData.MessageSuccess("Data 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 Init_Admin()
{
try
{
DataClassesDataContext db = new DataClassesDataContext();
if (IsExists(db, "*****@*****.**"))
{
return(ReturnData.MessageFailed("Email is already registered", null));
}
TBEmployee emp = new TBEmployee();
emp.IDRole = 1;
emp.Name = "Admin WIT";
emp.Email = "*****@*****.**";
emp.Active = true;
emp.Password = EncryptPassword("asdasd");
emp.DateInsert = DateTime.Now;
emp.DateLastUpdate = DateTime.Now;
db.TBEmployees.InsertOnSubmit(emp);
db.SubmitChanges();
return(ReturnData.MessageSuccess("New employee was added", 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 ReturnData AJAX_Updates(int idPostMedia, string title, string description)
{
try
{
DataClassesDataContext db = new DataClassesDataContext();
TBPostMedia postMedia = db.TBPostMedias.Where(x => !x.Deflag && x.IDPostMedia == idPostMedia).FirstOrDefault();
if (postMedia == null)
{
return(ReturnData.MessageFailed("Page Media not found", null));
}
postMedia.Title = title;
postMedia.Description = description;
postMedia.DateLastUpdate = DateTime.Now;
db.SubmitChanges();
return(ReturnData.MessageSuccess("Data 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_GetData_AvailableQuantity()
{
try
{
DataClassesDataContext db = new DataClassesDataContext();
return(db.TBProduct_Combinations.Where(x => !x.Deflag && x.Quantity > 0).Select(x => new
{
x.IDProduct_Combination,
ProductName = x.TBProduct.Name,
CombinationName = x.Name,
x.Discount,
x.Price,
x.Quantity,
x.Weight,
x.ReferenceCode,
Active = x.TBProduct.Active
}));
}
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);
}
}
