private void Upload(VideoDetails Video)
{
int SKU = Video.SKU;
string ManPartNum = Video.PartNum;
string Title = Video.WebTitle;
Title = Title.Length > 100 ? Title.Substring(0, 100) : Title;
int len = Title.Length;
string Desc = Video.vidDesc;
string FilePath = $@"C:\Users\Arjun.Prasad\Downloads\Videos\360video\{ManPartNum}\index.files\html5video\{ManPartNum}.m4v";
string tempTags = Video.Keywords;
string[] Tags = String.IsNullOrEmpty(tempTags) ? null : Video.Keywords.Split(',');
UploadVideo UV = new UploadVideo(Title, Desc, Tags, FilePath, SKU);
if (UV.uploadUpdate())
{
if (UV.notUp != null)
{
notUp1.Add(UV.notUp);
}
else
{
MongoUpdate MU = new MongoUpdate(SKU, UV.getvideoID(), ManPartNum);
}
}
else
{
error = true;
}
}
private void setVidDetails(List <string> ManPartNum)
{
string connectionString = ConfigurationManager.AppSettings["SQLConn"];
using (SqlConnection conn = new SqlConnection(connectionString))
{
string temp = "PartNum = '" + ManPartNum[0] + "'";
foreach (var num in ManPartNum)
{
temp += " OR PartNum = '" + num + "'";
}
SqlCommand command = new SqlCommand("SELECT * FROM goods fs " +
"inner join supplier ps on ps.ProductID = fs.ID " +
$"WHERE ps.SupplierID = 111 and fs.Status in (0, 3) and ({temp})", conn);
conn.Open();
var read = command.ExecuteReader();
while (read.Read())
{
VideoDetails VD = new VideoDetails()
{
PartNum = read["Num"].ToString().Trim(),
WebTitle = read["Title"].ToString().Trim(),
SKU = (int)read["ID"],
Keywords = read["Key"].ToString().Trim(),
vidDesc = read["Desc"].ToString().Trim(),
};
VidDetails.Add(VD);
}
}
}
