public string billingOrder(int id)
{
try
{
TblOrder order = orderService.GetByPrimaryKey(id);
if (order != null)
{
order.BillingStatus = "paid";
order.ModifiedDateTime = SDateTime.GetYYYYMMddHmmSSNow();
if (orderService.Update(order))
{
if (SNumber.ToNumber(order.CustomerID) > 0)
{
Customer customer = customerService.GetByPrimaryKey(SNumber.ToNumber(order.CustomerID));
customer.TotalCount += order.TotalCount;
customer.TotalOrder += 1;
customer.ModifiedDateTime = SDateTime.GetYYYYMMddHmmSSNow();
customerService.Update(customer);
}
return("bill1");
}
}
return("bill0");
}
catch (Exception ex)
{
LogService.WriteException(ex);
}
return("bill0");
}
public int Insert(TblCart cart)
{
try
{
if (SNumber.ToNumber(cart.CustomerID) == 0)
{
cart.CustomerID = null;
}
string query = "insert into TblCart (CookieID,CustomerID,CreatedDateTime,TotalPrice)" +
" values (@CookieID,@CustomerID,@CreatedDateTime,@TotalPrice)" +
" SELECT @@IDENTITY";
int productID = connect.Query <int>(query, new
{
cart.CookieID,
cart.CustomerID,
cart.CreatedDateTime,
cart.TotalPrice
}).Single();
return(productID);
}
catch (Exception ex)
{
LogService.WriteException(ex);
return(0);
}
}
public bool Update(TblCart cart)
{
try
{
if (SNumber.ToNumber(cart.CustomerID) == 0)
{
cart.CustomerID = null;
}
string query = "update TblCart set CookieID=@CookieID,CustomerID=@CustomerID,ModifiedDateTime=@ModifiedDateTime,TotalPrice=@TotalPrice" +
" where CartID=@CartID ";
return(0 < connect.Execute(query, new
{
cart.CookieID,
cart.CustomerID,
cart.ModifiedDateTime,
cart.TotalPrice,
cart.CartID
}));
}
catch (Exception ex)
{
LogService.WriteException(ex);
return(false);
}
}
public ActionResult editShippingAddress(DetailOrderModel detailOrderModel)
{
try
{
if (detailOrderModel.ShippingAddress != null && detailOrderModel.ShippingAddressID > 0)
{
detailOrderModel.ShippingAddress.ShippingAddressID = detailOrderModel.ShippingAddressID;
Country country = countryService.GetByPrimaryKey(SNumber.ToNumber(detailOrderModel.ShippingAddress.CountryID));
if (country != null)
{
detailOrderModel.ShippingAddress.CountryName = country.CountryName;
}
if (shippingAddressService.Update(detailOrderModel.ShippingAddress))
{
return(RedirectToAction("detail", "orders", new { id = detailOrderModel.OrderID, strMessage = "editShippingAddress1" }));
}
return(RedirectToAction("detail", "orders", new { id = detailOrderModel.OrderID, strMessage = "editShippingAddress0" }));
}
return(RedirectToAction("index", "orders", new { strMessage = "notExist" }));
}
catch (Exception ex)
{
LogService.WriteException(ex);
return(RedirectToAction("detail", "orders", new { id = detailOrderModel.OrderID, strMessage = "editShippingAddress0" }));
}
}
public ActionResult addShippingAddress(DetailOrderModel detailOrderModel)
{
try
{
if (detailOrderModel.ShippingAddress != null && detailOrderModel.OrderID > 0)
{
Country country = countryService.GetByPrimaryKey(SNumber.ToNumber(detailOrderModel.ShippingAddress.CountryID));
if (country != null)
{
detailOrderModel.ShippingAddress.CountryName = country.CountryName;
}
int shippingAddressID = shippingAddressService.Insert(detailOrderModel.ShippingAddress);
if (shippingAddressID > 0)
{
TblOrder order = orderService.GetByPrimaryKey(detailOrderModel.OrderID);
order.ShippingAddressID = shippingAddressID;
order.ModifiedDateTime = SDateTime.GetYYYYMMddHmmSSNow();
if (orderService.Update(order))
{
return(RedirectToAction("detail", "orders", new { id = detailOrderModel.OrderID, strMessage = "addShippingAddress1" }));
}
}
}
return(RedirectToAction("detail", "orders", new { id = detailOrderModel.OrderID, strMessage = "addShippingAddress0" }));
}
catch (Exception ex)
{
LogService.WriteException(ex);
return(RedirectToAction("detail", "orders", new { id = detailOrderModel.OrderID, strMessage = "addShippingAddress0" }));
}
}
private int UploadImage(Variant variant)
{
if (variant == null || variant.imageVariant == null)
{
return(0);
}
int variantID = variant.VariantID, productID = variant.ProductID;
HttpPostedFileBase file = variant.imageVariant;
if (file.ContentLength / 1024 / 1024 > 1)
{
return(0);
}
else if (file.ContentLength > 0)
{
try
{
string folder = Server.MapPath("~/assets/uploads/products/") + productID;
Directory.CreateDirectory(folder);
string strWhere = "";
strWhere = "ImageName like N'" + file.FileName + "' and ProductID = " + productID.ToString();
TblImage imageOfProduct = imageService.SelectByWhere(strWhere).FirstOrDefault();
if (imageOfProduct == null || imageOfProduct.ImageID <= 0)
{
string path = Path.Combine(folder, Path.GetFileName(file.FileName));
file.SaveAs(path);
string imageUrl = "";
imageUrl = HttpContext.Request.Url.Authority == string.Empty ? Common.UrlHost : "http://" + HttpContext.Request.Url.Authority;
if (!imageUrl.EndsWith("/"))
{
imageUrl += "/";
}
imageUrl += "assets/uploads/products/" + productID + "/" + file.FileName;
TblImage image = new TblImage();
image.ImageName = file.FileName;
image.ImageUrl = imageUrl;
image.ImageSize = file.ContentLength;
image.ProductID = SNumber.ToNumber(productID);
int imageID = imageService.Insert(image);
return(imageID);
}
}
catch (Exception ex)
{
LogService.WriteException(ex);
strErrorMessage += "Upload file thất bại<br/>";
}
}
return(0);
}
/// <summary>
/// count number addressbook of customer not default address
/// </summary>
/// <param name="customerID"></param>
/// <returns></returns>
public int CountByCustomerIDNotDefault(int customerID)
{
try
{
string query = "select count(*) from AddressBook where IsDefault = 0 and CustomerID = " + customerID;
int temp = connect.Query <int>(query).Single();
return(SNumber.ToNumber(temp));
}
catch (Exception ex)
{
LogService.WriteException(ex);
return(0);
}
}
public TblCart GetByPrimaryKey(int cartID)
{
try
{
string query = "select * from TblCart where CartID = " + SNumber.ToNumber(cartID);
TblCart cart = connect.Query <TblCart>(query).FirstOrDefault <TblCart>();
return(cart);
}
catch (Exception ex)
{
LogService.WriteException(ex);
return(null);
}
}
public TblOption GetByPrimaryKey(int optionID)
{
try
{
string query = "select * from TblOption where OptionID = " + SNumber.ToNumber(optionID);
TblOption TblOption = connect.Query <TblOption>(query).FirstOrDefault <TblOption>();
return(TblOption);
}
catch (Exception ex)
{
LogService.WriteException(ex);
return(null);
}
}
public Variant GetByPrimaryKey(int variantID)
{
try
{
string query = "select * from Variant where VariantID = " + SNumber.ToNumber(variantID);
Variant variant = connect.Query <Variant>(query).FirstOrDefault <Variant>();
return(variant);
}
catch (Exception ex)
{
LogService.WriteException(ex);
return(null);
}
}
public Product GetByPrimaryKey(int productID)
{
try
{
string query = "select * from Product where ProductID = " + SNumber.ToNumber(productID);
Product product = connect.Query <Product>(query).FirstOrDefault <Product>();
return(product);
}
catch (Exception ex)
{
LogService.WriteException(ex);
return(null);
}
}
/// <summary>
/// insert a record to table
/// </summary>
/// <param name="collectionProduct"></param>
/// <returns></returns>
public int Insert(CollectionProduct collectionProduct)
{
try
{
string query = "insert into CollectionProduct (ProductID,CollectionID) values (@ProductID,@CollectionID) select @@IDENTITY";
int temp = connect.Query <int>(query, new { collectionProduct.ProductID, collectionProduct.CollectionID }).FirstOrDefault <int>();
return(SNumber.ToNumber(temp));
}
catch (Exception ex)
{
LogService.WriteException(ex);
return(0);
}
}
public Customer GetByPrimaryKey(int customerID)
{
try
{
string query = "select * from Customer where CustomerID = " + SNumber.ToNumber(customerID);
Customer customer = connect.Query <Customer>(query).FirstOrDefault <Customer>();
return(customer);
}
catch (Exception ex)
{
LogService.WriteException(ex);
return(null);
}
}
public TblRule GetByPrimaryKey(int ruleID)
{
try
{
string query = "select * from TblRule where RuleID = " + SNumber.ToNumber(ruleID);
TblRule tblRule = connect.Query <TblRule>(query).FirstOrDefault <TblRule>();
return(tblRule);
}
catch (Exception ex)
{
LogService.WriteException(ex);
return(null);
}
}
public List <Tag> GetByTableNameID(int tableNameID)
{
try
{
string query = "select * from Tag where TableNameID = " + SNumber.ToNumber(tableNameID);
List <Tag> Tags = connect.Query <Tag>(query).ToList <Tag>();
return(Tags);
}
catch (Exception ex)
{
LogService.WriteException(ex);
return(new List <Tag>());
}
}
public Tag GetByPrimaryKey(int tagID)
{
try
{
string query = "select * from Tag where TagID = " + SNumber.ToNumber(tagID);
Tag Tag = connect.Query <Tag>(query).FirstOrDefault <Tag>();
return(Tag);
}
catch (Exception ex)
{
LogService.WriteException(ex);
return(null);
}
}
public int CounByWhere(string where)
{
try
{
IDbConnection connectDB = new SqlConnection(Common.ConnectString);
string query = "select count(*) from TblOrder where " + where;
int temp = connectDB.Query <int>(query).FirstOrDefault <int>();
return(SNumber.ToNumber(temp));
}
catch (Exception ex)
{
LogService.WriteException(ex);
return(0);
}
}
/// <summary>
/// get number order of a customer
/// </summary>
/// <param name="customerID">id of customer</param>
/// <returns>number order</returns>
public static object GetTotalOrderOfCustomer(int customerID)
{
try
{
IDbConnection connect = new SqlConnection(Common.ConnectString);
string query = "select count(*) from TblOrder where CustomerID = " + SNumber.ToNumber(customerID);
int totalOrder = SNumber.ToNumber(connect.Query <int>(query).Single());
return(totalOrder);
}
catch (Exception ex)
{
LogService.WriteException(ex);
return(0);
}
}
public int GetUserId(string userName)
{
IDbConnection connectDB = new SqlConnection(Common.ConnectString);
try
{
string query = "select Id from AppUsers where Username like N'" + userName + "'";
int userID = connectDB.Query <int>(query).FirstOrDefault <int>();
return(SNumber.ToNumber(userID));
}
catch (Exception ex)
{
LogService.WriteException(ex);
return(0);
}
}
public bool DeleteByPrimary(int addressBookID)
{
try
{
if (SNumber.ToNumber(addressBookID) <= 0)
{
return(false);
}
string query = "delete from AddressBook where AddressBookID = " + addressBookID;
return(0 < connect.Execute(query));
}
catch (Exception ex)
{
LogService.WriteException(ex);
return(false);
}
}
public bool DeleteByCartID(int cartID)
{
try
{
if (SNumber.ToNumber(cartID) <= 0)
{
return(false);
}
string query = "delete from TblCartItem where CartID = " + cartID;
return(0 < connect.Execute(query));
}
catch (Exception ex)
{
LogService.WriteException(ex);
return(false);
}
}
public bool DeleteByPrimary(int productID)
{
try
{
if (SNumber.ToNumber(productID) <= 0)
{
return(false);
}
string query = "delete from Product where ProductID = " + productID;
return(0 < connect.Execute(query));
}
catch (Exception ex)
{
LogService.WriteException(ex);
return(false);
}
}
/// <summary>
/// delete by collectionID and productID
/// </summary>
/// <param name="collectionID"></param>
/// <param name="productID"></param>
/// <returns></returns>
public bool DeleteByCollectionIDProductID(int collectionID, int productID)
{
try
{
if (SNumber.ToNumber(collectionID) <= 0)
{
return(false);
}
string query = "delete from CollectionProduct where CollectionID = " + collectionID + " and ProductID = " + productID;
return(0 < connect.Execute(query));
}
catch (Exception ex)
{
LogService.WriteException(ex);
return(false);
}
}
public bool DeleteByVariantID(int variantID)
{
try
{
if (SNumber.ToNumber(variantID) <= 0)
{
return(false);
}
string query = "delete from TblImage where VariantID = " + variantID;
return(0 < connect.Execute(query));
}
catch (Exception ex)
{
LogService.WriteException(ex);
return(false);
}
}
//public static object GetProvinceName(int provinceID)
//{
// IDbConnection sqlConnect = new SqlConnection(Common.ConnectString);
// try
// {
// if (SNumber.ToNumber(provinceID) <= 0)
// {
// return "";
// }
// string query = "select ProvinceName from Province where ProvinceID = " + provinceID;
// return sqlConnect.Query<string>(query).FirstOrDefault<string>();
// }
// catch (Exception ex)
// {
// LogService.WriteException(ex);
// return "";
// }
//}
public Province GetByPrimaryKey(int provinceID)
{
try
{
if (SNumber.ToNumber(provinceID) <= 0)
{
return(null);
}
string query = "select * from Province where ProvinceID = " + provinceID;
Province province = connect.Query <Province>(query).FirstOrDefault();
return(province);
}
catch (Exception ex)
{
LogService.WriteException(ex);
return(null);
}
}
public static object GetProductStyleName(int?productStyleID)
{
try
{
if (SNumber.ToNumber(productStyleID) <= 0)
{
return("");
}
IDbConnection connect = new SqlConnection(Common.ConnectString);
string query = "select ProductStyleName from ProductStyle where ProductStyleID = " + productStyleID.ToString();
return(connect.Query <string>(query).FirstOrDefault <String>());
}
catch (Exception ex)
{
LogService.WriteException(ex);
return("");
}
}
public Country GetByPrimaryKey(int countryID)
{
try
{
if (SNumber.ToNumber(countryID) <= 0)
{
return(null);
}
string query = "select * from Country where CountryID = " + countryID;
Country country = connect.Query <Country>(query).FirstOrDefault();
return(country);
}
catch (Exception ex)
{
LogService.WriteException(ex);
return(null);
}
}
public District GetByPrimaryKey(int districtID)
{
try
{
if (SNumber.ToNumber(districtID) <= 0)
{
return(null);
}
string query = "select * from District where DistrictID = " + districtID;
District district = connect.Query <District>(query).FirstOrDefault();
return(district);
}
catch (Exception ex)
{
LogService.WriteException(ex);
return(null);
}
}
public string GetProvinceName(int provinceID)
{
try
{
if (SNumber.ToNumber(provinceID) <= 0)
{
return("");
}
string query = "select * from Province where ProvinceID = " + provinceID;
Province province = connect.Query <Province>(query).FirstOrDefault();
return(province.ProvinceName);
}
catch (Exception ex)
{
LogService.WriteException(ex);
}
return("");
}
public List <District> GetByProvinceID(int provinceID)
{
try
{
if (SNumber.ToNumber(provinceID) <= 0)
{
return(null);
}
string query = "select * from District where ProvinceID = " + provinceID;
List <District> districts = connect.Query <District>(query).ToList();
return(districts);
}
catch (Exception ex)
{
LogService.WriteException(ex);
return(null);
}
}