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();
}
