private void Delete()
{
try
{
FormHelpers.CursorWait(true);
var msg = "Deleting";
if (MessageHelpers.ShowQuestion("Are you sure you want to delete record?") == System.Windows.Forms.DialogResult.Yes)
{
var yearused = UserSettings.LogInYear;
var partno = mgridListVP.Rows[mgridListVP.SelectedCells[0].RowIndex].Cells["colPartNoVP"].Value.ToString();
vp = vpbal.GetByID(Convert.ToInt32(yearused), partno.ToString());;
if (vpbal.Delete(vp))
{
MessageHelpers.ShowInfo(msg + " Successful!");
RefreshGrid();
PageManager(1);
}
else
{
MessageHelpers.ShowWarning(msg + " Failed!");
}
}
}
catch (Exception ex)
{
MessageHelpers.ShowError(ex.Message);
}
finally
{
FormHelpers.CursorWait(false);
}
}
private void AssignRecord(Boolean IsSave)
{
try
{
if (IsSave)
{
tbl_000_H_VP existvp = new tbl_000_H_VP();
existvp = vpbal.GetAll().Where(w => w.YEARUSED == UserSettings.LogInYear && w.PartNo == mtxtPartNo.Text).FirstOrDefault();
if (existvp == null)
{
vp.YEARUSED = UserSettings.LogInYear;
vp.PartNo = mtxtPartNo.Text;
vp.CreatedDate = DateTime.Now;
vp.CreatedBy = UserSettings.Username;
vp.IsCopied = false;
vp.CopyDate = DateTime.Now;
vp.IsImported = false;
vp.ImportDate = DateTime.Now;
vp.ImportBy = UserSettings.Username;
}
vp.PartName = mtxtPartName.Text;
vp.SourceData = mtxtSourceData.Text;
vp.IsLocked = mcbLocked.Checked;
vp.UpdatedDate = DateTime.Now;
vp.UpdatedBy = UserSettings.Username;
}
else
{
vp = vpbal.GetByID(yearused, partno);
if (vp != null)
{
mtxtPartNo.Text = vp.PartNo;
mtxtPartName.Text = vp.PartName;
mtxtSourceData.Text = vp.SourceData;
mcbLocked.Checked = vp.IsLocked;
vp.UpdatedDate = DateTime.Now;
vp.UpdatedBy = UserSettings.Username;
}
}
}
catch (Exception ex)
{
throw ex;
}
}
