public JsonResult musteriEkle(TBL_MUSTERILER m1)
{
MusteriRepository musRep = new MusteriRepository();
var musteriEkle = musRep.musteriEkle(m1);
return(Json(musteriEkle));
}
public ActionResult Guncelle(TBL_MUSTERILER p1)
{
var mstr = db.TBL_MUSTERILER.Find(p1.MUSTERIID);
mstr.MUSTERIAD = p1.MUSTERIAD;
mstr.MUSTERISOYAD = p1.MUSTERISOYAD;
db.SaveChanges();
return(RedirectToAction("Index"));
}
public ActionResult YeniMusteri(TBL_MUSTERILER p1)
{
if (!ModelState.IsValid)
{
return(View("YeniMusteri"));
}
db.TBL_MUSTERILER.Add(p1);
db.SaveChanges();
return(RedirectToAction("Index"));
}
private void gridView_Reh_Mus_DoubleClick(object sender, EventArgs e)
{
Form_Mail form_mail = new Form_Mail();
//form_mail.mail = gridView_Reh_Mus.GetFocusedRowCellValue("MAIL").ToString();//Seçili yerin fieldname değerini değişkene atar
int id = int.Parse(gridView_Reh_Mus.GetFocusedRowCellValue("ID").ToString());
TBL_MUSTERILER selrow = ticaridbml.TBL_MUSTERILERs.First(p => p.ID == id);
form_mail.mail = selrow.MAIL.ToString();
form_mail.Show();
}
private void show_musteriler()
{
TBL_MUSTERILER mustbl = new TBL_MUSTERILER();
var muslist = ticaridbml.TBL_MUSTERILERs.Select(p => new
{
ID = p.ID,
AD = p.AD,
SOYAD = p.SOYAD,
TELEFON = p.TELEFON,
TELEFON2 = p.TELEFON2,
MAIL = p.MAIL
}).ToList();
gridC_Reh_Mus.DataSource = muslist;
}
private void gridView_Mus_RowCellClick(object sender, DevExpress.XtraGrid.Views.Grid.RowCellClickEventArgs e)
{
int id = int.Parse(gridView_Mus.GetRowCellValue(gridView_Mus.FocusedRowHandle, "ID").ToString());
TBL_MUSTERILER selrow = ticaridbml.TBL_MUSTERILERs.First(p => p.ID == id);
//TBL_URUNLER selrow = gridView1.GetRow(gridView1.FocusedRowHandle) as TBL_URUNLER;
textE_Mus_Ad.EditValue = selrow.AD.ToString();
textE_Mus_Soyad.EditValue = selrow.SOYAD.ToString();
maskedT_Mus_Tel.Text = selrow.TELEFON.ToString();
maskedT_Mus_Tel2.Text = selrow.TELEFON2.ToString();
maskedT_Mus_Tc.Text = selrow.TC.ToString();
textE_Mus_Mail.EditValue = selrow.MAIL.ToString();
comboB_Mus_Il.Text = selrow.IL.ToString();
comboB_Mus_Ilce.Text = selrow.ILCE.ToString();
textE_Mus_VergiD.EditValue = selrow.VERGIDAIRE.ToString();
richT_Mus_Adres.Text = selrow.ADRES.ToString();
}
private void simpleB_Mus_Guncel_Click(object sender, EventArgs e)
{
int id = int.Parse(gridView_Mus.GetRowCellValue(gridView_Mus.FocusedRowHandle, "ID").ToString());
TBL_MUSTERILER mustbl = ticaridbml.TBL_MUSTERILERs.First(p => p.ID == id);
mustbl.AD = Convert.ToString(textE_Mus_Ad.EditValue);
mustbl.SOYAD = Convert.ToString(textE_Mus_Soyad.EditValue);
mustbl.TELEFON = Convert.ToString(maskedT_Mus_Tel.Text);
mustbl.TELEFON2 = Convert.ToString(maskedT_Mus_Tel2.Text);
mustbl.TC = Convert.ToString(maskedT_Mus_Tc.Text);
mustbl.MAIL = Convert.ToString(textE_Mus_Mail.Text);
mustbl.IL = Convert.ToString(comboB_Mus_Il.EditValue);
mustbl.ILCE = Convert.ToString(comboB_Mus_Ilce.EditValue);
mustbl.VERGIDAIRE = Convert.ToString(textE_Mus_VergiD.Text);
mustbl.ADRES = Convert.ToString(richT_Mus_Adres.Text);
ticaridbml.SubmitChanges();
make_null();
show_mus();
}
private void simpleB_Mus_Sil_Click(object sender, EventArgs e)
{
List <int> selected_list = new List <int>();
for (int i = 0; i < gridView_Mus.DataRowCount; i++)
{
if (gridView_Mus.IsRowSelected(i))
{
selected_list.Add(i);
}
}
selected_list.Reverse();
foreach (int i in selected_list)
{
int id = int.Parse(gridView_Mus.GetListSourceRowCellValue(i, "ID").ToString());
TBL_MUSTERILER selrow = ticaridbml.TBL_MUSTERILERs.First(p => p.ID == id);
ticaridbml.TBL_MUSTERILERs.DeleteOnSubmit(selrow);
ticaridbml.SubmitChanges();
show_mus();
}
}
private void simpleB_Mus_Kaydet_Click(object sender, EventArgs e)
{
if (textE_Mus_Ad.EditValue == null)
{
MessageBox.Show("Tüm boşlukları doldurunuz", "Hata", MessageBoxButtons.OK, MessageBoxIcon.Error);
return;
}
TBL_MUSTERILER mustbl = new TBL_MUSTERILER();
mustbl.AD = Convert.ToString(textE_Mus_Ad.EditValue);
mustbl.SOYAD = Convert.ToString(textE_Mus_Soyad.EditValue);
mustbl.TELEFON = Convert.ToString(maskedT_Mus_Tel.Text);
mustbl.TELEFON2 = Convert.ToString(maskedT_Mus_Tel2.Text);
mustbl.TC = Convert.ToString(maskedT_Mus_Tc.Text);
mustbl.MAIL = Convert.ToString(textE_Mus_Mail.EditValue);
mustbl.IL = Convert.ToString(comboB_Mus_Il.EditValue);
mustbl.ILCE = Convert.ToString(comboB_Mus_Ilce.Text);
mustbl.VERGIDAIRE = Convert.ToString(textE_Mus_VergiD.EditValue);
mustbl.ADRES = Convert.ToString(richT_Mus_Adres.Text);
ticaridbml.TBL_MUSTERILERs.InsertOnSubmit(mustbl);
ticaridbml.SubmitChanges();
show_mus();
make_null();
}
private void RaporDosyalariOnizle_Load(object sender, EventArgs e)
{
try
{
DBEntities db = new DBEntities();
DirectoryInfo Folder;
string barkod = RaporBarkodNo.BarkodKodu;
Bitmap pbimage;
if (barkod.Length <= 5)
{
Folder = new DirectoryInfo(@"//10.0.0.141/SalautoRaporlar//MusterilerEskiDB//" + barkod);
pbimage = new Bitmap(@"//10.0.0.141/SalautoRaporlar//MusterilerEskiDB//" + barkod + "//" + barkod + ".jpg");
int musterino = barkod.Toint58();
musteri tm = db.musteri.FirstOrDefault(x => x.MusteriID == musterino);
this.Text = tm.musteriadi + " " + tm.musterisoyadi;
}
else
{
string dosyadi = string.Empty;
foreach (string f in Directory.GetFiles(@"//10.0.0.141/SalautoRaporlar//" + barkod))
{
dosyadi = Path.GetFileName(f);
break;
}
Folder = new DirectoryInfo(@"//10.0.0.141/SalautoRaporlar//" + barkod);
pbimage = new Bitmap(@"//10.0.0.141/SalautoRaporlar//" + barkod + "//" + dosyadi);
TBL_MUSTERILER tm = db.TBL_MUSTERILER.FirstOrDefault(x => x.BarkodNo == barkod);
this.Text = tm.AliciAdsoyad;
}
pbonizleme.Image = pbimage;
Images = Folder.GetFiles();
pnControls.Controls.Clear();
int locnewX = locX;
int locnewY = locY;
foreach (FileInfo img in Images)
{
if (img.Extension.ToLower() == ".png" || img.Extension.ToLower() == ".jpg" || img.Extension.ToLower() == ".gif" || img.Extension.ToLower() == ".jpeg" || img.Extension.ToLower() == ".bmp" || img.Extension.ToLower() == ".tif")
{
if (locnewX >= pnControls.Width - sizeWidth - 10)
{
locnewX = locX;
locY = locY + sizeHeight + 30;
locnewY = locY;
}
else
{
locnewY = locY;
}
bmpimage = new Bitmap(img.FullName);
loadImagestoPanel(img.Name, locnewX, locnewY);
locnewY = locY + sizeHeight + 10;
locnewX = locnewX + sizeWidth + 10;
GC.Collect();
GC.WaitForPendingFinalizers();
GC.Collect();
GC.WaitForFullGCComplete();
GC.Collect();
}
int SaveVal = 0;
locX = 20;
locY = 10;
sizeWidth = 113;
sizeHeight = 160;
foreach (Control p in pnControls.Controls)
{
SaveVal = SaveVal + 1;
}
if (SaveVal > 0)
{
loadControls();
}
}
GC.Collect();
GC.WaitForPendingFinalizers();
GC.Collect();
GC.WaitForFullGCComplete();
GC.Collect();
}
catch (Exception)
{
MessageBox.Show("Rapor dosyası bulunamadı !", "HATA", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
