public bool RefreshTransactions()
{
try
{
DataModelEntities context = new DataModelEntities();
List<User> users = context.Users
.Where(u =>
u.Is_Active == true &&
u.Is_Locked != true &&
u.Is_Verified == true &&
u.Is_Paypal_Paid == true //&&
// (u.Is_Paypal_Expired == null || u.Is_Paypal_Expired != true)
).ToList();
ParcelBL parcelBL = new ParcelBL();
foreach (PriceManagerDAL.User user in users)
{
int UserCode = user.User_Code;
ParcelBL objParcelBL = new ParcelBL();
/*Save Ebay's All Account's items to seller item table in order to automate pricing*/
objParcelBL.SaveEbayUserItems(UserCode);
}
return true;
}
catch (Exception ex)
{
return false;
}
}
protected void DownloadCategories(object sender, EventArgs e)
{
DataModelEntities context = new DataModelEntities();
ParcelBL parcelBL = new ParcelBL();
List<CategoryType> catogories = parcelBL.GetEbayCategories(26);
foreach (CategoryType item in catogories)
{
ProductCategory objProductCategory = new ProductCategory();
objProductCategory.CategoryId = Convert.ToInt32(item.CategoryID);
objProductCategory.CategoryName = item.CategoryName;
objProductCategory.ParentId = item.CategoryParentID.Length > 0 ? Convert.ToInt32(item.CategoryParentID[0]) : 0;
objProductCategory.CategoryLevel = item.CategoryLevel;
context.AddToProductCategories(objProductCategory);
}
context.SaveChanges();
}
public string GetPricingItems(int? itemCode, int? userAccountCode, string categoryID, string searchColumn, string searchValue, bool? reload, int? country)
{
int userKey = new Base().UserKey;
if (userKey == 0)
{
return "{\"login\": false}";
}
if (reload == true)
{
ParcelBL objParcelBL = new ParcelBL();
objParcelBL.SaveEbayUserItems(userKey);
}
//string[] searchitems = null;
//if (searchValue.Contains(""))
//{
// searchitems = searchValue.Split(' ');
//}
DataModelEntities context = new DataModelEntities();
var user = context.Users.FirstOrDefault(f => f.User_Code == userKey);
DateTime currentDate = DateTime.Today.Date;
var items = context.SellerItems.Where(c => c.Is_Active == true
&& c.User_Code == userKey
&& (
(
itemCode == null
// && (country == null || c.Country_Code == country)
&& (userAccountCode == null || userAccountCode == 0 || c.User_Account_Code == userAccountCode)
&& (string.IsNullOrEmpty(categoryID) || categoryID == "0" || c.Item_Category_ID == categoryID)
&& (searchColumn != "Item_Name" || string.IsNullOrEmpty(searchValue) || c.Item_Name.Contains(searchValue))
&& (searchColumn != "Item_ID" || string.IsNullOrEmpty(searchValue) || c.Item_ID.Contains(searchValue))
//// && (searchColumn == "Item_Name" && (string.IsNullOrEmpty(searchValue) == false || c.Item_Name.Any(p => searchitems.Any())) )
//&& (searchColumn == "Item_ID" && (string.IsNullOrEmpty(searchValue) == false || c.Item_Name.Any(p => searchitems.Any())) )
&& (EntityFunctions.TruncateTime(c.End_Date) > currentDate)
)
|| (c.Item_Code == itemCode)
)
).AsEnumerable()
.Select(a => new SellerItemModel()
{
Item_View_URL = a.Item_View_URL,
Picture_URL = a.Picture_URL,
Is_Promo_Item = a.Is_Promo_Item,
Algo = a.Algo,
BIN_Price = a.BIN_Price,
Ceiling_Price = a.Ceiling_Price,
Current_Price = a.Current_Price,
End_Date = a.End_Date,
Floor_Price = a.Floor_Price,
Item_Code = a.Item_Code,
Item_ID = a.Item_ID,
Item_Name = a.Item_Name,
Item_SKU = a.Item_SKU,
Start_Date = a.Start_Date,
Keywords = a.Keywords,
Is_Automated = a.Is_Automated,
User_Code = a.User_Code,
Algo_Name = Common.GetAlgoName(a.Algo),
Minimum_Feedback = a.Minimum_Feedback,
Maximum_Feedback = a.Maximum_Feedback,
Minimum_Price = a.Minimum_Price,
Maximum_Price = a.Maximum_Price,
Minimum_Quantity = a.Minimum_Quantity,
Maximum_Quantity = a.Maximum_Quantity,
Inclued_Sellers = a.Inclued_Sellers,
Exclued_Sellers = a.Exclude_Sellers,
Maximum_Handling_Time = a.Maximum_Handling_Time,
Is_Fixed_Price = a.Is_Fixed_Price,
Is_Auctions = a.Is_Auctions,
Is_Returns_Accepted = a.Is_Returns_Accepted,
Is_Location_AU = a.Is_Location_AU,
Is_Hide_Duplicates = a.Is_Hide_Duplicates,
Is_Top_Rated_Only = a.Is_Top_Rated_Only,
Exclude_Category_Codes = a.Exclude_Category_Codes,
Include_Condtion_Codes = a.Include_Condtion_Codes,
Item_Category_ID = a.Item_Category_ID,
Item_Category_Name = a.Item_Category_Name,
Less_To_Lowest_Price = a.Less_To_Lowest_Price,
Item_Rank = a.Item_Rank,
Currency = a.Currency,
Ignore_Words = a.Ignore_Words,
Country_Code = a.Country_Code,
LocatedIn = a.LocatedIn,
Rotate_Order = a.Rotate_Order,
Rotate_Days = a.Rotate_Days,
Rotate_Sales = a.Rotate_Sales,
User_Account_Code = a.User_Account_Code,
QuantityAvailable = a.QuantityAvailable
})
.ToList();
if (itemCode.HasValue)
{
items[0].ItemTitles = context.ItemTitles.Where(a => a.ItemId == itemCode).Select(
b => new ItemTitleModels
{
Title = b.Title,
ItemTitleId = b.ItemTitleId,
TotalSales = b.TotalSales == null ? 0 : (int)b.TotalSales
}
).ToList();
}
if (user.Package_Id == (int)Common.Package.Trial)
return Common.Serialize(items.Take(100));
else if (user.Package_Id == (int)Common.Package.Business)
return Common.Serialize(items.ToList().Take(200));
else
return Common.Serialize(items);
}
protected void btnConfirmAuthorization_Click(object sender, EventArgs e)
{
if (IsValid)
{
string sessionID = hfSessionID.Value;
try
{
// fetch a new token using SessionID
string token = new EbayServiceBL(UserKey).FetchToken(sessionID);
if (string.IsNullOrEmpty(token) == false)
{
// save entry in database.
DataModelEntities context = new DataModelEntities();
// check if user is creating a new account, or updating existing one
UserAccount userAccount = null;
if (hfSelectedEbayAccountID.Value == "0")
{
userAccount = new UserAccount();
userAccount.User_Code = UserKey;
userAccount.Account_Code = (int)Constant.Accounts.Ebay;
userAccount.Application_Name = string.Empty;
userAccount.Config_Value1 = token;
userAccount.Created_Date = DateTime.Now;
userAccount.Is_Active = true;
userAccount.User_IP = Request.UserHostAddress;
context.UserAccounts.AddObject(userAccount);
}
else
{
int userAccountCode = Convert.ToInt32(hfSelectedEbayAccountID.Value);
userAccount = context.UserAccounts.First(u => u.User_Account_Code == userAccountCode);
userAccount.Config_Value1 = token;
userAccount.Modified_Date = DateTime.Now;
userAccount.User_IP = Request.UserHostAddress;
}
context.SaveChanges();
try
{
EbayServiceBL service = new EbayServiceBL((int)userAccount.User_Code);
if (service.UserTokens != null)
{
Dictionary<string, int> localTokens = new Dictionary<string, int>();
foreach (KeyValuePair<int, string> pair in service.UserTokens)
{
string ebayUserName = service.GetUser(pair.Value);
if (pair.Key == userAccount.User_Account_Code)
{
userAccount.Ebay_User_Name = ebayUserName;
context.SaveChanges();
}
}
}
ParcelBL objParcelBL = new ParcelBL();
System.Threading.Thread t = new System.Threading.Thread(() => objParcelBL.SaveEbayUserItems(UserKey));
t.Start();
}
catch (Exception ex)
{
Logging.WriteLog(LogType.Critical, ex.ToString());
}
ScriptManager.RegisterClientScriptBlock(this, GetType(), "1", "window.location.reload()", true);
lblAuthError.Text = string.Empty;
}
else
{
lblAuthError.Text = "Either you have not authorized properly, or the Ebay servers are down for the moment. Please try agian in a while.";
}
}
catch (Exception ex)
{
lblAuthError.Text = "Either you have not authorized properly, or the Ebay servers are down for the moment. Please try agian in a while.";
}
}
}
protected void btnDownloadItems_Click(object sender, EventArgs e)
{
try
{
ParcelBL objParcelBL = new ParcelBL();
objParcelBL.SaveEbayUserItems(UserKey);
BindItemss();
}
catch (Exception ex)
{
}
}
protected void btnRefreshTransactions_Click(object sender, EventArgs e)
{
ParcelBL parcelBL = new ParcelBL();
if (IsValid)
{
aConnectAgain.Visible = false;
lblAPIIssues.Visible = false;
List<ParcelItem> ebayItems = new List<ParcelItem>();
try
{
ebayItems = parcelBL.GetEbayTransactions(UserKey);
}
catch (InvalidEbayCredentialsException ex)
{
lblAPIIssues.Visible = true;
lblAPIIssues.Text = "The Ebay API settings are invalid. Please check back with your developer account or contact Ebay Support";
}
catch (Exception ex)
{
if (ex.Message.Contains("Token has been revoked"))
{
lblAPIIssues.Text = "The connectivity with your Ebay account is removed from your Ebay account.";
aConnectAgain.Visible = true;
}
else
{
lblAPIIssues.Text = "There is some issue connecting to the Ebay server. Please check back in a while.";
}
lblAPIIssues.Visible = true;
}
List<ParcelItem> shopifyItems = parcelBL.GetShopifyTransactions(UserKey);
List<ParcelItem> magentoItems = parcelBL.GetMagentoTransactions(UserKey);
List<ParcelItem> bigcommerceItems = parcelBL.GetBigcommerceTransactions(UserKey);
if (ebayItems == null)
{
ebayItems = new List<ParcelItem>();
lblPendingShipmentCount.Visible = imgEbay.Visible = false;
}
if (shopifyItems == null)
shopifyItems = new List<ParcelItem>();
if (magentoItems == null)
magentoItems = new List<ParcelItem>();
if (bigcommerceItems == null)
bigcommerceItems = new List<ParcelItem>();
List<ParcelItem> allItems = ebayItems.Union(shopifyItems.OrderBy(i => i.BuyerID)).Union(magentoItems.OrderBy(i => i.BuyerID)).Union(bigcommerceItems.OrderBy(i => i.BuyerID)).ToList();
new ParcelBL().SaveTransactions(allItems, UserKey);
ShowPendingTransactions();
}
}
protected void btnUpdateSettings_Click(object sender, EventArgs e)
{
try
{
DataModelEntities context = new DataModelEntities();
var user = context.Users.FirstOrDefault(w => w.User_Code == UserKey);
if (user != null)
{
user.Floor_Limit_Alert = chkFloorLimitNotification.Checked;
user.Automation_Time_Delay = int.Parse(ddlTimeDelay.SelectedValue);
user.Automation_Include_Shipping = chkIncludeShipping.Checked;
user.Search_Only_Top_Items = int.Parse(ddlSeachOnlyTop.SelectedValue);
int countryCode = int.Parse(ddlCountrySettings.SelectedValue);
if (countryCode != user.Country_Code)
{
user.Country_Code = int.Parse(ddlCountrySettings.SelectedValue);
hfCountryCode.Value = ddlCountrySettings.SelectedValue;//int.Parse(ddlCountrySettings.SelectedValue);
ParcelBL objParcelBL = new ParcelBL();
objParcelBL.SaveEbayUserItems(UserKey);
//ddlCountrySearch.SelectedValue = hfCountryCode.Value;
}
context.SaveChanges();
}
}
catch (Exception ex)
{
}
}
protected void btnSaveProfile_Click(object sender, EventArgs e)
{
if (IsValid)
{
int userCode = int.Parse(ddlUserList.SelectedValue);
DataModelEntities enities = new DataModelEntities();
User user = enities.Users.SingleOrDefault(u => u.User_Code == userCode);
if (user != null)
{
string fileName = UploadLogo(user.User_Code.ToString());
user.Full_Name = f_name.Value + " " + l_name.Value;
user.First_Name = f_name.Value;
user.Last_Name = l_name.Value;
user.Company = company.Value;
user.Address1 = txtAddress1.Value;
user.Address2 = txtAddress2.Value;
user.City = txtSuburb.Value;
user.State = txtState.Value;
user.Zip = txtPostcode.Value;
user.Phone_Number = txtPhone.Value;
//user.Email_Address = txtEmail.Value;
//user.Role_Code = 2; // user;
user.User_IP = Request.UserHostAddress;
user.ABN_Number = txtABNNumber.Value;
user.Charge_Code_Standard = ddlStandardCode.SelectedValue;
user.Charge_Code_Express = ddlExpressCode.SelectedValue;
user.Charge_Code_ExpressInt = ddlExpressIntCode.SelectedValue;
user.Charge_Code_StandardInt = ddlStandardIntCode.SelectedValue;
user.Charge_Code_AirMailInt = ddlAirMailIntCode.SelectedValue;
user.Charge_Code_AusPostRegInt = ddlAusPostRegIntCode.SelectedValue;
user.Flat_Rate_Client = chkFlatRate.Checked;
int countryCode = int.Parse(ddlCountry.SelectedValue);
user.Currency_Code = int.Parse(ddlCurrency.SelectedValue);
user.LocatedIn = enities.Countries.FirstOrDefault(f => f.Country_Code == countryCode).Country_Abbr;
if (countryCode != user.Country_Code)
{
user.Country = countryCode.ToString();
user.Country_Code = countryCode;
ParcelBL objParcelBL = new ParcelBL();
objParcelBL.SaveEbayUserItems(UserKey);
}
if (!string.IsNullOrEmpty(fileName))
{
user.Company_Logo = fileName;
imgLogo.ImageUrl = fileName;
}
/*Added by javed*/
user.Minimum_Threshold_Alert = chkMinimumThresholdNotification.Checked;
user.Floor_Limit_Alert = chkFloorLimitNotification.Checked;
user.Automation_Time_Delay = int.Parse(ddlTimeDelay.SelectedValue);
user.Automation_Include_Shipping = chkIncludeShipping.Checked;
user.Search_Only_Top_Items = int.Parse(ddlSeachOnlyTop.SelectedValue);
/*Added by javed*/
// Added by saad
user.Automate_Title_Display = int.Parse(ddlTitleDisplayed.SelectedValue);
user.Notify_Title_Locked = chkNotifyTitleLocked.Checked;
enities.SaveChanges();
lblMsg.CssClass = "profileMessage";
lblMsg.Visible = true;
lblMsg.Text = "Profile Updated!";
enities = null;
}
}
}
