public ActionResult SaveMedicalTestBillInfo(TestBill objTestBill, List <TestBillDetails> objTestBillDetails) { var laboratoryBilling = _objIInvoice.GetLaboratoryBillingDetailsById(0); laboratoryBilling.BILLNAME = objTestBill.BILLNAME; laboratoryBilling.CONTACT = objTestBill.CONTACT; laboratoryBilling.BILLDATE = DateTime.Now; laboratoryBilling.CREATEDDATE = DateTime.Now; laboratoryBilling.BILLBY = LoginId.ToString(); var totalTax = objTestBillDetails.Select(x => x.TAXAMOUNT).Sum(); laboratoryBilling.BILLAMOUNT = objTestBillDetails.Select(x => x.COST).Sum() + totalTax; objTestBillDetails.ForEach(x => { laboratoryBilling.lmsLaboratoryBillingDetails.Add(new lmsLaboratoryBillingDetail { TESTID = x.TESTID, ITEMCOST = x.COST, TESTRESULT = x.TESTRESULT, TAXAMOUNT = x.TAXAMOUNT }); }); var saveLaboratoryBillingDetails = _objIInvoice.SaveLaboratoryBilling(laboratoryBilling); return(Json(saveLaboratoryBillingDetails, JsonRequestBehavior.AllowGet)); }
public ActionResult SaveBillInfo(DrugBill objDrugBill, List <DrugBillDetails> objDrugBillDetails) { var medicalBilling = _objIInvoice.GetMedicalBillDetailsById(0); medicalBilling.BILLNAME = objDrugBill.BILLNAME; medicalBilling.CONTACT = objDrugBill.CONTACT; medicalBilling.BILLDATE = DateTime.Now; medicalBilling.CREATEDDATE = DateTime.Now; var totalTax = objDrugBillDetails.Select(x => x.TAXAMOUNT).Sum(); medicalBilling.BILLAMOUNT = objDrugBillDetails.Select(x => x.COST).Sum() + totalTax; medicalBilling.BILLBY = LoginId.ToString(); objDrugBillDetails.ForEach(x => { medicalBilling.lmsMedicalBillingDetails.Add(new lmsMedicalBillingDetail { DRUGID = x.DRUGID, QUANTITY = x.QUANTITY, ITEMCOST = x.COST, TAXAMOUNT = x.TAXAMOUNT }); }); #region <<Update Drug Quantity>> objDrugBillDetails.ForEach(x => { var drugInfo = _objIHospitalMaster.GetDrugDetailsById(x.DRUGID); drugInfo.ORDERCOUNT = drugInfo.ORDERCOUNT - x.QUANTITY; _objIHospitalMaster.SaveDrug(drugInfo); }); #endregion <<Update Drug Quantity>> var saveMedicalBillDetails = _objIInvoice.SaveMedicalBill(medicalBilling); return(Json(saveMedicalBillDetails, JsonRequestBehavior.AllowGet)); }
private void BtnGiris_Click(object sender, EventArgs e) { if (txtKullaniciAdi.Text == string.Empty) { MessageBox.Show(@"Lütfen Kullanıcı Adınızı Giriniz.", "Tahmin Manager", MessageBoxButtons.OK, MessageBoxIcon.Error); txtKullaniciAdi.Focus(); return; } if (txtSifre.Text == string.Empty) { MessageBox.Show("Lütfen Şifrenizi Kontrol Ediniz.", "Tahmin Manager", MessageBoxButtons.OK, MessageBoxIcon.Error); txtSifre.Focus(); return; } baglanti.Open(); SqlCommand cmd = new SqlCommand(@"SELECT kullaniciAdi,sifre,Id from Kullanicilar where kullaniciAdi = '" + txtKullaniciAdi.Text + "' and sifre = '" + txtSifre.Text + "'", baglanti); SqlDataReader data = cmd.ExecuteReader(); while (data.Read()) { kullaniciAdi = data[0].ToString(); sifre = data[1].ToString(); personelId = Convert.ToInt32(data[2].ToString()); } baglanti.Close(); if (sifre == txtSifre.Text) { baglanti.Open(); SqlCommand cmd2 = new SqlCommand("SELECT Id from kullanicilar where kullaniciAdi = '" + txtKullaniciAdi.Text + "' and sifre = '" + txtSifre.Text + "'", baglanti); SqlDataReader data2 = cmd2.ExecuteReader(); while (data2.Read()) { KullaniciId = Convert.ToInt32(data2[0].ToString()); } baglanti.Close(); windowsKullaniciAdi = System.Windows.Forms.SystemInformation.UserName.ToString(); bilgisayarAdi = System.Environment.MachineName.ToString(); IpAdresi = GetIP(); girisTarihi = DateTime.Now.ToString("yyyy.MM.dd HH:mm:ss"); baglanti.Open(); SqlCommand loginKaydiEkle = new SqlCommand(String.Format("INSERT INTO login (KullaniciId,BilgisayarAdi,WindowsKullaniciAdi,GirisTarihi,Ip) VALUES ('{0}','{1}','{2}','{3}','{4}')", KullaniciId, bilgisayarAdi, windowsKullaniciAdi, girisTarihi, IpAdresi), baglanti); loginKaydiEkle.ExecuteNonQuery(); baglanti.Close(); baglanti.Open(); SqlCommand cmd3 = new SqlCommand("SELECT top 1 Id from Login order by Id desc ", baglanti); SqlDataReader data3 = cmd3.ExecuteReader(); while (data3.Read()) { LoginId = data3[0].ToString(); } baglanti.Close(); this.Hide(); } else { MessageBox.Show(@"Geçersiz Şifre", "Tahmin Manager", MessageBoxButtons.OK, MessageBoxIcon.Error); txtSifre.Focus(); txtSifre.SelectAll(); return; } x = LoginId.ToString(); kullaniciAdi = txtKullaniciAdi.Text; kullaniciId = KullaniciId; loginId = Convert.ToInt32(LoginId); IP = IpAdresi; kullanici = kullaniciAdi; baglanti.Close(); a.Show(); }