public string GetCustomerIdByName(string name, PharmacyDbContext db)
{
if (name == "")
{
name = "Unknown";
}
Customer customer = db.Customer.FirstOrDefault(i => i.Name == name);
if (customer != null)
{
return(customer.Id);
}
else
{
customer = new Customer
{
Id = UniqueNumber.GenerateUniqueNumber(),
Name = name,
Mobile = txtPhone.Text,
CreatedBy = currentUser,
CreatedDate = DateTime.Now
};
db.Customer.Add(customer);
db.SaveChanges();
return(customer.Id);
}
}
private void btnSave_Click(object sender, EventArgs e)
{
//try
//{
PharmacyDbContext db = new PharmacyDbContext();
foreach (ListViewItem item in lvMedicine.Items)
{
Medicine medicine = new Medicine();
medicine.Name = item.SubItems[2].Text;
medicine.Id = UniqueNumber.GenerateUniqueNumber();
medicine.CreatedBy = currentUser;
medicine.CreatedDate = DateTime.Now;
medicine.GroupId = GroupFactory.GetGroupId(item.SubItems[3].Text, currentUser);
medicine.CompanyId = CompanyFactory.GetCompanyId(item.SubItems[4].Text, currentUser);
db.Medicine.Add(medicine);
}
db.SaveChanges();
db.Dispose();
MessageBox.Show(@"Save successful!", "Success!", MessageBoxButtons.OK, MessageBoxIcon.Information);
lvMedicine.Items.Clear();
//}
//catch (Exception exception)
//{
// MessageBox.Show("Saving Error:" + exception.Message, "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
//}
}
private void InsertObjectiveSub(ObjectiveSub sub)
{
var mainId =
GetUnitOfWork()
.ObjectiveMainRepository.Get()
.Where(a => a.EmployeeId == CreatedBy && a.IsActive == true)
.Select(s => s.Id)
.FirstOrDefault();
int weight = 0;
if (mainId != Guid.Empty)
{
weight = GetUnitOfWork().ObjectiveSubRepository.Get().Where(a => a.ObjectiveMainId == mainId).Sum(s => s.Weight ?? 0) + sub.Weight ?? 0;
}
if (sub.Id != null)
{
if (weight - sub.Weight > 100)
{
throw new Exception("Weight should not be greater then 100");
}
ObjectiveSub ob = GetUnitOfWork().ObjectiveSubRepository.Get().FirstOrDefault(a => a.Id == sub.Id);
if (ob != null)
{
ob.KPI = sub.KPI;
ob.Note = sub.Note;
ob.Target = sub.Target;
ob.Weight = sub.Weight;
ob.Title = sub.Title;
ob.UpdatedBy = CreatedBy;
ob.UpdatedDate = DateTime.Now;
}
GetUnitOfWork().ObjectiveSubRepository.Update(ob);
}
else
{
if (weight > 100)
{
throw new Exception("Weight should not be greater then 100");
}
if (mainId == Guid.Empty)
{
ObjectiveMain main = new ObjectiveMain()
{
EmployeeId = CreatedBy
};
InsertObjectiveMain(main);
mainId = main.Id;
}
sub.CreatedBy = CreatedBy;
sub.CreatedDate = DateTime.Now;
sub.ObjectiveMainId = mainId;
sub.IsObjectiveApproved = false;
sub.Status = true;
sub.Id = UniqueNumber.GenerateUniqueNumber();
GetUnitOfWork().ObjectiveSubRepository.Insert(sub);
}
}
private void SaveMedicineIfNew()
{
PharmacyDbContext db = new PharmacyDbContext();
Medicine medicine = new Medicine();
medicine = db.Medicine.FirstOrDefault(a => a.Name == txtMedicine.Text);
if (medicine != null)
{
medicine.Name = txtMedicine.Text;
medicine.Id = UniqueNumber.GenerateUniqueNumber();
medicine.CreatedBy = currentUser;
medicine.CreatedDate = DateTime.Now;
medicine.GroupId = GroupFactory.GetGroupId(txtGroup.Text, currentUser);
medicine.CompanyId = CompanyFactory.GetCompanyId(txtCompany.Text, currentUser);
db.Medicine.Add(medicine);
}
}