private void FinanceReport_Load(object sender, EventArgs e)
{
Supplier supplier = new Supplier();
supplier.LoadAll();
lkSupplier.Properties.DataSource = supplier.DefaultView;
lkAccount.SetupActivityEditor().SetDefaultActivity();
LoadStatusGrid();
}
/// <summary>
/// Load the drop downs and tables
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void HospitalSettings_Load(object sender, EventArgs e)
{
Supplier sup = new Supplier();
sup.LoadAll();
PopulateSupplier(sup);
Stores str = new Stores();
str.LoadAll();
PopulateStores(str);
Shelf slf = new Shelf();
DataTable dtSlf = slf.GetShelves();
PopulateShelves(dtSlf.DefaultView);
ReceivingUnits recUnit = new ReceivingUnits();
recUnit.LoadAll();
PopulateReceivingUnit(recUnit);
DataTable dtdumin = new DataTable();
dtdumin.Columns.Add("Value");
dtdumin.Columns.Add("Month");
object[] objdumin01 = { 0.25, "1 Weeks" };
dtdumin.Rows.Add(objdumin01);
object[] objdumin0 = { 0.5, "2 Weeks" };
dtdumin.Rows.Add(objdumin0);
object[] objdumin1 = { 0.75, ("3 Weeks") };
dtdumin.Rows.Add(objdumin1);
object[] objdumin2 = { 1, (1 + " Month") };
dtdumin.Rows.Add(objdumin2);
object[] objdumin3 = { 2, (2 + " Month") };
dtdumin.Rows.Add(objdumin3);
cboDUMin.DataSource = dtdumin;
DataTable dtdumax = new DataTable();
dtdumax.Columns.Add("Value");
dtdumax.Columns.Add("Month");
object[] objdumax01 = { 0.25, "1 Weeks" };
dtdumax.Rows.Add(objdumax01);
object[] objdumax010 = { 0.5, "2 Weeks" };
dtdumax.Rows.Add(objdumax010);
object[] objdumax011 = { 0.75, ("3 Weeks") };
dtdumax.Rows.Add(objdumax011);
object[] objdumax012 = { 1, (1 + " Month") };
dtdumax.Rows.Add(objdumax012);
object[] objdumax013 = { 2, (2 + " Month") };
dtdumax.Rows.Add(objdumax013);
cboDUMax.DataSource = dtdumax;
}
/// <summary>
/// Saves supplier information
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void btnSupplierSave_Click(object sender, EventArgs e)
{
if (txtCompanyName.Text != "" && cboCompanyInfo.SelectedItem != null)
{
Supplier sup = new Supplier();
if (_supplierId != 0)
sup.LoadByPrimaryKey(_supplierId);
else
sup.AddNew();
sup.CompanyInfo = cboCompanyInfo.SelectedItem.ToString();
sup.CompanyName = txtCompanyName.Text;
sup.Address = txtAddress.Text;
sup.ContactPerson = txtContactPerson.Text;
sup.Telephone = txtTelephone.Text;
sup.IsActive = ckIsActive.Checked;
sup.Mobile = txtMobile.Text;
sup.Email = txtEmail.Text;
sup.Save();
sup.LoadAll();
PopulateSupplier(sup);
ResetSupplier();
XtraMessageBox.Show("Supplier Record Updated.", "Confirmation", MessageBoxButtons.OK,
MessageBoxIcon.Information);
}
else
{
txtCompanyName.BackColor = Color.FromArgb(251, 214, 214);
}
}
private void PopulateFields()
{
// Bind the lookups first
ABC abc = new ABC();
abc.LoadAll();
radioGroupABC.Properties.Items.Clear();
while(!abc.EOF){
radioGroupABC.Properties.Items.Add(new RadioGroupItem(abc.ID, abc.Description));
abc.MoveNext();
}
radioGroupVEN.Properties.Items.Clear();
VEN ven = new VEN();
ven.LoadAll();
while (!ven.EOF)
{
radioGroupVEN.Properties.Items.Add(new RadioGroupItem(ven.ID, ven.Description));
ven.MoveNext();
}
if(itemId != 0)
{
Item itm = new Item();
//itm.LoadByPrimaryKey(itemId);
DataTable dtItem = itm.GetItemById(itemId);
txtItemName.Text = itm.FullItemName;//String.Format("{0} - {1} - {2}", dtItem.Rows[0]["ItemName"], dtItem.Rows[0]["DosageForm"], dtItem.Rows[0]["Strength"]);
ckExculed.Checked = (!itm.IsColumnNull("IsInHospitalList"))?itm.IsInHospitalList:false;
chkProcessDecimal.Checked = (!itm.IsColumnNull("ProcessInDecimal")) ? itm.ProcessInDecimal : false;
if (!itm.IsColumnNull("ABCID"))
{
radioGroupABC.EditValue = itm.GetColumn("ABCID");
}
if (!itm.IsColumnNull("VENID"))
{
radioGroupVEN.EditValue = itm.GetColumn("VENID");
}
Supplier sup = new Supplier();
sup.LoadAll();
ItemSupplier itmSup = new ItemSupplier();
itmSup.GetSuppliersAndMarkThoseUsed(itemId);
while(!itmSup.EOF)
{
lstSuppliers.Items.Add(itmSup.GetColumn("CompanyName"),Convert.ToBoolean(itmSup.GetColumn("IsUsed")));
itmSup.MoveNext();
}
BLL.Program prog = new BLL.Program();
prog.GetSubPrograms();
ItemProgram progItem = new ItemProgram();
lstPrograms.Items.Clear();
foreach (DataRowView dv in prog.DefaultView)
{
bool check = false;
check = progItem.CheckIfExists(itemId,Convert.ToInt32(dv["ID"]));
lstPrograms.Items.Add(dv["Name"],check);
}
}
}
private void EditReceived_Load(object sender, EventArgs e)
{
BLL.ItemManufacturer im = new BLL.ItemManufacturer();
im.LoadManufacturersFor(rDoc.ItemID);
lkManufacturer.Properties.DataSource = im.DefaultView;
if (BLL.Settings.UseNewUserManagement && this.HasPermission("Edit-Quantity") && (rDoc.IsColumnNull("Confirmed") || (!rDoc.IsColumnNull("Confirmed") && !rDoc.Confirmed)))
{
txtQuanitity.Enabled = true;
}
else if ( (!rDoc.IsColumnNull("Confirmed") && !rDoc.Confirmed))
{
txtQuanitity.Enabled = true;
}
else
{
txtQuanitity.Enabled = false;
}
Supplier supplier = new Supplier();
supplier.LoadAll();
lkSupplier.Properties.DataSource = supplier.DefaultView;
lkAccount.SetupActivityEditor().SetDefaultActivity();
BLL.ItemUnit iu = new ItemUnit();
iu.LoadAllForItem(rDoc.ItemID);
lkUnit.Properties.DataSource = iu.DefaultView;
// Bind the variables)
if (rDoc.RowCount > 0)
{
this.txtRefNo.Text = rDoc.RefNo;
this.txtQuanitity.Text =
Convert.ToInt32(Convert.ToDouble(rDoc.Quantity)/rDoc.QtyPerPack).ToString("#,##0");
this.txtManufacturer.Text = Manufacturer.GetName(rDoc.ManufacturerId);
this.txtItemName.Text = Item.GetName(rDoc.ItemID);
this.txtGrvNo.Text = rDoc.RefNo;
this.lkManufacturer.EditValue = rDoc.ManufacturerId;
this.lkAccount.EditValue = rDoc.StoreID;
this.lkUnit.EditValue = rDoc.UnitID;
if (!rDoc.IsColumnNull("SupplierID"))
lkSupplier.EditValue = rDoc.SupplierID;
// Editable controls
txtPrice.Text = rDoc.IsColumnNull("Cost") ? "0" : rDoc.Cost.ToString();
if (!rDoc.IsColumnNull("ExpDate"))
{
dtExpiry.EditValue = rDoc.ExpDate;
}
if (!rDoc.IsColumnNull("BatchNo"))
{
txtBatchNo.Text = rDoc.BatchNo;
}
BLL.Item itm = new Item();
itm.LoadByPrimaryKey(rDoc.ItemID);
if (BLL.Settings.UseNewUserManagement && this.HasPermission("Edit-Batch-Expiry"))
{
}
else if (!itm.NeedExpiryBatch &&
(CurrentContext.LoggedInUser.UserType == UserType.Constants.ADMIN ||
CurrentContext.LoggedInUser.UserType == UserType.Constants.SUPER_ADMINISTRATOR))
{
btnRemoveExpiry.Enabled = true;
txtBatchNo.Enabled = true;
}
}
}
private void HospitalSettings_Load(object sender, EventArgs e)
{
SetPermissions();
Supplier sup = new Supplier();
sup.LoadAll();
PopulateSupplier(sup);
PopulateStores();
Shelf slf = new Shelf();
DataTable dtSlf = slf.GetShelves();
PopulateShelves(dtSlf.DefaultView);
LoadIssueLocations();
AdjustLabelsForHub();
}
private void btnSupplierSave_Click(object sender, EventArgs e)
{
if (supplierValidation.Validate())
{
Supplier sup = new Supplier();
if (supplierId != 0)
sup.LoadByPrimaryKey(supplierId);
else
sup.AddNew();
sup.CompanyInfo = cboCompanyInfo.EditValue.ToString();
sup.CompanyName = txtCompanyName.Text;
sup.Address = txtAddress.Text;
sup.ContactPerson = txtContactPerson.Text;
sup.Telephone = txtTelephone.Text;
sup.IsActive = ckIsActive.Checked;
sup.Mobile = txtMobile.Text;
sup.Email = txtEmail.Text;
sup.Save();
sup.LoadAll();
PopulateSupplier(sup);
ResetSupplier();
}
else
{
txtCompanyName.BackColor = Color.FromArgb(251, 214, 214);
}
}