protected void btnKaydet_Click(object sender, EventArgs e)
{
try
{
ModalDataContext data = new ModalDataContext();
Urun yeniUrun = new Urun();
yeniUrun.UrunAdi = txtUrunAdi.Text;
yeniUrun.Aciklama = txtAciklama.Text;
yeniUrun.BirimFiyat = Convert.ToDecimal(txtFiyat.Text);
yeniUrun.DepoyaGirenMiktar = Convert.ToInt32(txtMiktar.Text);
yeniUrun.KullanilanMiktar = 0;
yeniUrun.BitisSuresi = cldBitisTarihi.SelectedDate;
yeniUrun.Begeniler = 0; yeniUrun.GoruntulenmeSayisi = 0;
yeniUrun.MarkaID = Convert.ToInt32(ddlMarkalar.SelectedValue);
yeniUrun.GrupID = Convert.ToInt32(ddlUrunGrubu.SelectedValue);
yeniUrun.Tarih = DateTime.Now;
data.Uruns.InsertOnSubmit(yeniUrun);
data.SubmitChanges();
List <RenkvsUrun> yeniUrunRenkleri = new List <RenkvsUrun>();
int i = 0, c = blRenkler.Items.Count;
while (i < c)
{
RenkvsUrun yeniUrunRenk = new RenkvsUrun();
yeniUrunRenk.RenkID = Convert.ToInt32(blRenkler.Items[i].Value);
yeniUrunRenk.UrunID = yeniUrun.UrunID;
yeniUrunRenkleri.Add(yeniUrunRenk);
i++;
}
var recUR = (from ur in yeniUrunRenkleri
select ur);
data.RenkvsUruns.InsertAllOnSubmit(yeniUrunRenkleri);
List <BedenvsUrun> yeniUrunBedenleri = new List <BedenvsUrun>();
i = 0; c = blBedenler.Items.Count;
while (i < c)
{
BedenvsUrun yeniUrunBeden = new BedenvsUrun();
yeniUrunBeden.BedenID = Convert.ToInt32(blBedenler.Items[i].Value);
yeniUrunBeden.UrunID = yeniUrun.UrunID;
yeniUrunBedenleri.Add(yeniUrunBeden);
i++;
}
var recUB = (from ub in yeniUrunBedenleri
select ub);
data.BedenvsUruns.InsertAllOnSubmit(recUB);
DataTable dtG = new DataTable();
if (Session["YuklenenGorseller"] == null)
{
dtG = new DataTable();
dtG.Columns.Add("GorselAdres");
}
else
{
dtG = (DataTable)Session["YuklenenGorseller"];
}
List <UrunGorseli> yeniUrunGorselleri = new List <UrunGorseli>();
i = 0; c = dtG.Rows.Count;
while (i < c)
{
UrunGorseli yeniUrunGorseli = new UrunGorseli();
yeniUrunGorseli.GorselAdres = dtG.Rows[i]["GorselAdres"].ToString();
yeniUrunGorseli.UrunID = yeniUrun.UrunID;
yeniUrunGorselleri.Add(yeniUrunGorseli);
i++;
}
var recUG = (from ug in yeniUrunGorselleri
select ug);
data.UrunGorselis.InsertAllOnSubmit(recUG);
data.SubmitChanges();
Session["YuklenenGorseller"] = null;
blBedenler.Items.Clear(); blRenkler.Items.Clear();
txtAciklama.Text = ""; txtFiyat.Text = ""; txtMiktar.Text = ""; txtUrunAdi.Text = "";
}
catch
{
lblError.Text = "Bir hata oluştu";
}
}
protected void btnKaydet_Click(object sender, EventArgs e)
{
try
{
string _id = "";
if (Request.QueryString["UrunID"] != null)
{
_id = Request.QueryString["UrunID"].ToString();
int id = -1;
if (Int32.TryParse(_id, out id))
{
ModalDataContext data = new ModalDataContext();
Urun yeniUrun = data.Uruns.FirstOrDefault(u => u.UrunID == id);
if (yeniUrun != null)
{
yeniUrun.UrunAdi = txtUrunAdi.Text;
yeniUrun.Aciklama = txtAciklama.Text;
yeniUrun.BirimFiyat = Convert.ToDecimal(txtFiyat.Text);
yeniUrun.DepoyaGirenMiktar = Convert.ToInt32(txtMiktar.Text);
yeniUrun.KullanilanMiktar = 0;
yeniUrun.BitisSuresi = cldBitisTarihi.SelectedDate;
yeniUrun.MarkaID = Convert.ToInt32(ddlMarkalar.SelectedValue);
yeniUrun.GrupID = Convert.ToInt32(ddlUrunGrubu.SelectedValue);
data.SubmitChanges();
data.RenkvsUruns.DeleteAllOnSubmit(data.RenkvsUruns.Where(ru => ru.UrunID == id));
List <RenkvsUrun> yeniUrunRenkleri = new List <RenkvsUrun>();
int i = 0, c = blRenkler.Items.Count;
while (i < c)
{
RenkvsUrun yeniUrunRenk = new RenkvsUrun();
yeniUrunRenk.RenkID = Convert.ToInt32(blRenkler.Items[i].Value);
yeniUrunRenk.UrunID = id;
yeniUrunRenkleri.Add(yeniUrunRenk);
i++;
}
var recUR = (from ur in yeniUrunRenkleri
select ur);
data.RenkvsUruns.InsertAllOnSubmit(yeniUrunRenkleri);
data.BedenvsUruns.DeleteAllOnSubmit(data.BedenvsUruns.Where(bu => bu.UrunID == id));
List <BedenvsUrun> yeniUrunBedenleri = new List <BedenvsUrun>();
i = 0; c = blBedenler.Items.Count;
while (i < c)
{
BedenvsUrun yeniUrunBeden = new BedenvsUrun();
yeniUrunBeden.BedenID = Convert.ToInt32(blBedenler.Items[i].Value);
yeniUrunBeden.UrunID = id;
yeniUrunBedenleri.Add(yeniUrunBeden);
i++;
}
var recUB = (from ub in yeniUrunBedenleri
select ub);
data.BedenvsUruns.InsertAllOnSubmit(recUB);
DataTable dtG = new DataTable();
if (Session["MevcutGorseller"] == null)
{
dtG = new DataTable();
dtG.Columns.Add("GorselAdres");
}
else
{
dtG = (DataTable)Session["MevcutGorseller"];
}
data.UrunGorselis.DeleteAllOnSubmit(data.UrunGorselis.Where(ug => ug.UrunID == id));
List <UrunGorseli> yeniUrunGorselleri = new List <UrunGorseli>();
i = 0; c = dtG.Rows.Count;
while (i < c)
{
UrunGorseli yeniUrunGorseli = new UrunGorseli();
yeniUrunGorseli.GorselAdres = dtG.Rows[i]["GorselAdres"].ToString();
yeniUrunGorseli.UrunID = yeniUrun.UrunID;
yeniUrunGorselleri.Add(yeniUrunGorseli);
i++;
}
var recUG = (from ug in yeniUrunGorselleri
select ug);
data.UrunGorselis.InsertAllOnSubmit(recUG);
data.SubmitChanges();
Response.Redirect(Request.Url.AbsolutePath + "?UrunId=" + id.ToString());
}
}
}
}
catch
{
lblError.Text = "Bir hata oluştu";
}
}
