private void cboStores_SelectedValueChanged(object sender, EventArgs e)
{
if (cboStores.SelectedValue == null)
{
return;
}
YearEnd yEnd = new YearEnd();
DataTable dtRec = yEnd.GetDistinctYear(Convert.ToInt32(cboStores.SelectedValue));
PopulateDocument(dtRec);
dtRec = yEnd.GetDocumentAll(Convert.ToInt32(cboStores.SelectedValue));
lblAdjDate.Text = @"All Years";
if (dtRec.Rows.Count == 0)
{
txtEmpty.Visible = true;
gridInventory.Visible = false;
}
else
{
gridInventory.Visible = true;
gridInventory.DataSource = dtRec;
}
}
//private DataTable GetPerjawatanExcel()
//{
// DataTable dt = new DataTable();
// try
// {
// List<BudgetPerjawatanYearEnd> data = new BudgetPerjawatanBAL().BudgetPerjawatanYearEnd(Convert.ToInt32(ddlBudgetYear.SelectedValue));
// List<string> sercodes = data.Select(x => x.GroupPerjawatanCode).Distinct().OrderBy(x => x).ToList();
// List<string> prefixs = data.Select(x => x.Prefix).Distinct().OrderBy(x => x).ToList();
// List<string> periods = data.Select(x => x.PeriodPerjawatan).Distinct().OrderBy(x => x).ToList();
// //Start Build DataTable
// DataColumn dc = new DataColumn();
// foreach (Segment seg in new SegmentBAL().GetSegments().OrderBy(x => x.SegmentOrder))
// {
// dc = new DataColumn(seg.SegmentName);
// dt.Columns.Add(dc);
// }
// dc = new DataColumn("ServiceCode");
// dt.Columns.Add(dc);
// dc = new DataColumn("Objeck");
// dt.Columns.Add(dc);
// dc = new DataColumn("Description");
// dt.Columns.Add(dc);
// foreach (string pe in periods)
// {
// dc = new DataColumn(pe);
// dt.Columns.Add(dc);
// }
// //End Build DataTable
// //Start pushing data into DataTable
// foreach (string pr in prefixs)
// {
// foreach (string ac in sercodes)
// {
// List<BudgetPerjawatanYearEnd> subset = data.Where(x => x.GroupPerjawatanCode == ac && x.Prefix == pr).ToList();
// if (subset.Count > 0)
// {
// int c = 0;
// DataRow dr = dt.NewRow();
// foreach (string sgd in subset[0].ListSegmentDetails)
// {
// dr[c] = sgd;
// c++;
// }
// dr[c] = ac;
// c++;
// dr[c] = pr + "-" + ac;
// c++;
// dr[c] = subset[0].Description;
// c++;
// foreach (string pe in periods)
// {
// BudgetPerjawatanYearEnd d = subset.Where(x => x.PeriodPerjawatan == pe).FirstOrDefault();
// if (d != null)
// dr[c] = d.Amount.ToString("F");
// else
// dr[c] = string.Empty;
// c++;
// }
// dt.Rows.Add(dr);
// }
// }
// }
// //End pushing data into DataTable
// }
// catch (Exception ex)
// {
// ((SiteMaster)this.Master).ShowMessage("Error", "An error occurred", ex, true);
// }
// return dt;
//}
//private DataTable GetProjekExcel()
//{
// DataTable dt = new DataTable();
// try
// {
// List<BudgetProjekYearEnd> data = new BudgetProjekBAL().BudgetProjekYearEnd(Convert.ToInt32(ddlBudgetYear.SelectedValue));
// List<string> acccodes = data.Select(x => x.AccountCode).Distinct().OrderBy(x => x).ToList();
// List<string> prefixs = data.Select(x => x.Prefix).Distinct().OrderBy(x => x).ToList();
// List<string> periods = data.Select(x => x.PeriodMengurus).Distinct().OrderBy(x => x).ToList();
// //Start Build DataTable
// DataColumn dc = new DataColumn();
// foreach (Segment seg in new SegmentBAL().GetSegments().OrderBy(x => x.SegmentOrder))
// {
// dc = new DataColumn(seg.SegmentName);
// dt.Columns.Add(dc);
// }
// dc = new DataColumn("AccountCode");
// dt.Columns.Add(dc);
// dc = new DataColumn("Object");
// dt.Columns.Add(dc);
// dc = new DataColumn("Description");
// dt.Columns.Add(dc);
// foreach (string pe in periods)
// {
// dc = new DataColumn(pe);
// dt.Columns.Add(dc);
// }
// //End Build DataTable
// //Start pushing data into DataTable
// foreach (string pr in prefixs)
// {
// foreach (string ac in acccodes)
// {
// List<BudgetProjekYearEnd> subset = data.Where(x => x.AccountCode == ac && x.Prefix == pr).ToList();
// if (subset.Count > 0)
// {
// int c = 0;
// DataRow dr = dt.NewRow();
// foreach (string sgd in subset[0].ListSegmentDetails)
// {
// dr[c] = sgd;
// c++;
// }
// dr[c] = ac;
// c++;
// dr[c] = pr + "-" + ac;
// c++;
// dr[c] = subset[0].Description;
// c++;
// foreach (string pe in periods)
// {
// BudgetProjekYearEnd d = subset.Where(x => x.PeriodMengurus == pe).FirstOrDefault();
// if (d != null)
// dr[c] = d.Amount.ToString("F");
// else
// dr[c] = string.Empty;
// c++;
// }
// dt.Rows.Add(dr);
// }
// }
// }
// //End pushing data into DataTable
// }
// catch (Exception ex)
// {
// ((SiteMaster)this.Master).ShowMessage("Error", "An error occurred", ex, true);
// }
// return dt;
//}
protected void gvYearEnd_RowDataBound(object sender, GridViewRowEventArgs e)
{
try
{
if (e.Row.RowType == DataControlRowType.DataRow)
{
YearEnd rowItem = (YearEnd)e.Row.DataItem;
LinkButton lb = ((LinkButton)e.Row.FindControl("btnStatus"));
lb.Text = rowItem.Status;
lb.Visible = (rowItem.Status == "Processed");
ScriptManager.GetCurrent(this).RegisterPostBackControl(lb);
List <YearEnd> data = (List <YearEnd>)Session["YearEndData"];
var span = ((System.Web.UI.HtmlControls.HtmlGenericControl)e.Row.FindControl("CustomStatus"));
int yearendid = Convert.ToInt32(DataBinder.Eval(e.Row.DataItem, "YearEndID"));
string YearStatus = data.Where(x => x.YearEndID == yearendid).Select(y => y.Status).FirstOrDefault();
if (YearStatus == "A")
{
span.InnerHtml = "<span class=\"label label-sm label-success arrowed-in arrowed-in-right tooltip-success\" " +
"data-rel=\"tooltip\" data-placement=\"right\" title=\"Active Status. All operation has been enabled.\">Active</span>";
}
}
}
catch (Exception ex)
{
((SiteMaster)this.Master).ShowMessage("Error", "An error occurred", ex, true);
}
}
private void btnDoEndOfYear_Click(object sender, EventArgs e)
{
var result = XtraMessageBox.Show("Are you sure you want to perform the year End activity automatically?",
"Confirm", MessageBoxButtons.YesNo, MessageBoxIcon.Question);
if (result == System.Windows.Forms.DialogResult.No)
{
return;
}
var confirm =
XtraMessageBox.Show(
"Performing the year end automatically will make HCMIS take the present stock as the beginning balance of the next fiscal year. You will not be able to use the Inventory page to input inventory data. Do you want to proceed?",
"Confirmation", MessageBoxButtons.YesNo);
if (confirm == DialogResult.No)
{
return;
}
btnDoEndOfYear.Enabled = false;
int year = ConvertDate.GetEthiopianYear(DateTimeHelper.ServerDateTime);
Activity stores = new Activity();
stores.LoadAll();
BLL.CommodityType commodityType = new BLL.CommodityType();
commodityType.LoadAll();
while (!commodityType.EOF)
{
while (!stores.EOF)
{
DataTable dtbl = Balance.GetSohForAllItems(stores.ID, commodityType.ID, year, 10);
YearEnd ye = new YearEnd();
foreach (DataRow dr in dtbl.Rows)
{
if (dr["ID"] == DBNull.Value || dr["UnitID"] == DBNull.Value)
{
continue;
}
ye.AddNew();
ye.ItemID = Convert.ToInt32(dr["ID"]);
ye.UnitID = Convert.ToInt32(dr["UnitID"]);
ye.StoreID = stores.ID;
ye.Year = year;
ye.PhysicalInventory = ye.EBalance = Convert.ToInt32(dr["SOH"]);
ye.PhysicalInventoryPrice = ye.EndingPrice = Convert.ToDecimal(Convert.ToDouble(dr["Price"]));
ye.Save();
}
stores.MoveNext();
}
commodityType.MoveNext();
}
XtraMessageBox.Show("Year End has been populated");
btnDoEndOfYear.Enabled = !BLL.YearEnd.IsPerformedForYear(EthiopianDate.EthiopianDate.Now.Year);
}
//protected void btnCancel_Click(object sender, EventArgs e)
//{
// ChangePageMode(Helper.PageMode.New);
// ClearPageData();
// EditBox.Visible = false;
//}
protected void gvYearEnd_RowCommand(object sender, GridViewCommandEventArgs e)
{
try
{
if (e.CommandName == "EditRow")
{
ClearPageData();
GridViewRow selectedRow = gvYearEnd.Rows[Convert.ToInt32(e.CommandArgument)];
selectedRow.Style["background-color"] = "skyblue";
int yearendid = Convert.ToInt32(gvYearEnd.DataKeys[selectedRow.RowIndex]["YearEndID"]);
YearEnd objYearEnd = ((List <YearEnd>)Session["YearEndData"]).Where(x => x.YearEndID == yearendid).FirstOrDefault();
Session["SelectedYearEnd"] = objYearEnd;
ddlBudgetType.SelectedIndex = -1;
ddlBudgetType.Items.FindByText(objYearEnd.BudgetType.ToString()).Selected = true;
ddlBudgetYear.SelectedIndex = -1;
ddlBudgetYear.Items.FindByValue(objYearEnd.BudgetYear.ToString()).Selected = true;
ddlStatus.SelectedIndex = -1;
ddlStatus.Items.FindByValue(objYearEnd.Status).Selected = true;
ddlStatus.Enabled = (objYearEnd.Status == "A");
ChangePageMode(Helper.PageMode.Edit);
EditForm.Visible = true;
}
else if (e.CommandName == "Download")
{
GridViewRow selectedRow = gvYearEnd.Rows[Convert.ToInt32(e.CommandArgument)];
int yearendid = Convert.ToInt32(gvYearEnd.DataKeys[selectedRow.RowIndex]["YearEndID"]);
YearEnd objYearEnd = ((List <YearEnd>)Session["YearEndData"]).Where(x => x.YearEndID == yearendid).FirstOrDefault();
string FolderPath = WebConfigurationManager.AppSettings["ArchiveFolderPath"];
string FileName = objYearEnd.BudgetYear + "_" + objYearEnd.BudgetType + ".xls";
if (File.Exists(FolderPath + FileName))
{
System.Web.HttpResponse response = System.Web.HttpContext.Current.Response;
response.ClearContent();
response.Clear();
response.ContentType = "application/vnd.ms-excel";
response.AddHeader("Content-Disposition", "attachment; filename=" + FileName + ";");
response.TransmitFile(FolderPath + FileName);
response.Flush();
response.End();
}
else
{
((SiteMaster)this.Master).ShowMessage("Failure", "File not found : " + FolderPath + FileName);
}
}
}
catch (Exception ex)
{
((SiteMaster)this.Master).ShowMessage("Error", "An error occurred", ex, true);
}
}
private void LstTransactionsMouseDoubleClick(object sender, MouseEventArgs e)
{
string yr = lstRefNo.SelectedItems[0].Tag.ToString();
if (yr != "")
{
YearEnd yEnd = new YearEnd();
DataTable dtRec = yEnd.GetDocumentByYear(Convert.ToInt32(lkActivity.EditValue), yr);
lblAdjDate.Text = yr;
PopulateTransactions(dtRec);
}
}
private void CboStoresSelectedValueChanged(object sender, EventArgs e)
{
if (lkActivity.EditValue != null)
{
YearEnd yEnd = new YearEnd();
DataTable dtRec = yEnd.GetDistinctYear(Convert.ToInt32(lkActivity.EditValue));
PopulateDocument(dtRec);
dtRec = yEnd.GetDocumentAll(Convert.ToInt32(lkActivity.EditValue));
lblAdjDate.Text = "All Years";
PopulateTransactions(dtRec);
}
}
private void gridView2_FocusedRowChanged(object sender, DevExpress.XtraGrid.Views.Base.FocusedRowChangedEventArgs e)
{
DataRow dr = gridView2.GetFocusedDataRow();
if (dr == null)
{
return;
}
int year = Convert.ToInt32(dr["Year"]);
YearEnd yEnd = new YearEnd();
gridInventory.DataSource = yEnd.GetDocumentByYear(Convert.ToInt32(cboStores.SelectedValue), year);
}
private void LkFromStoreEditValueChanged(object sender, EventArgs e)
{
var rDoc = new ReceiveDoc();
if (lkFromStore.EditValue == null)
{
return;
}
var dtItem = rDoc.GetRecievedItemsWithBalanceForStore(Convert.ToInt32(lkFromStore.EditValue), (int)lkCategories.EditValue);
PopulateItemList(dtItem);
var inventory = new YearEnd();
if (inventory.IsInventoryCompleteToReceive(2006, Convert.ToInt32(lkFromStore.EditValue)) != false)
{
return;
}
XtraMessageBox.Show("Please First Finish All Inventory and come back!", "Error", MessageBoxButtons.OK, MessageBoxIcon.Exclamation);
btnSave.Enabled = false;
}
public static bool IsInventoryPeriod()
{
int currentMonth = EthiopianDate.EthiopianDate.Now.Month;
if (currentMonth == 11)
{
YearEnd yearEnd = new YearEnd();
if (!yearEnd.IsInventoryCompleted(EthiopianDate.EthiopianDate.Now.Year))
{
MessageBox.Show("You are on inventory period and inventory is not completed for all Items Received and Issued this year!, so you cann't perform any transaction until inventory is done for all Items.", "HCMIS FE", MessageBoxButton.OK);
return(true);
}
else
{
return(false);
}
}
else
{
return(false);
}
}
/// <summary>
/// Handles the processing of balance
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void btnProcessBalance_Click(object sender, EventArgs e)
{
Items itm = new Items();
YearEnd yEnd = new YearEnd();
Balance bal = new Balance();
DataTable dtItm = itm.GetAllItems(1);
dtDate.Value = DateTime.Now;
DateTime dtCurent = Convert.ToDateTime(dtDate.Text);
foreach (DataRow dr in dtItm.Rows)
{
yEnd.AddNew();
yEnd.StoreID = Convert.ToInt32(cboStore.SelectedValue);
yEnd.ItemID = Convert.ToInt32(dr["ID"]);
yEnd.Year = Convert.ToInt32(cboYear.SelectedItem);
yEnd.Month = (Convert.ToInt32(cboYear.SelectedItem) == dtCurent.Year) ? dtCurent.Month : 10;
yEnd.BBalance = 0;
yEnd.EBalance = 0;
yEnd.PhysicalInventory = 0;
yEnd.Save();
}
}
private void BuildStoreInventoryListForHandleUnit(int year, int storeId, DataTable dtItm)
{
string[] str = { "Item Name", "Batch No.", "Remark", "Unit Price" };
foreach (string co in str)
{
dtBB.Columns.Add(co);
}
str = new string[] { "ItemId", "No.", "Beginning Balance", "Ending Balance(SOH)", "Physical Inventory", "ID", "RecID", "UnitID" };//, "Change Since Sene 30" };
foreach (string co in str)
{
dtBB.Columns.Add(co, typeof(int));
}
int count = 1;
var yProcess = new YearEnd();
var bal = new Balance();
dtDate.Value = DateTime.Now;
var dtCurent = new DateTime();
dtDate.CustomFormat = "MM/dd/yyyy";
dtCurent = ConvertDate.DateConverter(dtDate.Text);
var recDoc = new ReceiveDoc();
int month = dtCurent.Month;
if ((dtCurent.Month == 10 && dtCurent.Day == 30) || dtCurent.Month == 11)
{
btnSave.Enabled = ((!yProcess.IsInventoryComplete(year, storeId)));
//btnSave.Enabled = true;
month = 10;
}
else
{
btnSave.Enabled = false;
}
var yEnd = new YearEnd();
foreach (DataRow dr in dtItm.Rows)//For each item
{
var itemName = dr["ItemName"].ToString() + " - " + dr["DosageForm"].ToString() + " - " + dr["Strength"].ToString();
int itemId = Convert.ToInt32(dr["ID"]);
var unitid = Convert.ToInt32(dr["UnitID"]);
var BalanceExists = (yProcess.DoesBalanceExistByUnit(year, itemId, storeId, false, unitid));
//We don't want to display those items whose inventory has already been done.
if (BalanceExists)
{
continue;
}
// Int64 soh = bal.GetSOHByUnit(Convert.ToInt32(dr["ID"]), storeId, month, year,unitid);
Int64 soh = bal.GetSOHByUnitOptimized(Convert.ToInt32(dr["ID"]), storeId, month, year, unitid);
Int64 bbal = yEnd.GetBBalanceByUnit(year, storeId, Convert.ToInt32(dr["ID"]), month, unitid);
yProcess.GetBalanceByItemIdByUnitID(year, storeId, Convert.ToInt32(dr["ID"]), unitid);
Int64 BB = (yProcess.RowCount > 0) ? yProcess.BBalance : bbal;
Int64 EB = ((yProcess.RowCount > 0 && yProcess.EBalance != 0) ? yProcess.EBalance : soh);
string Phy = (yProcess.RowCount > 0) ? yProcess.PhysicalInventory.ToString() : (_defaultValueToPhysicalInventory ? EB.ToString() : "");
string remark = (yProcess.RowCount > 0) ? yProcess.Remark : "";
DataRowView drv = dtBB.DefaultView.AddNew();
if (yProcess.RowCount > 0)
{
drv["ID"] = yProcess.ID;
}
drv["ItemId"] = dr["ID"];
drv["No."] = count;
drv["Item Name"] = itemName;
drv["Beginning Balance"] = BB;
drv["Ending Balance(SOH)"] = EB;
drv["UnitID"] = unitid;
if (Phy != "")
{
drv["Physical Inventory"] = Phy;
}
drv["RecID"] = -1;
drv["Unit Price"] = "_";
drv["Remark"] = remark;
count++;
int theLastBalance = 0;
DataTable dtBatchs = recDoc.GetBatchWithValueByUnit(storeId, Convert.ToInt32(dr["ID"]), dtCurent, unitid);
foreach (DataRow drBatch in dtBatchs.Rows) //For each batch
{
if (drBatch["QuantityLeft"] != DBNull.Value && Convert.ToInt64(drBatch["QuantityLeft"]) != 0)
{
drv = dtBB.DefaultView.AddNew();
drv["Item Name"] = ">>";
drv["UnitID"] = drBatch["UnitID"];
drv["Batch No."] = drBatch["BatchNo"];
drv["Ending Balance(SOH)"] = Convert.ToInt64(drBatch["QuantityLeft"]);
//Now if the physical inventory is chosen to be default value, we set it to the ending balance of last year.
if (_defaultValueToPhysicalInventory)
{
drv["Physical Inventory"] = drBatch["QuantityLeft"].ToString();
}
theLastBalance += Convert.ToInt32(drBatch["QuantityLeft"]);
drv["RecID"] = drBatch["ID"];
drv["Unit Price"] = drBatch["Cost"].ToString();
}
}
//}
}
grdYearEnd.DataSource = dtBB;
dtDate.CustomFormat = "MMMM dd, yyyy"; //throw new NotImplementedException();
}
private void btnLogin_Click(object sender, EventArgs e)
{
try
{
//string connectionString = GenerateConnString.GetFromRegistry();
string connectionString = Program.ConnStringManager.GetFromRegistry();
if (string.IsNullOrEmpty(connectionString)) //If the connection string hasn't been set, let's assume that the database is installed in the default location (ApplicationStartUpPath\Database\PharmInventory.mdf)
{
connectionString = Program.ConnStringManager.GenerateDefaultConnectionString(@".\SQLExpress", @"C:\Databases\FE\PharmInventory.mdf", false);
Program.ConnStringManager.SaveToRegistry(connectionString);
}
MyGeneration.dOOdads.BusinessEntity.RegistryConnectionString = connectionString;
User us = new User();
us.GetUserByAccountInfo(txtUsername.Text, txtPassword.Text);
if (us.RowCount > 0)
{
//check for last date of backup and if old just do another one
GeneralInfo info = new GeneralInfo();
info.LoadAll();
TimeSpan spanAfterBackup;
int daysSinceBackup = -1;
if (!info.IsColumnNull("LastBackUp"))
{
spanAfterBackup = DateTime.Now.Subtract(info.LastBackUp);
daysSinceBackup = spanAfterBackup.Days;
}
if (daysSinceBackup > 7 || daysSinceBackup == -1)
{
HelperClasses.DatabaseHelpers.AutoBackUp();
}
DatabaseHelpers.FixInconsistencies(); //Clean any database inconsistencies
//XtraMessageBox.Show("Would you please chose the FE Settings", "Warning");
var mw = new MainWindow {
UserId = MainWindow.LoggedinId = us.ID
};
UsId = us.ID;
mw.Show();
try
{
HelperClasses.RegistrationHelper.SendAdditionalData("LastLogin", DateTime.Now.ToString());
}
catch { }
YearEnd yEnd = new YearEnd();
if (yEnd.InventoryRequired(true))
{
XtraMessageBox.Show("Inventory information has not been filled for the past fiscal year!",
"Inventory Required", MessageBoxButtons.OK, MessageBoxIcon.Exclamation);
}
this.Hide();
}
else
{
XtraMessageBox.Show("Invalid Username or Password!", "Login Failed", MessageBoxButtons.OK, MessageBoxIcon.Stop);
txtPassword.Text = "";
txtPassword.Focus();
}
}
catch
{
//Tools.GenerateConnString generator = new Tools.GenerateConnString();
//generator.ShowDialog();
Program.ConnStringManager.ShowDialog();
}
}
private void btnUpdateOnlyOnce_Click(object sender, EventArgs e)
{
DataTable dtBB = new DataTable();
Items itms = new Items();
int storeId = 1;// (cboStores.EditValue != null) ? Convert.ToInt32(cboStores.EditValue) : 1;
DataTable dtItm = itms.ExcludeNeverReceivedItems(storeId, Convert.ToInt32(lkCommodityTypes.EditValue));
string[] str = { "Item Name", "Batch No.", "Remark" };
foreach (string co in str)
{
dtBB.Columns.Add(co);
}
str = new string[] { "ItemId", "No.", "Begining Balance", "Ending Balance(SOH)", "Physical Inventory", "ID", "RecID" };
foreach (string co in str)
{
dtBB.Columns.Add(co, typeof(int));
}
int count = 1;
YearEnd yProcess = new YearEnd();
Balance bal = new Balance();
//dtDate.Value = DateTime.Now;
//DateTime dtCurent = new DateTime();// Convert.ToDateTime(dtDate.Text);
//dtDate.CustomFormat = "MM/dd/yyyy";
//dtCurent = ConvertDate.DateConverter(dtDate.Text);
ReceiveDoc recDoc = new ReceiveDoc();
int month = 2;
int year = 2003;
YearEnd yEnd = new YearEnd();
bool BalanceExists = (yProcess.DoesBalanceExist(year, storeId, false));
//int mon = (year == dtCurent.Year) ? dtCurent.Month : 10;
foreach (DataRow dr in dtItm.Rows)
{
string itemName = dr["ItemName"].ToString() + " - " + dr["DosageForm"].ToString() + " - " + dr["Strength"].ToString();
int itemID = Convert.ToInt32(dr["ID"]);
Int64 soh = bal.GetSOH(Convert.ToInt32(dr["ID"]), storeId, month, year);
Int64 bbal = yEnd.GetBBalance(year, storeId, Convert.ToInt32(dr["ID"]), month);
yProcess.GetBalanceByItemId(year, storeId, Convert.ToInt32(dr["ID"]));
Int64 BB = (yProcess.RowCount > 0) ? yProcess.BBalance : bbal;
Int64 EB = ((yProcess.RowCount > 0 && yProcess.EBalance != 0) ? yProcess.EBalance : soh);
string Phy = (yProcess.RowCount > 0) ? yProcess.PhysicalInventory.ToString() : "";
int id = (yProcess.RowCount > 0) ? yProcess.ID : 0;
string remark = (yProcess.RowCount > 0) ? yProcess.Remark : "";
//object[] obj = {Convert.ToInt32(dr["ID"]),count,itemName,"",BB,((EB != 0)?EB.ToString("#,###"):"0"),Phy,remark,id,-1};
//dtBB.Rows.Add(obj);
DataRowView drv = dtBB.DefaultView.AddNew();
drv["ItemId"] = dr["ID"];
drv["No."] = count;
drv["Item Name"] = itemName;
drv["Begining Balance"] = BB;
drv["Ending Balance(SOH)"] = EB;
if (Phy != "")
{
drv["Physical Inventory"] = Phy;
}
drv["RecID"] = -1;
drv["Remark"] = remark;
count++;
if (!BalanceExists)
{
// this is the wierdest fixer ever
int theLastBalance = 0;
//DataTable dtBatchs = recDoc.GetBatchWithValue(storeId, Convert.ToInt32(dr["ID"]), dtCurent);
//foreach (DataRow drBatch in dtBatchs.Rows)
//{
// if (drBatch["QuantityLeft"] != DBNull.Value && Convert.ToInt64(drBatch["QuantityLeft"]) != 0)
// {
// drv = dtBB.DefaultView.AddNew();
// drv["Item Name"] = ">>";
// drv["Batch No."] = drBatch["BatchNo"];
// drv["Ending Balance(SOH)"] = Convert.ToInt64(drBatch["QuantityLeft"]);
// theLastBalance += Convert.ToInt32(drBatch["QuantityLeft"]);
// drv["RecID"] = drBatch["ID"];
// }
//}
//try
//{
// if ((theLastBalance - EB) != 0)
// {
// int ID = Convert.ToInt32(dtBatchs.Rows[dtBatchs.Rows.Count - 1]);
// ReceiveDoc rd = new ReceiveDoc();
// rd.LoadByPrimaryKey(ID);
// rd.QuantityLeft -= (theLastBalance - EB);
// rd.Quantity -= theLastBalance;
// if (rd.QuantityLeft < 0)
// {
// rd.QuantityLeft = 0;
// rd.Out = true;
// if (rd.Quantity < 0)
// {
// rd.Quantity = 0;
// }
// }
// else
// {
// rd.Out = false;
// }
// rd.Save();
// }
//}
//catch
//{
// ReceiveDoc rd = new ReceiveDoc();
// rd.GetLastReceivedBatchAfterIssue(storeId, itemID);
// rd.Quantity -= (theLastBalance - EB);
// rd.QuantityLeft -= (theLastBalance - EB);
// rd.Save();
//};
}
}
}
/// <summary>
/// Loads a form to the panel
/// </summary>
/// <param name="tag">The tag of the button - Here is stored what type of form is supposed to be opened</param>
private void LoadForm(string tag)
{
var yEnd = new YearEnd();
if (yEnd.InventoryRequired(false))
{
switch (VisibilitySetting.HandleUnits)
{
case 1:
yEnd.GenerateAutomaticInventory();
break;
case 2:
yEnd.GenerateAutomaticInventoryByUnit();
break;
case 3:
yEnd.GenerateAutomaticInventoryByUnit();
break;
}
}
Form frm;
switch (tag)
{
case "Receives":
frm = new ReceivingForm();
AddTab("Receiving Form", frm);
break;
case "Issues":
frm = new IssueForm();
AddTab("Issue Form", frm);
break;
case "AMCs":
frm = new AMCView();
AddTab("AMC Report", frm);
break;
case "menuItemPriceOnlyReport":
frm = new ItemPriceOnlyReport();
AddTab("Item Price Only", frm);
break;
case "Facility Settings":
frm = new Hospital();
AddTab("Facility Settings", frm);
break;
case "Drug List":
frm = new ManageItems();
AddTab("Manage Drug List", frm);
break;
case "Supplies List":
//frm = new ManageItems();
frm = new ManageSupplies();
AddTab("Manage Supplies List", frm);
break;
case "Item Consolidator":
//frm = new ManageItems();
frm = new ItemConsolidator();
AddTab("Update Items List From The Directory Service", frm);
break;
case "Customize Druglist":
frm = new CustomDrugList();
AddTab("Customize Drug List", frm);
break;
case "System Settings":
frm = new SystemSetting();
AddTab("System Settings", frm);
break;
case "Facility Details":
frm = new HospitalSettings();
AddTab("Facility Details", frm);
break;
case "User Accounts":
frm = new UserAccounts();
AddTab("Manage Users", frm);
break;
case "Pipeline":
frm = new Pipeline();
AddTab("Pipeline", frm);
break;
case "Change Password":
frm = new ChangePassword(UserId);
AddTab("Change Password", frm);
break;
case "Transfer Log":
frm = new LogTransfer();
AddTab("Transfer Log", frm);
break;
case "VRF Form":
frm = new vrfmainForm();
AddTab("Vaccine Requistion and Report Form", frm);
break;
case "Losses/Adjustment":
frm = new LossesAdjustment();
AddTab("Losses and Adjustment", frm);
break;
case "Receive Log":
frm = new LogReceive();
AddTab("Receive Transaction Log", frm);
break;
case "Issue Log":
frm = new LogIssues();
AddTab("Issue Transaction Log", frm);
break;
case "Adjustment Log":
frm = new LogAdjustment();
AddTab("Loss / Adjustment Transaction Log", frm);
break;
case "Inventory Log":
frm = new LogInventory();
AddTab("Inventory Log", frm);
break;
case "Stock Status":
frm = new ItemReport();
AddTab("Stock Status", frm);
break;
case "Over Stocked":
frm = new OtherItemReport("Over Stocked");
AddTab("Over Stock Items", frm);
break;
case "Transfers":
frm = new TransferForm();
AddTab("Transfer Form", frm);
break;
case "Stock Out":
frm = new OtherItemReport("Stock Out");
AddTab("Stocked Out Items", frm);
break;
case "ConsumptionTrend":
frm = new ConsumptionTrendReport();
AddTab("Consumption Trend", frm);
break;
case "Issues By Receiving Unit":
frm = new IssuesByDep();
AddTab("Issues By Receiving Unit", frm);
break;
case "Expired Products":
frm = new ExpiredProducts();
AddTab("Expired Products", frm);
break;
case "Near Expiry":
frm = new NearlyExpired();
AddTab("Near Expiry Products", frm);
break;
case "SOH Trend":
frm = new SOHTrend();
AddTab("SOH Trend", frm);
break;
case "Receive Trend":
frm = new ReceiveTrend();
AddTab("Receive Trend", frm);
break;
case "Balance":
frm = new BalanceReport();
AddTab("Balance", frm);
break;
case "Summary Report":
frm = new GeneralReport();
AddTab("Summary Report", frm);
break;
case "Cost Summary":
frm = new GeneralCostChart();
AddTab("Cost Summary", frm);
break;
case "Wastage Rate":
frm = new WastageRate();
AddTab("Wastage Rate", frm);
break;
case "Summary Chart":
frm = new GeneralChart();
AddTab("General Chart", frm);
break;
case "Activity Log Reports":
frm = new ActivityLogReports();
AddTab("Activity Log", frm);
break;
case "ECLS":
frm = new ECLS();
AddTab("CS Stock Status", frm);
break;
case "Year End Process":
frm = new YearEndProcess();
AddTab("Inventory", frm);
break;
case "Default Year End Process":
frm = new YearEndProcess(true);
AddTab("Inventory", frm);
break;
case "Stock Expiry Status":
frm = new GeneralExpiryChart();
AddTab("Stock Status", frm);
break;
case "DataBase":
frm = new DatabaseActions();
AddTab("Database Actions", frm);
break;
case "PDA":
frm = new ItemReport();
AddTab("Stock Status", frm);
break;
case "Consumables List":
frm = new ManageSupplies();
AddTab("Supplies List", frm);
break;
case "RRF Form":
frm = new RRFForm();
AddTab("Report and Requisition Form", frm);
break;
case "LossReport":
frm = new ExpiredProductsReport();
AddTab("Loss / Adjustment Reporting View", frm);
break;
case "CostReport":
frm = new CostReport();
AddTab("Cost Report", frm);
break;
case "ConsumptionByUnit":
frm = new ConsumptionByUnits();
AddTab("Consumption By Dispensary Unit", frm);
break;
case "About":
Program.ShowHCMISVersionInfoMessageBox();
break;
}
}
protected void btnSave_Click(object sender, EventArgs e)
{
try
{
if (ddlStatus.SelectedValue == "D")
{
ArchiveBudget();
}
if ((Helper.PageMode)Session["YearEndPageMode"] == Helper.PageMode.New)
{
if (new YearEndDAL().GetYearEnds()
.Where(x => x.BudgetType == ddlBudgetType.SelectedValue &&
x.BudgetYear == Convert.ToInt32(ddlBudgetYear.SelectedValue)).Count() > 0)
{
((SiteMaster)this.Master).ShowMessage("Failure", "Year End already exists");
return;
}
YearEnd objYearEnd = new YearEnd();
objYearEnd.BudgetType = ddlBudgetType.SelectedValue;
objYearEnd.BudgetYear = Convert.ToInt32(ddlBudgetYear.SelectedValue);
objYearEnd.Status = ddlStatus.SelectedValue;
objYearEnd.CreatedBy = LoggedInUser.UserID;
objYearEnd.CreatedTimeStamp = DateTime.Now;
objYearEnd.ModifiedBy = LoggedInUser.UserID;
objYearEnd.ModifiedTimeStamp = DateTime.Now;
if (new YearEndDAL().InsertYearEnd(objYearEnd))
{
((SiteMaster)this.Master).ShowMessage("Success", "Year End Processed successfully");
}
else
{
((SiteMaster)this.Master).ShowMessage("Failure", "An error occurred while processing Year End");
}
}
else if ((Helper.PageMode)Session["YearEndPageMode"] == Helper.PageMode.Edit)
{
YearEnd objYearEnd = (YearEnd)Session["SelectedYearEnd"];
YearEnd pm = new YearEndDAL().GetYearEnds()
.Where(x => x.BudgetType == ddlBudgetType.SelectedValue &&
x.BudgetYear == Convert.ToInt32(ddlBudgetYear.SelectedValue)).FirstOrDefault();
if (pm != null)
{
if (pm.YearEndID != objYearEnd.YearEndID)
{
((SiteMaster)this.Master).ShowMessage("Failure", "Year End already exists");
return;
}
}
objYearEnd.BudgetType = ddlBudgetType.SelectedValue;
objYearEnd.BudgetYear = Convert.ToInt32(ddlBudgetYear.SelectedValue);
objYearEnd.Status = ddlStatus.SelectedValue;
objYearEnd.ModifiedBy = LoggedInUser.UserID;
objYearEnd.ModifiedTimeStamp = DateTime.Now;
if (new YearEndDAL().UpdateYearEnd(objYearEnd))
{
((SiteMaster)this.Master).ShowMessage("Success", "Year End Processed successfully");
}
else
{
((SiteMaster)this.Master).ShowMessage("Failure", "An error occurred while processing Year End");
}
}
GetData();
ClearPageData();
EditForm.Visible = false;
}
catch (Exception ex)
{
((SiteMaster)this.Master).ShowMessage("Error", "An error occurred", ex, true);
}
}
private void BuildStoreInventoryList(int year, int storeId, DataTable dtItm)
{
string[] str = { "Item Name", "Batch No.", "Remark", "Unit Price" };
foreach (string co in str)
{
dtBB.Columns.Add(co);
}
str = new string[] { "ItemId", "No.", "Beginning Balance", "Ending Balance(SOH)", "Physical Inventory", "ID", "RecID" };//, "Change Since Sene 30" };
foreach (string co in str)
{
dtBB.Columns.Add(co, typeof(int));
}
int count = 1;
var yProcess = new YearEnd();
var bal = new Balance();
dtDate.Value = DateTime.Now;
DateTime dtCurent = new DateTime();
dtDate.CustomFormat = "MM/dd/yyyy";
dtCurent = ConvertDate.DateConverter(dtDate.Text);
var recDoc = new ReceiveDoc();
int month = dtCurent.Month - 1;
var yEnd = new YearEnd();
foreach (DataRow dr in dtItm.Rows)//For each item
{
string itemName = dr["ItemName"].ToString() + " - " + dr["DosageForm"].ToString() + " - " + dr["Strength"].ToString();
int itemID = Convert.ToInt32(dr["ID"]);
bool BalanceExists = (yProcess.DoesBalanceExist(year, storeId, itemID, false));
//We don't want to display those items whose inventory has already been done.
if (BalanceExists)
{
continue;
}
//bereket
//Int64 soh = bal.GetSOH(Convert.ToInt32(dr["ID"]), storeId, 10, year);
var soh = bal.GetSOHOptimized(Convert.ToInt32(dr["ID"]), storeId, month, year);
var bbal = yEnd.GetBBalance(year, storeId, Convert.ToInt32(dr["ID"]), month);
yProcess.GetBalanceByItemId(year, storeId, Convert.ToInt32(dr["ID"]));
Int64 BB;
BB = yProcess.RowCount > 0 ? yProcess.BBalance : bbal;
Int64 EB;
EB = yProcess.RowCount > 0 && yProcess.EBalance != 0 ? yProcess.EBalance : soh;
//Now if the physical inventory is chosen to be default value, we set it to the ending balance of last year.
string Phy = (yProcess.RowCount > 0) ? yProcess.PhysicalInventory.ToString() : (_defaultValueToPhysicalInventory ? EB.ToString() : "");
//int id = (yProcess.RowCount > 0) ? yProcess.ID : 0;
string remark = (yProcess.RowCount > 0) ? yProcess.Remark : "";
//object[] obj = { Convert.ToInt32(dr["ID"]), count, itemName, "", BB, ((EB != 0) ? EB.ToString("#,###") : "0"), Phy, remark, id, -1 };
//dtBB.Rows.Add(obj);
DataRowView drv = dtBB.DefaultView.AddNew();
if (yProcess.RowCount > 0)
{
drv["ID"] = yProcess.ID;
}
drv["ItemId"] = dr["ID"];
drv["No."] = count;
drv["Item Name"] = itemName;
drv["Beginning Balance"] = BB;
drv["Ending Balance(SOH)"] = EB;
if (Phy != "")
{
drv["Physical Inventory"] = Phy;
}
drv["RecID"] = -1;
drv["Unit Price"] = "_";
drv["Remark"] = remark;
//drv["Change Since Sene 30"] = BLL.Balance.GetChangeAfterDate(itemID, storeId, ethioDate.EndOfFiscalYear.ToGregorianDate());
count++;
//if (!BalanceExists)
//{
int theLastBalance = 0;
DataTable dtBatchs = recDoc.GetBatchWithValue(storeId, Convert.ToInt32(dr["ID"]), dtCurent);
foreach (DataRow drBatch in dtBatchs.Rows.Cast <DataRow>().Where(drBatch => drBatch["QuantityLeft"] != DBNull.Value && Convert.ToInt64(drBatch["QuantityLeft"]) != 0))
{
drv = dtBB.DefaultView.AddNew();
drv["Item Name"] = ">>";
drv["Batch No."] = drBatch["BatchNo"];
drv["Ending Balance(SOH)"] = Convert.ToInt64(drBatch["QuantityLeft"]);
//Now if the physical inventory is chosen to be default value, we set it to the ending balance of last year.
if (_defaultValueToPhysicalInventory)
{
drv["Physical Inventory"] = drBatch["QuantityLeft"].ToString();
}
theLastBalance += Convert.ToInt32(drBatch["QuantityLeft"]);
drv["RecID"] = drBatch["ID"];
drv["Unit Price"] = drBatch["Cost"];
}
//}
}
grdYearEnd.DataSource = dtBB;
dtDate.CustomFormat = "MMMM dd, yyyy";
}
private bool SaveInventory()
{
var yEnd = new YearEnd();
var rec = new ReceiveDoc();
if (IsValid())
{
dtDate.Value = DateTime.Now;
DateTime dtCurent = new DateTime();
dtDate.CustomFormat = "MM/dd/yyyy";
dtCurent = ConvertDate.DateConverter(dtDate.Text);
int year = dtCurent.Year;
if (XtraMessageBox.Show("Are You Sure, You want to save this Transaction?", "Confirmation", MessageBoxButtons.YesNo, MessageBoxIcon.Question) == DialogResult.Yes)
{
DataTable yearEndTable = (DataTable)grdYearEnd.DataSource;
for (int i = 0; i < dtBB.Rows.Count; i++)
{
int id = 0;
int storeID = Convert.ToInt32(cboStores.EditValue);
if (dtBB.Rows[i]["ItemID"] != DBNull.Value)
{
var itemID = Convert.ToInt32(dtBB.Rows[i]["ItemID"]);
var unitID = Convert.ToInt32(dtBB.Rows[i]["UnitID"]);
id = yEnd.LoadByItemIDStoreAndYearAndUnit(itemID, storeID, year, false, unitID);
}
if (id != 0 && !ReferenceEquals(yearEndTable.Rows[i]["Physical Inventory"], string.Empty))//There is already a manual entry in the yearend table.
{
//yEnd.LoadByPrimaryKey(id);
yEnd.BBalance = Convert.ToInt64(FilterNumbers(yearEndTable.Rows[i]["Beginning Balance"].ToString()));
yEnd.EBalance = Int64.Parse(FilterNumbers(yearEndTable.Rows[i]["Ending Balance(SOH)"].ToString()), NumberStyles.AllowThousands);
yEnd.PhysicalInventory = Convert.ToInt64(FilterNumbers(yearEndTable.Rows[i]["Physical Inventory"].ToString()));
//yEnd.BatchNo = yearEndTable.Rows[i]["Batch No."].ToString();
yEnd.UnitID = Convert.ToInt32(yearEndTable.Rows[i]["UnitID"]);
yEnd.Remark = yearEndTable.Rows[i]["Remark"].ToString();
yEnd.AutomaticallyEntered = false;
yEnd.Save();
}
else//There is no entry in the yearend table under this item name that has been entered manually.
{
DataRow cRow = dtBB.Rows[i];
if (!ReferenceEquals(cRow["Physical Inventory"], string.Empty) && cRow["ItemID"] != DBNull.Value)
{
var itemID = Convert.ToInt32(cRow["ItemID"]);
var unitID = Convert.ToInt32(cRow["UnitID"]);
YearEnd.PurgeAutomaticallyEnteredInventoryForUnit(itemID, storeID, year, unitID);
yEnd.AddNew();
yEnd.ItemID = itemID;
yEnd.StoreID = storeID;
yEnd.Year = year;
yEnd.BBalance = Convert.ToInt64(cRow["Beginning Balance"]);
Int64 endBal = Convert.ToInt64(cRow["Ending Balance(SOH)"]);
yEnd.EBalance = endBal;// Convert.ToInt64(yearEndTable.Rows[i].Cells[5].Value);
if (cRow["Physical Inventory"] != DBNull.Value)
{
yEnd.PhysicalInventory = Convert.ToInt64(cRow["Physical Inventory"]);
}
yEnd.UnitID = Convert.ToInt32(cRow["UnitID"]);
yEnd.Remark = cRow["Remark"].ToString();
yEnd.AutomaticallyEntered = cRow["Physical Inventory"] == DBNull.Value;
yEnd.Save();
//long physicalInventoryTotal = 0;
//bool areAllBatchesPhyInventoryNullValue = true;
//if (endBal != yEnd.PhysicalInventory)
if (true)
{
int k = i + 1;
if (k < dtBB.Rows.Count)
{
while (Convert.ToInt32(dtBB.Rows[k]["RecID"]) != -1)
{
if (dtBB.Rows[k]["Physical Inventory"] != DBNull.Value)
{
//areAllBatchesPhyInventoryNullValue = false;
long batchPhysicalInventory =
Convert.ToInt64(dtBB.Rows[k]["Physical Inventory"]);
//physicalInventoryTotal += batchPhysicalInventory;
rec.LoadByPrimaryKey(Convert.ToInt32(dtBB.Rows[k]["RecID"]));
rec.QuantityLeft = Convert.ToInt64(batchPhysicalInventory);
rec.Remark = "Physical Inventory";
rec.UnitID = Convert.ToInt32(dtBB.Rows[k]["UnitID"]);
rec.Out = rec.QuantityLeft == 0;
rec.Save();
}
k++;
if (k >= yearEndTable.Rows.Count)
{
break;
}
}
}
}
}
}
}
XtraMessageBox.Show("Transaction Successfully Saved!", "Success", MessageBoxButtons.OK, MessageBoxIcon.Information);
return(true);
}
else
{
return(false);
}
}
else
{
return(false);
}
}
private void BtnAddBatchClick(object sender, EventArgs e)
{
if (!dxValidationProvider1.Validate())
{
return;
}
var rec = new ReceiveDoc();
var yEnd = new YearEnd();
switch (VisibilitySetting.HandleUnits)
{
case 1:
{
rec.AddNew();
rec.ItemID = _itemid;
rec.BatchNo = txtBatchNo.Text;
rec.StoreID = _storeid;
rec.ExpDate = (DateTime)dateEditExpiryDate.EditValue;
rec.Date = _date;
rec.UnitID = 0;
rec.RefNo = txtRefNo.Text;
rec.Out = false;
rec.EurDate = DateTime.Now.Subtract(TimeSpan.FromDays(35));
rec.NoOfPack = Convert.ToInt32(txtPackQty.Text);
rec.QtyPerPack = Convert.ToInt32(txtQtyPerPack.Text);
rec.Quantity = (Convert.ToInt32(txtPackQty.Text)) * (Convert.ToInt32(txtQtyPerPack.Text));
rec.QuantityLeft = (Convert.ToInt32(txtPackQty.Text)) * (Convert.ToInt32(txtQtyPerPack.Text));
rec.Cost = Convert.ToDouble(txtPrice.Text);
rec.Save();
yEnd.AddNew();
yEnd.ItemID = _itemid;
yEnd.StoreID = _storeid;
yEnd.Year = _date.Year;
yEnd.AutomaticallyEntered = true;
yEnd.BBalance = 0;
yEnd.EBalance = 0;
yEnd.Save();
}
break;
default:
{
rec.AddNew();
rec.ItemID = _itemid;
rec.BatchNo = txtBatchNo.Text;
rec.StoreID = _storeid;
rec.UnitID = _unitid;
rec.ExpDate = (DateTime)dateEditExpiryDate.EditValue;
rec.NoOfPack = Convert.ToInt32(txtPackQty.Text);
rec.Quantity = Convert.ToInt32(txtPackQty.Text);
rec.QuantityLeft = Convert.ToInt32(txtPackQty.Text);
rec.QtyPerPack = Convert.ToInt32(txtQtyPerPack.Text);
rec.Date = _date;
rec.RefNo = txtRefNo.Text;
rec.Out = false;
rec.EurDate = DateTime.Now.Subtract(TimeSpan.FromDays(35));
rec.Cost = Convert.ToDouble(txtPrice.Text);
rec.Save();
yEnd.AddNew();
yEnd.ItemID = _itemid;
yEnd.StoreID = _storeid;
yEnd.UnitID = _unitid;
yEnd.AutomaticallyEntered = true;
yEnd.BBalance = 0;
yEnd.EBalance = 0;
yEnd.Save();
}
break;
}
XtraMessageBox.Show("New Batch successfully added.", "Success");
Close();
}
