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;
}
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;
}
/// <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)
{
}
}
/// <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;
}
}
