public static EPICTURE resim_yolu(int a)
{
EPICTURE item = new EPICTURE();
try
{
SqlCommand com = new SqlCommand("resim_yazdir", FCONNECTION.conn);
com.CommandType = CommandType.StoredProcedure;
if (com.Connection.State != ConnectionState.Open)
{
com.Connection.Open();
}
com.Parameters.AddWithValue("ProductID", a);
SqlDataReader rdr = com.ExecuteReader();
if (rdr.HasRows)
{
while (rdr.Read())
{
item.PicDirectory = rdr["PicDirectory"].ToString();
}
}
com.Connection.Close();
rdr.Close();
}
catch
{
}
return(item);
}
public static int AddPicture(EPICTURE item)
{
int satir = -1;
try
{
SqlCommand com = new SqlCommand("Add_Picture", FCONNECTION.conn);
com.CommandType = CommandType.StoredProcedure;
if (com.Connection.State != ConnectionState.Open)
{
com.Connection.Open();
}
com.Parameters.AddWithValue("ProductID", item.ProductID);
com.Parameters.AddWithValue("PicDirectory", item.PicDirectory);
satir = com.ExecuteNonQuery();
com.Connection.Close();
}
catch
{
satir = -1;
}
return(satir);
}
private void incele1_Click(object sender, EventArgs e)
{
TABLO.SelectedIndex = 1;
//if(sol1sag2==1)
EPICTURE resim1 = resim_yolu(temp_UrunID);
UrunAlPic.ImageLocation = resim1.PicDirectory;
urunID.Text = temp_UrunID.ToString();
UsersID.Text = TempUsersID.Text;
tempurunID1.Text = temp_UrunID.ToString();
EPRODUCT deger = BLLPRODUCT.urun_listele(temp_UrunID);//sayfa no
urun_ad.Text = deger.Name;
urun_fiyat.Text = deger.Price.ToString();
EUSERS deger2 = BLLUSERS.kullanici_ismi(Convert.ToInt32(UsersID.Text));
urun_sahibi.Text = "(" + deger2.Username + ") " + deger2.Name + " " + deger2.Surname;
}
private void sayfalandirma(int sayfano, int solSag)
{
int sayfanum = sayfano;
if (solSag == 1)
{
solSag = 2 * CategoryID - 1;
}
else
{
solSag = 2 * CategoryID;
}
sayfanum = sayfanum + (sayfanum - 1) * 2;
EPRODUCT deger = urun_yazdir(sayfanum, solSag);//sayfa no
UrunAdiArabalar1.Text = deger.Name;
UrunFiyatiArabalar1.Text = deger.Price.ToString();
int UrunId = Convert.ToInt32(deger.ID);
temp_UrunID = Convert.ToInt32(deger.ID);
TempUsersID.Text = deger.UsersID.ToString();
EPICTURE resim1 = resim_yolu(UrunId);
picAraba1.ImageLocation = resim1.PicDirectory;
EPRODUCT deger2 = urun_yazdir(sayfanum + 1, solSag);
UrunAdiArabalar2.Text = deger2.Name;
UrunFiyatiArabalar2.Text = deger2.Price.ToString();
int UrunId2 = Convert.ToInt32(deger2.ID);
temp_UrunID2 = Convert.ToInt32(deger2.ID);
TempUsersID2.Text = deger2.UsersID.ToString();
EPICTURE resim2 = resim_yolu(UrunId2);
picAraba2.ImageLocation = resim2.PicDirectory;
}
private void Uruneklebuton_Click(object sender, EventArgs e)
{
if (tempPicNo != 0)
{
EPRODUCT item = new EPRODUCT();
item.Name = urunadi.Text;
item.Price = Convert.ToInt32(urunfiyati.Text);
//tam buraya
item.SubCategoryID = Convert.ToInt32(altkategorilist.SelectedValue);
item.UsersID = UserIDNo;
if (BLLPRODUCT.AddItem(item, ref tempPicID) > 1)
{
MessageBox.Show("Urun eklendi.");
}
else
{
MessageBox.Show("Ekleme hatasi");
}
string UsersID = UserIDNo.ToString();
string resimAdi1 = UsersID + "." + tempPicID.ToString() + "." + "1";
string resimAdi2 = UsersID + "." + tempPicID.ToString() + "." + "2";
string resimAdi3 = UsersID + "." + tempPicID.ToString() + "." + "3";
string filePath1 = Application.StartupPath + "\\scan\\" + resimAdi1 + ".jpg";
string filePath2 = Application.StartupPath + "\\scan\\" + resimAdi2 + ".jpg";
string filePath3 = Application.StartupPath + "\\scan\\" + resimAdi3 + ".jpg";
if (UrunEkleResim.Image != null)
{
EPICTURE item2 = new EPICTURE();
item2.ProductID = tempPicID;
item2.PicDirectory = filePath1;
BLLPICTURE.AddPicture(item2);
}
if (UrunEkleResim2.Image != null)
{
EPICTURE item2 = new EPICTURE();
item2.ProductID = tempPicID;
item2.PicDirectory = filePath2;
BLLPICTURE.AddPicture(item2);
}
if (UrunEkleResim3.Image != null)
{
EPICTURE item2 = new EPICTURE();
item2.ProductID = tempPicID;
item2.PicDirectory = filePath3;
BLLPICTURE.AddPicture(item2);
}
MessageBox.Show("1");
if (UrunEkleResim.Image != null)
{
UrunEkleResim.Image.Save(filePath1);
}
if (UrunEkleResim2.Image != null)
{
UrunEkleResim.Image.Save(filePath2);
}
if (UrunEkleResim3.Image != null)
{
UrunEkleResim.Image.Save(filePath3);
}
}
TabloUst.SelectedIndex = 0;
}
public static int AddPicture(EPICTURE item)
{
return(FPICTURE.AddPicture(item));
}
