void YeniKaydet()
{
try
{
bgSira sira = db.bgSiralar.First(x => x.Sadi == "GenelNo");
sira.Sno = int.Parse(txtGenelNo.Text);
Liste.AllowUserToAddRows = false;
stUrunKayitUst ust = new stUrunKayitUst();
ust.Aciklama = txtAcik.Text;
ust.AraToplam = decimal.Parse(txtAraToplam.Text);
ust.FirmaId = int.Parse(txtFno.Text);
ust.GenelNo = int.Parse(txtGenelNo.Text);
ust.GenelToplam = decimal.Parse(txtGenelToplam.Text);
ust.GirisKodu = firmaFid;
ust.GirisTarih = txtTarih.Value;
ust.KDVToplam = decimal.Parse(txtKdv.Text);
ust.Saat = txtSaat.Text;
ust.SaveDate = DateTime.Now;
ust.SaveUser = -1;
ust.UpdateDate = DateTime.Now;
ust.UpdateUser = -1;
ust.yazi = txtYazi.Text;
db.stUrunKayitUsts.Add(ust);
db.SaveChanges();
Temizle();
stUrunKayitAlt[] alt = new stUrunKayitAlt[Liste.RowCount];
for (int i = 0; i < Liste.RowCount; i++)
{
alt[i] = new stUrunKayitAlt();
alt[i].Aciklama = Liste.Rows[i].Cells[3].Value.ToString();
alt[i].Adet = int.Parse(Liste.Rows[i].Cells[4].Value.ToString());
alt[i].bFiyat = decimal.Parse(Liste.Rows[i].Cells[5].Value.ToString());
alt[i].GenelNo = int.Parse(txtGenelNo.Text);
alt[i].GirisKod = firmaFid;
alt[i].LotSeriNo = Liste.Rows[i].Cells[2].Value.ToString();
alt[i].Nott = Liste.Rows[i].Cells[7].Value.ToString();
alt[i].SaveDate = DateTime.Now;
alt[i].SaveUser = -1;
alt[i].UpdateDate = DateTime.Now;
alt[i].UpdateUser = -1;
alt[i].UrunId = int.Parse(Liste.Rows[i].Cells[8].Value.ToString());
alt[i].UrunKodu = Liste.Rows[i].Cells[1].Value.ToString();
db.stUrunKayitAlts.Add(alt[i]);
}
db.SaveChanges();
m.YeniKayit("Kayıt Basarıyla Gerceklestirildi.");
Temizle();
}
catch (Exception e)
{
m.Hata(e);
}
}
public ActionResult Create([Bind(Include = "Id,First_name,Last_name,Phone,Email,DOB,Sex,Weight,Height,type,password")] UserTable userTable)
{
try
{
if (ModelState.IsValid)
{
db.UserTables.Add(userTable);
db.SaveChanges();
return(RedirectToAction("Index"));
}
}
catch (Exception genericException)
{
ViewBag.ExceptionMessage = genericException;
}
return(View());
}
public ActionResult Create([Bind(Include = "Symptom_Id,Symptom_Desc,User_Id,C_Time")] Symptom symptom)
{
try
{
symptom.User_Id = Convert.ToInt32(Session["userId"].ToString());
if (ModelState.IsValid)
{
db.Symptoms.Add(symptom);
db.SaveChanges();
return(RedirectToAction("Index"));
}
ViewBag.User_Id = new SelectList(db.UserTables, "Id", "First_name", symptom.User_Id);
ViewBag.User_Id = new SelectList(db.UserTables, "Id", "First_name", symptom.User_Id);
}
catch (Exception genericException)
{
ViewBag.ExceptionMessage = genericException;
}
return(RedirectToAction("Index", "Symptoms"));
}
public ActionResult Index([Bind(Include = "Id,First_name,Last_name,Phone,Email,DOB,Sex,Weight,Height,type,password")] UserTable userTable)
{
try
{
if (ModelState.IsValid)
{
db.UserTables.Add(userTable);
db.SaveChanges();
Session["userId"] = userTable.Id;
Session["name"] = userTable.First_name;
//add formauth...
FormsAuthentication.SetAuthCookie(userTable.Email, false);
return(RedirectToAction("Create", "Symptoms"));
}
}
catch (Exception genericException)
{
ViewBag.ExceptionMessage = genericException;
}
return(View("Index", "Symptoms"));
}
private void btnSil_Click(object sender, EventArgs e)
{
db.bgUrunGirisler.Remove(db.bgUrunGirisler.Find(int.Parse(txtUno.Text)));
db.SaveChanges();
}
public int SaveChanges()
{
return(_context.SaveChanges());
}