/// <summary> /// Prepare all lookups /// </summary> /// <param name="sender"></param> /// <param name="e"></param> private void ManageItems_Load(object sender, EventArgs e) { var stor = new Stores(); stor.GetActiveStores(); cboStores.Properties.DataSource = stor.DefaultView; cboStores.ItemIndex = 0; var rec = new DisposalReasons(); var dtDis = rec.GetAvailableReasons(); cboReasons.Properties.DataSource = dtDis.DefaultView; reasonBindingSource.DataSource = dtDis.DefaultView; // cboReasons.ItemIndex = 0; var itemunit = new ItemUnit(); var units = itemunit.GetAllUnits(); unitbindingSource.DataSource = units.DefaultView; var unitcolumn = ((GridView)gridAdjustments.MainView).Columns[10]; switch (VisibilitySetting.HandleUnits) { case 1: unitcolumn.Visible = false; break; case 2: unitcolumn.Visible = true; break; default: unitcolumn.Visible = true; break; } try { //CALENDAR: var dtDate = new CalendarLib.DateTimePickerEx { CustomFormat = "MM/dd/yyyy", Value = DateTime.Now }; var dr = (DataRowView)lstTree.GetDataRecordByNode(lstTree.Nodes[0].FirstNode); if (dr == null) return; var disp = new Disposal(); if (dr["ParentID"] == DBNull.Value) { var dt1 = new DateTime(Convert.ToInt32(dr["ID"]) - 1, 11, 1); var dt2 = new DateTime(Convert.ToInt32(dr["ID"]), 11, 1); dtRec = disp.GetTransactionByDateRange(Convert.ToInt32(cboStores.EditValue),dt1,dt2); lblAdjDate.Text = dr["RefNo"].ToString(); } else { dtRec = disp.GetDocumentByRefNo(dr["RefNo"].ToString(), Convert.ToInt32(cboStores.EditValue), dr["Date"].ToString()); lblAdjDate.Text = Convert.ToDateTime(dr["Date"]).ToString("MM dd,yyyy"); } gridAdjustments.DataSource = dtRec; } catch (Exception ex) { } }
private void dtTo_ValueChanged(object sender, EventArgs e) { //CALENDAR: Disposal adj = new Disposal(); DataTable dtRec; dtFrom.CustomFormat = "MM/dd/yyyy"; dtTo.CustomFormat = "MM/dd/yyyy"; DateTime dteFrom = ConvertDate.DateConverter(dtFrom.Text); DateTime dteTo = ConvertDate.DateConverter(dtTo.Text); dtRec = dteFrom < dteTo ? adj.GetTransactionByDateRange(Convert.ToInt32(cboStores.EditValue), dteFrom,dteTo) : adj.GetAllTransaction(Convert.ToInt32(cboStores.EditValue)); gridAdjustments.DataSource = dtRec; }
private void lstTree_FocusedNodeChanged(object sender, DevExpress.XtraTreeList.FocusedNodeChangedEventArgs e) { var dtDate = new DateTimePickerEx { CustomFormat = "MM/dd/yyyy", Value = DateTime.Now }; DateTime dtCurrent = ConvertDate.DateConverter(dtDate.Text); var dr = (DataRowView)lstTree.GetDataRecordByNode(lstTree.FocusedNode); if (dr == null) return; var adj = new Disposal(); DataTable dtRec; if (dr["ParentID"] == DBNull.Value) { int yr = ((dtCurrent.Month > 10) ? dtCurrent.Year : dtCurrent.Year - 1); DateTime dt1 = new DateTime(Convert.ToInt32(dr["ID"]) - 1, 11, 1); DateTime dt2 = new DateTime(Convert.ToInt32(dr["ID"]), 11, 1); dtRec = adj.GetTransactionByDateRange(Convert.ToInt32(cboStores.EditValue), dt1, dt2); lblAdjDate.Text = dr["RefNo"].ToString(); } else { dtRec = adj.GetDocumentByRefNo(dr["RefNo"].ToString(), Convert.ToInt32(cboStores.EditValue), dr["Date"].ToString()); lblAdjDate.Text = Convert.ToDateTime(dr["Date"]).ToString("MM dd,yyyy"); } gridAdjustments.DataSource = dtRec; }
/// <summary> /// Delete a row of adjustmen /// </summary> /// <param name="sender"></param> /// <param name="e"></param> private void DeleteToolStripMenuItem_Click(object sender, EventArgs e) { var us = new User(); var userID = MainWindow.LoggedinId; us.LoadByPrimaryKey(userID); var dataRow = gridView1.GetFocusedDataRow(); if (dataRow == null) return; if (us.UserName != "admin") { XtraMessageBox.Show("You don't have the privilege to update reference number!", "Caution"); return; } //get the primary key of the row var ID = Convert.ToInt32(dataRow["ID"]); var disposal = new Disposal(); var receiveDoc = new ReceiveDoc(); //Retrieve the adjustment with the value of the primary key(id) disposal.LoadByPrimaryKey(ID); int recieveID = disposal.RecID; receiveDoc.LoadByPrimaryKey(recieveID); if (XtraMessageBox.Show("Are You Sure, You want to delete this?", "Confirmation", MessageBoxButtons.YesNo, MessageBoxIcon.Question) == DialogResult.Yes) { //check for losss if (disposal.Losses) //it was loss { receiveDoc.LoadByPrimaryKey(recieveID); var s = receiveDoc.Quantity; receiveDoc.Quantity = receiveDoc.Quantity + disposal.Quantity; receiveDoc.QuantityLeft = receiveDoc.QuantityLeft + disposal.Quantity; if (receiveDoc.Out) receiveDoc.Out = false; disposal.Quantity = 0; } else // it was adjustment { receiveDoc.LoadByPrimaryKey(recieveID); var s = receiveDoc.Quantity; receiveDoc.Quantity = receiveDoc.Quantity - disposal.Quantity; receiveDoc.QuantityLeft = receiveDoc.QuantityLeft - disposal.Quantity; if (receiveDoc.Quantity == 0) receiveDoc.Out = true; disposal.Quantity = 0; } // proceed deletion and make the necessary changes on the database tables. DisposalDelete ddel; AddDeletedDisposal(disposal, out ddel); receiveDoc.Save(); disposal.MarkAsDeleted(); disposal.Save(); //Repopulate the grid DataTable dtRec; dtFrom.CustomFormat = "MM/dd/yyyy"; dtTo.CustomFormat = "MM/dd/yyyy"; DateTime from = ConvertDate.DateConverter(dtFrom.Text); DateTime to = ConvertDate.DateConverter(dtTo.Text); dtRec = disposal.GetTransactionByDateRange(Convert.ToInt32(cboStores.EditValue), from, to); gridAdjustments.DataSource = dtRec; } }