public bool DeleteGroup(Product item)
{
bool result = false;
using (StoredProcedure sp = new StoredProcedure("Products_DeleteGroup"))
{
sp.Params.Add("@GroupID", System.Data.SqlDbType.Int).Value = item.GroupID;
result = sp.ExecuteNonQuery() > 0;
}
return result;
}
public int AddUpdate(Product item)
{
int newID = 0;
using (StoredProcedure sp = new StoredProcedure("Products_AddUpdateItem"))
{
sp.Params.Add("LangCode", System.Data.SqlDbType.NChar).Value = item.LangCode;
sp.Params.Add("Name", System.Data.SqlDbType.NVarChar).Value = item.Name;
sp.Params.Add("GroupID", System.Data.SqlDbType.Int).Value = item.GroupID;
sp.Params.Add("OrderNumber", System.Data.SqlDbType.Int).Value = item.OrderNumber;
sp.Params.Add("CategoryID", System.Data.SqlDbType.Int).Value = item.CategoryID;
sp.Params.Add("Url", System.Data.SqlDbType.NVarChar).Value = Tools.FixUrl(item.Url);
newID = Convert.ToInt32(sp.ExecuteScalar());
item.ID = newID;
}
return newID;
}
private void Save()
{
foreach (RepeaterItem item in RepeaterLang.Items)
{
if (item.ItemType == ListItemType.Item || item.ItemType == ListItemType.AlternatingItem)
{
ProductEditor editor = (ProductEditor)item.FindControl("editor");
editor.CategoryID = Int32.Parse(ddlCategory.SelectedValue);
editor.SaveItem();
}
}
if(fuImage.HasFile)
{
Products ps = new Products();
Product p = new Product();
p.Image = fuImage.FileBytes;
p.ImageName = Path.GetFileName(fuImage.FileName);
p.ImageType = fuImage.PostedFile.ContentType;
p.GroupID = this.GroupID;
if(ps.UpdateImageByGroupID(p))
btnDeleteImage.Visible = true;
}
GridViewItemsList.DataBind();
//add new after saving
//if (Convert.ToInt32(GridViewItemsList.SelectedValue) == 0)
// GroupID = Categories.GetNextCategoryGroupID();
//RepeaterLang.DataBind();
}
public List<Product> GetAllByLanguage(string language)
{
List<Product> all = new List<Product>();
using (StoredProcedure sp = new StoredProcedure("Products_GetAllByLanguage"))
{
sp.Params.Add("@LangCode", SqlDbType.NChar).Value = language;
using (SqlDataReader r = (SqlDataReader)sp.ExecuteReader())
{
if (r != null)
{
while (r.Read())
{
Product item = new Product();
item.ID = Convert.ToInt32(r["ID"]);
item.LangCode = Convert.ToString(r["LangCode"]);
item.Name = Convert.ToString(r["Name"]);
item.GroupID = Convert.ToInt32(r["GroupID"]);
item.OrderNumber = Convert.ToInt32(r["OrderNumber"]);
item.CategoryID = Convert.ToInt32(r["CategoryID"]);
item.Url = Convert.ToString(r["Url"]);
item.ImageLenght = Convert.ToInt32(r["ImageLenght"]);
all.Add(item);
}
}
}
}
return all;
}
public bool UpdateImageByGroupID(Product item)
{
bool result = false;
using (StoredProcedure sp = new StoredProcedure("Products_UpdateImage"))
{
sp.Params.Add("@GroupID", System.Data.SqlDbType.Int).Value = item.GroupID;
sp.Params.Add("@Image", System.Data.SqlDbType.Image).Value = item.Image;
sp.Params.Add("@ImageName", System.Data.SqlDbType.NVarChar).Value = item.ImageName;
sp.Params.Add("@ImageType", System.Data.SqlDbType.NVarChar).Value = item.ImageType;
result = sp.ExecuteNonQuery() > 0;
}
return result;
}
public Product GetProductImageByGroupID(string langCode, int groupId)
{
Product item = null;
using (StoredProcedure sp = new StoredProcedure("Products_GetProductImageByGroupID"))
{
sp.Params.Add("@GroupID", System.Data.SqlDbType.Int).Value = groupId;
sp.Params.Add("@LangCode", System.Data.SqlDbType.NVarChar).Value = langCode;
using (SqlDataReader r = (SqlDataReader)sp.ExecuteReader())
{
DataTable table = new DataTable();
table.Load(r);
if (table.Rows.Count > 0)
{
DataRow row = table.Rows[0];
item = new Product();
item.ID = Convert.ToInt32(row["ID"]);
item.LangCode = Convert.ToString(row["LangCode"]);
item.Name = Convert.ToString(row["Name"]);
item.GroupID = Convert.ToInt32(row["GroupID"]);
item.OrderNumber = Convert.ToInt32(row["OrderNumber"]);
item.CategoryID = Convert.ToInt32(row["CategoryID"]);
item.Url = Convert.ToString(row["Url"]);
item.ImageLenght = Convert.ToInt32(row["ImageLenght"]);
try
{
item.Image = (byte[])row["Image"];
item.ImageName = Convert.ToString(row["ImageName"]);
item.ImageType = Convert.ToString(row["ImageType"]);
}
catch (Exception)
{
}
}
}
}
return item;
}
public Product GetByLangGroup(string language, int groupId)
{
Product item = null;
using (StoredProcedure sp = new StoredProcedure("Products_GetByLangGroup"))
{
sp.Params.Add("@GroupID", System.Data.SqlDbType.Int).Value = groupId;
sp.Params.Add("@LangCode", System.Data.SqlDbType.NChar).Value = language;
using (SqlDataReader r = (SqlDataReader)sp.ExecuteReader())
{
if (r != null && r.Read())
{
item = new Product();
item.ID = Convert.ToInt32(r["ID"]);
item.LangCode = Convert.ToString(r["LangCode"]);
item.Name = Convert.ToString(r["Name"]);
item.GroupID = Convert.ToInt32(r["GroupID"]);
item.OrderNumber = Convert.ToInt32(r["OrderNumber"]);
item.CategoryID = Convert.ToInt32(r["CategoryID"]);
item.Url = Convert.ToString(r["Url"]);
item.ImageLenght = Convert.ToInt32(r["ImageLenght"]);
}
}
}
return item;
}