public string Insert(string url, int uid, string source = "", string taget = "", string name = "", string summary = "")
{
try
{
var link = new AffiliateLink
{
url = url,
code = HashCode(),
source = source,
taget = taget,
name = name,
summary = summary,
created = DateTime.Now,
created_by = uid
};
entities.AffiliateLink.Add(link);
entities.SaveChanges();
return(link.ID.ToString());
}
catch (Exception ex)
{
return(ex.ToString());
}
}
public static void UpdateAffiliateLinks(int retailerId)
{
//Get product id, url
string query = "SELECT id,Url from [nirveek_de].[SS_Product] where AffiliateUrl is null and retailerid=" + retailerId;
SqlConnection myConnection = new SqlConnection(connectionString);
List <Product> products = new List <Product>();
try
{
myConnection.Open();
using (SqlDataAdapter adp = new SqlDataAdapter(query, myConnection))
{
SqlCommand cmd = adp.SelectCommand;
cmd.CommandTimeout = 300000;
System.Data.SqlClient.SqlDataReader dr = cmd.ExecuteReader();
while (dr.Read())
{
Product p = new Product();
p.id = long.Parse(dr["id"].ToString());
p.url = dr["Url"].ToString(); products.Add(p);
//products.Add(p);
}
}
}
finally
{
myConnection.Close();
}
try
{
myConnection.Open();
int i = 0;
Console.WriteLine(products.Count);
foreach (Product p in products)
{
i++;
//Thread.Sleep(500);
p.AffiliateUrl = AffiliateLink.GetAffiliateLink(p.url);
query = "update [nirveek_de].[SS_Product] set AffiliateUrl = N'" + p.AffiliateUrl + "' where Id =" + p.id;
Console.WriteLine(i);
using (SqlDataAdapter adp = new SqlDataAdapter(query, myConnection))
{
SqlCommand cmd = adp.SelectCommand;
cmd.CommandTimeout = 300000;
cmd.ExecuteNonQuery();
}
}
}
finally
{
myConnection.Close();
}
//calculate affiliatelink
//save affilaitelink
}
public ActionResult AddAffiliate(AffiliateLink affiliate)
{
affiliate.Available = true;
ucContext.affiliateLinks.Add(affiliate);
ucContext.SaveChanges();
return(RedirectToAction("Affiliate", "List"));
}
public ActionResult SoftDeleteAffiliate(int id)
{
AffiliateLink deletedAffiliate = context.affiliateLinks.Where(x => x.ID == id).FirstOrDefault();
deletedAffiliate.Available = false;
context.SaveChanges();
return(RedirectToAction("Affiliate", "List"));
}
public ActionResult EditAffiliate(AffiliateLink affiliate)
{
AffiliateLink editedAffiliate = context.affiliateLinks.Where(x => x.ID == affiliate.ID).FirstOrDefault();
editedAffiliate.name = affiliate.name;
editedAffiliate.SiteName = affiliate.SiteName;
editedAffiliate.Description = affiliate.Description;
context.SaveChanges();
return(RedirectToAction("Affiliate", "List"));
}
