private void Dosages_FormClosing(object sender, FormClosingEventArgs e)
{
var cl = new DrugDispatch();
cl.UpdateDosageTable(dsMaster1.DOSAGES);
}
private void Dosages_Load(object sender, EventArgs e)
{
var cl = new DrugDispatch();
dsMaster1.Merge(cl.GetDosagesDataTable());
}
void DoSave()
{
if (patname.EditValue == null)
{
XtraMessageBox.Show("Please enter the patient name", "POS", MessageBoxButtons.OK,
MessageBoxIcon.Information);
return;
}
if (hospname.EditValue == null)
{
XtraMessageBox.Show("Please enter the hosipital name", "POS", MessageBoxButtons.OK,
MessageBoxIcon.Information);
return;
}
if (lookupcashier.EditValue == null)
{
XtraMessageBox.Show("Please doctor not found", "POS", MessageBoxButtons.OK,
MessageBoxIcon.Information);
return;
}
if (voudate.EditValue == null)
{
XtraMessageBox.Show("Please enter the date", "POS", MessageBoxButtons.OK,
MessageBoxIcon.Information);
return;
}
if (dsMaster1.DDDETAILS.Rows.Count == 0)
{
XtraMessageBox.Show("Nothing to save", "POS", MessageBoxButtons.OK,
MessageBoxIcon.Information);
return;
}
gridView1.PostEditor();
gridView1.UpdateCurrentRow();
var dr = (DsMaster.DDMASTRow) dsMaster1.DDMAST.NewRow();
dr.DNO = _dosageno;
dr.PATNAME = patname.Text;
dr.HOSPITAL = hospname.Text;
dr.COMP = Utils.Company;
dr.TDATE = voudate.DateTime.Date;
if(lookupcashier.EditValue!=null)
dr.DOCTOR = int.Parse(lookupcashier.EditValue.ToString());
var bhl = new DrugDispatch();
dDDETAILSBindingSource.EndEdit();
var changes = (DsMaster.DDDETAILSDataTable)dsMaster1.DDDETAILS.GetChanges(DataRowState.Modified | DataRowState.Added);
try
{
var strstatus = bhl.DoSaveDrugDispatch(dr, dsMaster1.DDDETAILS);
if (strstatus == "1")
{
_dosageno = Utils.DosageNo;
txtvocherno.Text = _dosageno;
XtraMessageBox.Show("Data Saved Sucessfully", "POS", MessageBoxButtons.OK, MessageBoxIcon.Information);
foreach (DataRow d in dsMaster1.DDDETAILS.Rows)
{
if (d.RowState != DataRowState.Deleted)
{
d["DNO"] = _dosageno;
}
}
var addedRows = from row in dsMaster1.DDDETAILS
where row.RowState == DataRowState.Added
select row;
foreach (var row in addedRows.ToArray())
{
row.Delete();
}
if (changes != null) dsMaster1.Merge(changes);
dsMaster1.AcceptChanges();
}
else
{
XtraMessageBox.Show(strstatus, "POS", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
}
catch (Exception ex)
{
XtraMessageBox.Show(ex.ToString());
}
}