public int Update(int VendorOrderPromotionId, int Order_PromotionId, string OrderValue, string PromotionValue, int IsPercent, string Description, string StartDate, string EndDate, string Discontinued)
{
OrderValue = StringHandleClass.RemoveExtraTextWithoutPointOrComma(OrderValue);
PromotionValue = StringHandleClass.RemoveExtraTextWithoutPointOrComma(PromotionValue);
SqlCommand cmd = new SqlCommand("[Purchasing].[Vendor_OrderPromotions_Update]", con)
{
CommandType = CommandType.StoredProcedure, CommandTimeout = Settings.CommandTimeout
};
cmd.Parameters.AddWithValue("@VendorOrderPromotionId", VendorOrderPromotionId);
cmd.Parameters.AddWithValue("@Order_PromotionId", Order_PromotionId);
cmd.Parameters.AddWithValue("@OrderValue", OrderValue);
cmd.Parameters.AddWithValue("@PromotionValue", PromotionValue);
cmd.Parameters.AddWithValue("@IsPercent", IsPercent);
cmd.Parameters.AddWithValue("@Description", Description);
cmd.Parameters.AddWithValue("@StartDate", StartDate);
cmd.Parameters.AddWithValue("@EndDate", EndDate);
cmd.Parameters.AddWithValue("@Discontinued", Discontinued);
cmd.Parameters.Add(new SqlParameter("@o_return", SqlDbType.Int)
{
Direction = ParameterDirection.Output
});
con.Open();
int i = cmd.ExecuteNonQuery();
int retunvalue = (int)cmd.Parameters["@o_return"].Value;
con.Close();
return(retunvalue);
}
public int Insert(int VendorId, int DiscountQty, string DiscountRate, int IsPercent, string Description, string StartDate, string EndDate)
{
DiscountRate = StringHandleClass.RemoveExtraTextWithoutPointOrComma(DiscountRate);
SqlCommand cmd = new SqlCommand("[Purchasing].[Vendor_ProductDiscounts_Insert]", con)
{
CommandType = CommandType.StoredProcedure, CommandTimeout = Settings.CommandTimeout
};
cmd.Parameters.AddWithValue("@VendorId", VendorId);
cmd.Parameters.AddWithValue("@DiscountQty", DiscountQty);
cmd.Parameters.AddWithValue("@DiscountRate", DiscountRate);
cmd.Parameters.AddWithValue("@IsPercent", IsPercent);
cmd.Parameters.AddWithValue("@Description", Description);
cmd.Parameters.AddWithValue("@StartDate", StartDate);
cmd.Parameters.AddWithValue("@EndDate", EndDate);
cmd.Parameters.Add(new SqlParameter("@o_return", SqlDbType.Int)
{
Direction = ParameterDirection.Output
});
con.Open();
int i = cmd.ExecuteNonQuery();
int retunvalue = (int)cmd.Parameters["@o_return"].Value;
con.Close();
return(retunvalue);
}
public string checkFileName(string filename)
{
filename = StringHandleClass.convertName2Link(filename);
Regex regex = new Regex("[^[0-9]+$");
if (regex.IsMatch(filename))
{
filename = Regex.Match(filename, @"\d+").Groups[0].ToString();
}
int newfile = int.Parse(filename);
int filelength = filename.Length;
switch (filelength)
{
case 1:
filename = "0000" + filename;
break;
case 2:
filename = "000" + filename;
break;
case 3:
filename = "00" + filename;
break;
case 4:
filename = "0" + filename;
break;
default:
filename = "0" + filename;
break;
}
return(filename);
}
public int Update(int Product_Id, string CultureCode, string Product_Code, string Category_Code, int Manufacturer_Id, int VendorId,
int Product_TypeId, string Product_Name, string CurrencyCode, string NetPrice, string GrossPrice, int TaxRateId,
int DiscountId, int UnitsInStock, int UnitsInAPackage, int UnitsInBox, string Unit,
decimal Weight, string UnitOfWeightMeasure, decimal Length, decimal Width, decimal Height,
string UnitOfDimensionMeasure, int MinPurchaseQty, int MaxPurchaseQty, string Availability,
string StartDate, string EndDate, string PhotoFileName, string ThumbnailPhotoFileName, string Url,
string ShortDescription, string Specification, int OnlineTransactionFlag, int Discontinued)
{
string Alias = ModuleClass.convertTitle2Link(Product_Name);
NetPrice = StringHandleClass.RemoveExtraTextWithoutPointOrComma(NetPrice);
GrossPrice = StringHandleClass.RemoveExtraTextWithoutPointOrComma(GrossPrice);
SqlCommand cmd = new SqlCommand("[Production].[Products_Update]", con)
{
CommandType = CommandType.StoredProcedure, CommandTimeout = Settings.CommandTimeout
};
cmd.Parameters.AddWithValue("@Product_Id", Product_Id);
cmd.Parameters.AddWithValue("@CultureCode", CultureCode);
cmd.Parameters.AddWithValue("@Product_Code", Product_Code);
cmd.Parameters.AddWithValue("@Category_Code", Category_Code);
cmd.Parameters.AddWithValue("@Manufacturer_Id", Manufacturer_Id);
cmd.Parameters.AddWithValue("@Vendor_Id", VendorId);
cmd.Parameters.AddWithValue("@Product_TypeId", Product_TypeId);
cmd.Parameters.AddWithValue("@Product_Name", Product_Name);
cmd.Parameters.AddWithValue("@Alias", Alias);
cmd.Parameters.AddWithValue("@CurrencyCode", CurrencyCode);
cmd.Parameters.AddWithValue("@NetPrice", NetPrice);
cmd.Parameters.AddWithValue("@GrossPrice", GrossPrice);
cmd.Parameters.AddWithValue("@TaxRateId", TaxRateId);
cmd.Parameters.AddWithValue("@Discount_Id", DiscountId);
cmd.Parameters.AddWithValue("@UnitsInStock", UnitsInStock);
cmd.Parameters.AddWithValue("@UnitsInAPackage", UnitsInAPackage);
cmd.Parameters.AddWithValue("@UnitsInBox", UnitsInBox);
cmd.Parameters.AddWithValue("@Unit", Unit);
cmd.Parameters.AddWithValue("@Weight", Weight);
cmd.Parameters.AddWithValue("@UnitOfWeightMeasure", UnitOfWeightMeasure);
cmd.Parameters.AddWithValue("@Length", Length);
cmd.Parameters.AddWithValue("@Width", Width);
cmd.Parameters.AddWithValue("@Height", Height);
cmd.Parameters.AddWithValue("@UnitOfDimensionMeasure", UnitOfDimensionMeasure);
cmd.Parameters.AddWithValue("@MinPurchaseQty", MinPurchaseQty);
cmd.Parameters.AddWithValue("@MaxPurchaseQty", MaxPurchaseQty);
cmd.Parameters.AddWithValue("@Availability", Availability);
cmd.Parameters.AddWithValue("@StartDate", StartDate);
cmd.Parameters.AddWithValue("@EndDate", EndDate);
cmd.Parameters.AddWithValue("@PhotoFileName", PhotoFileName);
cmd.Parameters.AddWithValue("@ThumbnailPhotoFileName", ThumbnailPhotoFileName);
cmd.Parameters.AddWithValue("@Url", Url);
cmd.Parameters.AddWithValue("@ShortDescription", ShortDescription);
cmd.Parameters.AddWithValue("@Specification", Specification);
cmd.Parameters.AddWithValue("@OnlineTransactionFlag", OnlineTransactionFlag);
cmd.Parameters.AddWithValue("@Discontinued", Discontinued);
cmd.Parameters.Add("@o_return", SqlDbType.Int, 2).Direction = ParameterDirection.Output;
con.Open();
int i = cmd.ExecuteNonQuery();
int retunvalue = (int)cmd.Parameters["@o_return"].Value;
con.Close();
return(retunvalue);
}
protected void btnOkay_Click(object sender, EventArgs e)
{
int[] result = new int[2];
int i = 0;
Page.Validate("ValidationCheck");
if (Page.IsValid)
{
System.Threading.Thread.Sleep(2000);
if (_mode == UIMode.mode.add)
{
result = AddData();
i = result[0];
if (i == -1)
{
lblErrorMsg.Text = "Thông tin không đầy đủ";
ClientScript.RegisterStartupScript(this.GetType(), "onload", "onError();", true);
MultiView1.ActiveViewIndex = 0;
}
else if (i == -2)
{
lblErrorMsg.Text = "Tiến trình xử lý bị lỗi";
ClientScript.RegisterStartupScript(this.GetType(), "onload", "onError();", true);
MultiView1.ActiveViewIndex = 1;
}
else if (i == -3)
{
lblErrorMsg.Text = "Dữ liệu đã tồn tại";
ClientScript.RegisterStartupScript(this.GetType(), "onload", "onError();", true);
MultiView1.ActiveViewIndex = 1;
}
else if (i == 1)
{
lblResult.Text = "Cập nhật thành công";
string forward_url = string.Empty;
if (ddlRouter.SelectedItem.Text != "Mặc định")
{
if (ddlPathFile.SelectedIndex > 0 && ddlListInContent.SelectedIndex > 0)
{
if (ddlPortalList.SelectedValue != string.Empty)
{
forward_url += "portalId=" + ddlPortalList.SelectedValue;
}
if (ddlListInContent.SelectedValue != string.Empty)
{
forward_url += "&selectedTabId=" + ddlListInContent.SelectedValue;
}
if (result[1].ToString() != string.Empty)
{
forward_url += "&createdTabId=" + result[1].ToString();
}
if (ddlPathFile.SelectedValue != string.Empty)
{
forward_url += "&createdTabPath=" + ddlPathFile.SelectedValue;
}
if (ddlContentItem.SelectedItem.Text != string.Empty)
{
forward_url += "&contentItemKey=" + ddlContentItem.SelectedItem.Text + "&keyWords=" + StringHandleClass.convertTitle2Link(ddlContentItem.SelectedItem.Text);
}
if (ddlCultureCode.SelectedValue != string.Empty)
{
forward_url += "&lang=" + ddlCultureCode.SelectedValue;
}
if (ddlRouter.SelectedValue != string.Empty)
{
forward_url += "&router=" + ddlRouter.SelectedValue;
}
Response.Redirect("~/modules/admin/tabs/admin_front_tab_control.aspx?" + forward_url);
}
}
else
{
TabController tab_obj = new TabController();
RouteController route_obj = new RouteController();
var data_route = route_obj.GetDetails(int.Parse(ddlRouter.SelectedValue));
string routerUrl = data_route.RouteUrl;
int resultupdate = tab_obj.UpdateLinkFrontPage(result[1].ToString(), routerUrl, data_route.RouteId, Session["UserId"].ToString());
}
MultiView1.ActiveViewIndex = 1;
ClientScript.RegisterStartupScript(this.GetType(), "onload", "onSuccess();", true);
}
else
{
ClientScript.RegisterStartupScript(this.GetType(), "onload", "onError();", true);
MultiView1.ActiveViewIndex = 0;
}
}
}
}
private string LoadTinHiepHoi(string code, string CateName)
{
string strHTML = string.Empty, result = string.Empty, Abstract = string.Empty, Alias = string.Empty, CreateDate = string.Empty, Headline = string.Empty;
int totalItemCount = 5;
Uri requestUri = Context.Request.Url;
string baseUrl = requestUri.Scheme + Uri.SchemeDelimiter + requestUri.Host + (requestUri.IsDefaultPort ? "" : ":" + requestUri.Port);
string main_image_path = "/user_files/images/article_images/front_images/";
string file_path = baseUrl + main_image_path;
List <Article> lst = ArticleController.GetActiveListByFixedNumCode(code, totalItemCount);
DataTable dt = CommonLibrary.Common.Utilities.CollectionsUtil.ConvertTo(lst);
if (dt.Rows.Count > 0)
{
string img = string.Empty;
if (!string.IsNullOrEmpty(dt.Rows[0]["FrontImage"].ToString()))
{
img = file_path + dt.Rows[0]["FrontImage"].ToString();
}
else
{
img = "/images/no_image.jpg";
}
if (!string.IsNullOrEmpty(dt.Rows[0]["DateCreated"].ToString()))
{
DateTime _CreateDate = Convert.ToDateTime(dt.Rows[0]["DateCreated"].ToString());
CreateDate = "(" + _CreateDate.ToString("dd/MM/yyyy") + ")";
}
Alias = dt.Rows[0]["Alias"].ToString();
if (!string.IsNullOrEmpty(dt.Rows[0]["Headline"].ToString()) && dt.Rows[0]["Headline"].ToString().Length > 300)
{
Headline = StringHandleClass.cutSubString(dt.Rows[0]["Headline"].ToString(), 300) + "...";
}
else
{
Headline = dt.Rows[0]["Headline"].ToString();
}
if (!string.IsNullOrEmpty(dt.Rows[0]["Abstract"].ToString()) && dt.Rows[0]["Abstract"].ToString().Length > 300)
{
Abstract = StringHandleClass.cutSubString(dt.Rows[0]["Abstract"].ToString(), 300) + "...";
}
else
{
Abstract = dt.Rows[0]["Abstract"].ToString();
}
result += "<div class=\"first\">"
+ "<h3><a title=\"" + Headline + "\" href=\"/tin-chi-tiet/" + Alias + "/" + code + "\" target='_self'>" + Headline + "</a></h3>"
+ " <a href=\"/tin-chi-tiet/" + Alias + "/" + code + "\" class=\"thumb t-left\" title=\"" + Headline + "\" target='_blank'>"
+ " <img width=\"120\" height=\"120\" title=\"" + Title + "\" alt=\"" + Alias + "\" src=\"" + img + "\">"
+ " </a>"
+ "<div class=\"sapo\">" + Abstract + "</div>"
+ " <span class='date'>Ngày đăng: " + CreateDate + "</span>"
+ "<div style=\"clear:both\"></div>"
+ "</div>"
+ LoadTinLienQuan(dt);
strHTML = "<div class=\"box-widget box-home-item style-1\">"
+ "<div class=\"box-widget-header\">"
+ "<h2><a href=\"/tin-tuc/" + code + "\" target='_blank'>" + CateName + "</a></h2>"
+ "<a class=\"rss\" href=\"/tin-tuc/" + code + "\" target='_blank'></a>"
+ "</div>"
+ "<div class=\"entry-content\">"
+ "<div class=\"entry-content-fx fx\">"
+ "<div class=\"entry-content-fxb\">"
+ "<div class=\"entry-content-fxh\">"
+ result
+ "<div class=\"clear\"></div>"
+ "</div>"
+ "</div>"
+ "</div>"
+ "</div>"
+ "</div>";
}
return(strHTML);
}
