private void btnUpdate_Click(object sender, EventArgs e)
{
foreach (ListViewItem item in lstwProducts.SelectedItems)
{
pro = item.Tag as Entity.Products;
}
pro.ProductName = txtProductName.Text;
pro.UnitPrice = nudUnitPrice.Value;
pro.UnitsInStock = int.Parse(nudUnitsInStock.Value.ToString());
pro.id = pro.id;
Entity.Categories seciliCat = cbCategori.SelectedItem as Entity.Categories;
pro.CategoryID = seciliCat.id;
Entity.Suppliers seciliSup = cbSupplier.SelectedItem as Entity.Suppliers;
pro.SupplierID = seciliSup.id;
int result = proDAL.Update(pro);
MessageBox.Show(result.ToString() + " satır etkilendi.");
pro.ListViewDoldur(lstwProducts);
Entity.Entity en = new Entity.Entity();
en.Temizle(groupBox1);
en.Temizle(groupBox2);
}
private void frmSaveProducts_Load(object sender, EventArgs e)
{
Entity.Categories cat = new Entity.Categories();
cat.ComboboxDoldur(cbCategori);
Entity.Suppliers sup = new Entity.Suppliers();
sup.ComboboxDoldur(cbSupplier);
}
private void lstwCategories_SelectedIndexChanged(object sender, EventArgs e)
{
foreach (ListViewItem li in lstwCategories.SelectedItems)
{
Entity.Categories seciliCat = li.Tag as Entity.Categories;
txtCategoryName.Text = seciliCat.CategoryName;
txtDescription.Text = seciliCat.Description;
}
}
private void btnSave_Click(object sender, EventArgs e)
{
Entity.Categories cat = new Entity.Categories();
cat.CategoryName = txtCategoryName.Text;
cat.Description = txtDescription.Text;
int result = catDAL.Save(cat);
MessageBox.Show(result + " satır etkilendi.");
Entity.Entity en = new Entity.Entity();
en.Temizle(groupBox1);
}
private void silToolStripMenuItem_Click(object sender, EventArgs e)
{
DialogResult answer = MessageBox.Show("Silmek istediğinize emin misiniz", "Uyarı", MessageBoxButtons.YesNo, MessageBoxIcon.Stop);
if (answer == DialogResult.Yes)
{
foreach (ListViewItem li in lstwCategories.SelectedItems)
{
cat = li.Tag as Entity.Categories;
}
catDAL.Delete(cat.id);
cat.ListVieweDoldur(lstwCategories);
}
}
private void btnUpdate_Click(object sender, EventArgs e)
{
Entity.Categories cat = new Entity.Categories();
foreach (ListViewItem li in lstwCategories.SelectedItems)
{
cat = li.Tag as Entity.Categories;
}
cat.CategoryName = txtCategoryName.Text;
cat.Description = txtDescription.Text;
catDAL.Update(cat);
cat.ListVieweDoldur(lstwCategories);
Entity.Entity en = new Entity.Entity();
en.Temizle(groupBox1);
}
private void btnSave_Click(object sender, EventArgs e)
{
Entity.Products pro = new Entity.Products();
pro.ProductName = txtProductName.Text;
pro.UnitPrice = nudUnitPrice.Value;
pro.UnitsInStock = int.Parse(nudUnitsInStock.Value.ToString());
Entity.Categories seciliCat = cbCategori.SelectedItem as Entity.Categories;
pro.CategoryID = seciliCat.id;
Entity.Suppliers seciliSup = cbSupplier.SelectedItem as Entity.Suppliers;
pro.SupplierID = seciliSup.id;
DAL.ProductsDal proDAL = new DAL.ProductsDal();
int result = proDAL.Save(pro);
MessageBox.Show(result.ToString() + " satır etkilendi.");
Entity.Entity en = new Entity.Entity();
en.Temizle(groupBox1);
en.Temizle(groupBox2);
}
private void frmListCategories_Load(object sender, EventArgs e)
{
Entity.Categories cat = new Entity.Categories();
cat.ListVieweDoldur(lstwCategories);
}
/// <summary>
/// Thêm danh muc site
/// </summary>
/// <param name="loginId"></param>
/// <param name="loginType"></param>
/// <returns></returns>
public int AddCategory(Entity.Categories p)
{
try
{
using (SqlConnection connection = new SqlConnection(connectString))
{
connection.Open();
using (SqlCommand cmd = new SqlCommand())
{
cmd.CommandTimeout = Constants.TIMOUT_CONNECT_SQL;
cmd.Connection = connection;
cmd.CommandType = CommandType.StoredProcedure;
cmd.CommandText = "sp_AddArticleCategory";
cmd.Parameters.Add("@CategoryName", SqlDbType.NVarChar, 150);
cmd.Parameters["@CategoryName"].Value = p.categoryName;
cmd.Parameters.Add("@Description", SqlDbType.NVarChar, 500);
cmd.Parameters["@Description"].Value = p.description;
cmd.Parameters.Add("@Images", SqlDbType.NVarChar, -1);
cmd.Parameters["@Images"].Value = JsonConvert.SerializeObject(p.images);
cmd.Parameters.Add("@Link", SqlDbType.VarChar, 50);
cmd.Parameters["@Link"].Value = p.link;
cmd.Parameters.Add("@ParentID", SqlDbType.Int);
cmd.Parameters["@ParentID"].Value = p.parentId;
cmd.Parameters.Add("@PublisherID", SqlDbType.Int);
cmd.Parameters["@PublisherID"].Value = p.publisherId;
cmd.Parameters.Add("@Status", SqlDbType.TinyInt);
cmd.Parameters["@Status"].Value = p.status;
cmd.Parameters.Add("@AccountId", SqlDbType.Int);
cmd.Parameters["@AccountId"].Value = p.accountId;
cmd.Parameters.Add("@IsMenu", SqlDbType.TinyInt);
cmd.Parameters["@IsMenu"].Value = p.isMenu;
cmd.Parameters.Add("@DisplayIndex", SqlDbType.SmallInt);
cmd.Parameters["@DisplayIndex"].Value = p.displayIndex;
cmd.Parameters.Add("@CategoryType", SqlDbType.TinyInt);
cmd.Parameters["@CategoryType"].Value = p.categoryType;
cmd.Parameters.Add("@LanguageCode", SqlDbType.VarChar, 50);
cmd.Parameters["@LanguageCode"].Value = p.languageCode;
cmd.Parameters.Add("@Icon", SqlDbType.VarChar, 50);
cmd.Parameters["@Icon"].Value = p.icon;
cmd.Parameters.Add("@CSS", SqlDbType.NVarChar, 2000);
cmd.Parameters["@CSS"].Value = p.css;
cmd.Parameters.Add("@HTML", SqlDbType.NVarChar, 4000);
cmd.Parameters["@HTML"].Value = p.html;
cmd.Parameters.Add("@MetaDescription", SqlDbType.NVarChar, 500);
cmd.Parameters["@MetaDescription"].Value = p.metaDescription;
cmd.Parameters.Add("@MetaKeyword", SqlDbType.NVarChar, 500);
cmd.Parameters["@MetaKeyword"].Value = p.metaKeyword;
cmd.Parameters.Add("@CategoryTags", SqlDbType.NVarChar, 1500);
cmd.Parameters["@CategoryTags"].Value = p.categoryTags;
cmd.Parameters.Add("@ActionTags", SqlDbType.NVarChar, 1500);
cmd.Parameters["@ActionTags"].Value = p.actionTags;
cmd.Parameters.Add("@Code", SqlDbType.Int);
cmd.Parameters["@Code"].Direction = ParameterDirection.Output;
cmd.Parameters.Add("@Msg", SqlDbType.NVarChar, 500);
cmd.Parameters["@Msg"].Direction = ParameterDirection.Output;
cmd.ExecuteNonQuery();
int code = int.Parse(cmd.Parameters["@Code"].Value.ToString());
p.msg = cmd.Parameters["@Msg"].Value.ToString();
return(code);
}
}
}
catch (Exception ex)
{
Lib.Logs.SaveError("Error AddCategory: " + ex, ex);
throw new Exception(ex.Message);
}
}
