public String Authentication(string Username, string Password)
{
List <GetCustomerByUsername_Result> objList = new List <GetCustomerByUsername_Result>();
GetCustomerByUsername_Result objCust = new GetCustomerByUsername_Result();
Security objSecurity = new Security();
string Encry_Password;
using (var entities = new SedapExpressEntities())
{
objList = entities.GetCustomerByUsername(Username).ToList <GetCustomerByUsername_Result>();
}
if (objList.Count != 0)
{
foreach (GetCustomerByUsername_Result obj in objList)
{
Encry_Password = objSecurity.CreatePasswordHash(Password, obj.PasswordSalt);
if (Encry_Password != obj.Password)
{
objList = new List <GetCustomerByUsername_Result>();
}
}
}
return(JsonConvert.SerializeObject(objList));
}
public String SearchProductsList()
{
List <SearchProductsList_Result> obj = new List <SearchProductsList_Result>();
using (var entities = new SedapExpressEntities())
{
obj = entities.SearchProductsList().ToList <SearchProductsList_Result>();
}
return(JsonConvert.SerializeObject(obj));
}
public String GetProductDetails_Quantity(int ProductId, int?CustomerId)
{
List <GetProductDetails_Quantity_Result> obj = new List <GetProductDetails_Quantity_Result>();
using (var entities = new SedapExpressEntities())
{
obj = entities.GetProductDetails_Quantity(ProductId, CustomerId).ToList <GetProductDetails_Quantity_Result>();
}
return(JsonConvert.SerializeObject(obj));
}
public String GetProductById_CartUpdate(string ProductIds, int CustomerId)
{
List <GetProductById_CartUpdate_Result> obj = new List <GetProductById_CartUpdate_Result>();
using (var entities = new SedapExpressEntities())
{
obj = entities.GetProductById_CartUpdate(ProductIds, CustomerId).ToList <GetProductById_CartUpdate_Result>();
}
return(JsonConvert.SerializeObject(obj));
}
public String GetAllCategoryProducts(string CategoryId, string PageSize, string PageNumber)
{
List <GetAllCategoryProducts_Result> obj = new List <GetAllCategoryProducts_Result>();
using (var entities = new SedapExpressEntities())
{
obj = entities.GetAllCategoryProducts(Convert.ToInt32(CategoryId), Convert.ToInt32(PageSize), Convert.ToInt32(PageNumber)).ToList <GetAllCategoryProducts_Result>();
}
return(JsonConvert.SerializeObject(obj));
}
public string CartAmountTotal(int?CustomerId)
{
List <CartAmountTotal_Result> obj = new List <CartAmountTotal_Result>();
using (var entities = new SedapExpressEntities())
{
obj = entities.CartAmountTotal(CustomerId).ToList <CartAmountTotal_Result>();
}
return(JsonConvert.SerializeObject(obj));
}
public string UpdateOrderedProductDetails(int OrderId, string Sku, int ItemWeight, int Quantity, int Price, int TotalPrice)
{
int obj;
using (var entities = new SedapExpressEntities())
{
obj = entities.UpdateOrderedProductDetails(OrderId, Sku, ItemWeight, Quantity, Price, TotalPrice);
}
return(JsonConvert.SerializeObject(obj));
}
public string DutyAddUpdate(int CustomerId, string DutyStatus, string DutyON, string DutyOFF)
{
int obj;
using (var entities = new SedapExpressEntities())
{
obj = entities.DutyAddUpdate(CustomerId, DutyStatus, DutyON, DutyOFF);
}
return(JsonConvert.SerializeObject(obj));
}
public string LowPriceProducts(int Count, int?CustomerId)
{
List <LowPriceProducts_Result> obj = new List <LowPriceProducts_Result>();
using (var entities = new SedapExpressEntities())
{
obj = entities.LowPriceProducts(Count, CustomerId).ToList <LowPriceProducts_Result>();
}
return(JsonConvert.SerializeObject(obj));
}
public string DeleteProofAndSignature(int Id)
{
int obj;
using (var entities = new SedapExpressEntities())
{
obj = entities.DeleteProofAndSignature(Id);
}
return(JsonConvert.SerializeObject(obj));
}
public string WishItemUpdate(int?CustomerId, int ProductId, int Type)
{
List <Nullable <int> > obj = new List <Nullable <int> >();
using (var entities = new SedapExpressEntities())
{
obj = entities.WishListItemNumberUpdate(CustomerId, ProductId, Type).ToList <Nullable <int> >();
}
return(JsonConvert.SerializeObject(obj));
}
public string DeliveryOrderStatus()
{
List <DeliveryOrderStatus_Result> obj = new List <DeliveryOrderStatus_Result>();
using (var entities = new SedapExpressEntities())
{
obj = entities.DeliveryOrderStatus().ToList <DeliveryOrderStatus_Result>();
}
return(JsonConvert.SerializeObject(obj));
}
public string GetOfferProduct_CartUpdate(int Count, int?CustomerId)
{
List <GetOfferProduct_CartUpdate_Result> obj = new List <GetOfferProduct_CartUpdate_Result>();
using (var entities = new SedapExpressEntities())
{
obj = entities.GetOfferProduct_CartUpdate(Count, CustomerId).ToList <GetOfferProduct_CartUpdate_Result>();
}
return(JsonConvert.SerializeObject(obj));
}
public string AddDeliveryDetails(int OrderId, string Type, string Image)
{
int obj;
using (var entities = new SedapExpressEntities())
{
obj = entities.AddDeliveryDetails(OrderId, Type, Image);
}
return(JsonConvert.SerializeObject(obj));
}
public string GetOrderSignature(int OrderId, string Type)
{
List <GetOrderSignature_Result> obj = new List <GetOrderSignature_Result>();
using (var entities = new SedapExpressEntities())
{
obj = entities.GetOrderSignature(OrderId, Type).ToList <GetOrderSignature_Result>();
}
return(JsonConvert.SerializeObject(obj));
}
public string SetDeliveryProof(int OrderId, string FileName, string Type)
{
int obj;
using (var entities = new SedapExpressEntities())
{
obj = entities.SetDeliveryProof(OrderId, FileName, Type);
}
return(JsonConvert.SerializeObject(obj));
}
public string AddToCartFromWishlist(int ShoppingCartId)
{
int result;
List <int> obj = new List <int>();
using (var entities = new SedapExpressEntities())
{
result = entities.AddToCartFromWishlist(ShoppingCartId);
}
return(JsonConvert.SerializeObject(result));
}
public string AddToWishlist(int ProductId, int?CustomerId, int Quantity)
{
List <int> obj = new List <int>();
int result;
using (var entities = new SedapExpressEntities())
{
result = entities.AddToWishlist(ProductId, CustomerId, Quantity);
}
return(JsonConvert.SerializeObject(result));
}
public string GetAllWishlistItems(int?CustomerId)
{
List <GetAllWishlistItems_Result> obj = new List <GetAllWishlistItems_Result>();
using (var entities = new SedapExpressEntities())
{
obj = entities.GetAllWishlistItems(CustomerId).ToList <GetAllWishlistItems_Result>();
}
return(JsonConvert.SerializeObject(obj));
}
public string WishlistSynchronization(int LogInCustomerId, int LogOutCustomerId, int shoppingcarttypeId)
{
int result;
List <int> obj = new List <int>();
using (var entities = new SedapExpressEntities())
{
result = entities.WishlistSynchronization(LogInCustomerId, LogOutCustomerId, shoppingcarttypeId);
}
return(JsonConvert.SerializeObject(result));
}
public string OrderlyDetails(int OrderStatusId)
{
List <OrderlyDetails_Result> obj = new List <OrderlyDetails_Result>();
using (var entities = new SedapExpressEntities())
{
obj = entities.OrderlyDetails(OrderStatusId).ToList <OrderlyDetails_Result>();
}
return(JsonConvert.SerializeObject(obj));
}
public string GetCustomerNameByCustomerId(int CustomerId)
{
List <string> obj = new List <string>();
using (var entities = new SedapExpressEntities())
{
obj = entities.GetCustomerNameByCustomerId(CustomerId).ToList <string>();
}
return(JsonConvert.SerializeObject(obj));
}
public string DeleteShippingAddressById(string AddressId)
{
int obj;
using (var entities = new SedapExpressEntities())
{
obj = entities.DeleteShippingAddressById(Convert.ToInt32(AddressId));
}
return(JsonConvert.SerializeObject(obj));
}
public string CustomerInfoUpdate(string CustomerId, string FirstName, string LastName, string StreetAddress, int CountryId, int StateProvinceId, string Phone)
{
int obj;
using (var entities = new SedapExpressEntities())
{
obj = entities.CustomerInfoUpdate(Convert.ToInt32(CustomerId), FirstName, LastName, StreetAddress, CountryId, StateProvinceId, Phone);
}
return(JsonConvert.SerializeObject(obj));
}
public string AddLogOutUser(string IpAddress)
{
List <Nullable <int> > obj = new List <Nullable <int> >();
using (var entities = new SedapExpressEntities())
{
obj = entities.AddLogOutUser(Guid.NewGuid(), IpAddress).ToList <Nullable <int> >();
}
return(JsonConvert.SerializeObject(obj));
}
public string OrderlyStatusUpdate(int OrderId, int OrderStatusId)
{
int obj;
using (var entities = new SedapExpressEntities())
{
obj = entities.UpdateOrderStatus(OrderId, OrderStatusId);
}
return(JsonConvert.SerializeObject(obj));
}
public string CustomerInfo(string CustomerId)
{
List <CustomerInfo_Result> obj = new List <CustomerInfo_Result>();
using (var entities = new SedapExpressEntities())
{
obj = entities.CustomerInfo(Convert.ToInt32(CustomerId)).ToList <CustomerInfo_Result>();
}
return(JsonConvert.SerializeObject(obj));
}
public string GetOrderShippingAddress(int OrderId)
{
List <GetOrderShippingAddress_Result> obj = new List <GetOrderShippingAddress_Result>();
using (var entities = new SedapExpressEntities())
{
obj = entities.GetOrderShippingAddress(OrderId).ToList <GetOrderShippingAddress_Result>();
}
return(JsonConvert.SerializeObject(obj));
}
public string DeleteProductFromWishlist(int?CustomerId, int ProductId)
{
List <int> obj = new List <int>();
int result;
using (var entities = new SedapExpressEntities())
{
result = entities.DeleteProductFromWishlist(CustomerId, ProductId);
}
return(JsonConvert.SerializeObject(result));
}
public string OrderAmountTotal(int OrderId)
{
List <OrderAmountTotal_Result> obj = new List <OrderAmountTotal_Result>();
using (var entities = new SedapExpressEntities())
{
obj = entities.OrderAmountTotal(OrderId).ToList <OrderAmountTotal_Result>();
}
return(JsonConvert.SerializeObject(obj));
}
