private void barButtonItem3_ItemClick(object sender, ItemClickEventArgs e)
{
Application.DoEvents();
progressPanel1.Visible = true;
var b = new YearEndClass();
var ds = b.GetClosingYear();
int cyear = 0;
if (ds.Rows.Count == 0)
{
var f1 = new YearCloseProcess();
f1.ShowDialog();
cyear = f1._ClosingYear;
}
else
{
cyear = int.Parse(ds.Rows[0]["CYEAR"].ToString());
}
if(cyear==0) return;
var f = new TxtFileRead();
f.ValidateYearEnd(cyear);
f.ShowDialog();
if (f.iSvalid)
{
DownLoadFiles(f.Fname, f.Machineno, f.Inventoryby, f.Closingperiod);
_fname=f.Fname;
_fMachineno =f.Machineno;
_fInventoryby= f.Inventoryby;
_fClosingperiod = f.Closingperiod;
SaveDataToInventoryYear(f.Closingperiod);
barButtonItem4.Enabled = true;
}
progressPanel1.Visible =false;
}
private void simpleButton1_Click(object sender, EventArgs e)
{
//1.Check for sales Closing
//2.Check holded sales,purchase
//3.check for holded transfers
//4.Check for dayclose
//5.Check for inventory adjusted
_ClosingYear = 0;
if (spinEdit1.EditValue == null)
{
XtraMessageBox.Show("Please enter the year", "POS", MessageBoxButtons.OK, MessageBoxIcon.Information);
return;
}
if (spinEdit1.EditValue.ToString().Length < 4)
{
XtraMessageBox.Show("Please enter the year in yyyy format", "POS", MessageBoxButtons.OK,
MessageBoxIcon.Information);
return;
}
var cl = new YearEndClass();
var cnt = cl.CheckYearClosed(int.Parse(spinEdit1.EditValue.ToString()));
if(cnt > 0)
{
XtraMessageBox.Show("Year Closed already", "POS", MessageBoxButtons.OK, MessageBoxIcon.Information);
return;
}
//SELECT COUNT(*) from SALESMAIN where HOLDNO > 0
//SELECT COUNT(*) FROM SALESMAIN WHERE POSTED =1 AND DAILYCLOSED=0
//SELECT COUNT(*) FROM PURINVMAIN WHERE HOLD = 1
//SELECT COUNT(*) FROM ITEMTRANSFERMAIN WHERE HOLD = 1
if(new YearEndClass().ValidateYearClosed(1))
{
XtraMessageBox.Show("Please un-hold sales before processing year end", "POS", MessageBoxButtons.OK,
MessageBoxIcon.Information);
return;
}
if(cl.ValidateYearClosed(2))
{
XtraMessageBox.Show("Please do daily close before processing year end", "POS", MessageBoxButtons.OK,
MessageBoxIcon.Information);
return;
}
if (cl.ValidateYearClosed(3))
{
XtraMessageBox.Show("Please un-hold the purhcase invoice before processing year end", "POS", MessageBoxButtons.OK,
MessageBoxIcon.Information);
return;
}
if (cl.ValidateYearClosed(4))
{
XtraMessageBox.Show("Please un-hold the transfers before processing year end", "POS", MessageBoxButtons.OK,
MessageBoxIcon.Information);
return;
}
if(MessageBox.Show("Are you sure to close the year","POS",MessageBoxButtons.YesNo,MessageBoxIcon.Question)==DialogResult.Yes)
{
if (cl.CheckYearCloseProcessStart(int.Parse(spinEdit1.EditValue.ToString())))
{
_ClosingYear = int.Parse(spinEdit1.EditValue.ToString());
Dispose();
}
if (cl.DoCreateYearClosed(int.Parse(spinEdit1.EditValue.ToString())) == "1")
{
XtraMessageBox.Show("System ready for physical inventory", "POS", MessageBoxButtons.OK,
MessageBoxIcon.Information);
_ClosingYear = int.Parse(spinEdit1.EditValue.ToString());
Dispose();
}
else
{
XtraMessageBox.Show("Error", "POS", MessageBoxButtons.OK,
MessageBoxIcon.Information);
}
}
}
void SaveDataToInventoryYear(int clo)
{
var t = new YearEndClass().SaveDataToInventoryYear(_dsyearend);
if (t == "1")
{
var b = new YearEndClass();
_dsyearend = b.LoadYearEndInventory(clo);
yearEndInventoryBindingSource.DataSource = _dsyearend;
//gridControl1.DataSource = _dsyearend;
}
}
private void barButtonItem11_ItemClick(object sender, ItemClickEventArgs e){
progressPanel1.Visible = true;
foreach (DataRow dr in _dsyearend.Rows)
{
if (dr["ISADDED"].ToString()== bool.TrueString)
{
dr["INSTOCK"] = new YearEndClass().GetInStockFromBackUp(dr["itemno"].ToString(), _fClosingperiod);
var dt = new YearEndClass().GetMaxExpirtyDt(dr["itemno"].ToString(), _fClosingperiod);
if (!String.IsNullOrEmpty(dt))
{
DateTime ndt = DateTime.Parse(dt);
dr["EXPDATE"] = ndt;
// txtexpdate.Text = ndt.Month + " - " + ndt.Year;
}
}
}
progressPanel1.Visible = false;
}
private void barButtonItem8_ItemClick(object sender, ItemClickEventArgs e)
{
yearEndInventoryBindingSource.RemoveFilter();
if(dateEdit1.EditValue==null)
{
XtraMessageBox.Show("Please select the opening year" ,"POS",MessageBoxButtons.OK, MessageBoxIcon.Information);
return;
}
var bl = new YearEndClass();
if(bl.GetCountNonTrasfered() > 0)
{
XtraMessageBox.Show("Some items not transfered please check and close the year", "POS",
MessageBoxButtons.OK, MessageBoxIcon.Information);
}
else
{
Application.DoEvents();
progressPanel1.Visible = true;
var ret = bl.DoUpdateOpeningStock(dateEdit1.DateTime, _fClosingperiod);
if (ret == "1")
{
XtraMessageBox.Show("Inventory updated", "POS",MessageBoxButtons.OK, MessageBoxIcon.Information);
}
else
{
XtraMessageBox.Show(ret, "POS",MessageBoxButtons.OK, MessageBoxIcon.Information);
}
progressPanel1.Visible = false;
}
}
void UpLoadInventory()
{
var whid = lookupfrom.EditValue.ToString();
var s = new StoreManager().GetStoreType(whid);
string storetype = "S";
if (s.IndexOf("S") == -1)
{
storetype = "P";
}
var s1 = new YearEndClass().DoUpdateInventory(_dsyearend, storetype, whid);
if (s1 == "1")
{
XtraMessageBox.Show("Inventory Updated", "POS", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
else
{
XtraMessageBox.Show(s1, "POS", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
private void YearEndProcess_Load(object sender, EventArgs e)
{
var ds = ClsGetData.GetItemGroup();
repositoryItemLookUpEdit1.DataSource = ds;
var dsW = ClsGetData.GetStoreList();
var bsW = new BindingSource(dsW, "") { Filter = "COMPANY = '" + Utils.Company + "'" };
lookupfrom.Properties.DataSource = bsW;
var b = new YearEndClass();
var ds1 = b.GetClosingYear();
if (ds1.Rows.Count > 0)
{
if (_fClosingperiod == 0)
_fClosingperiod = int.Parse(ds1.Rows[0]["CYEAR"].ToString());
_dsyearend = b.LoadYearEndInventory(int.Parse(ds1.Rows[0]["CYEAR"].ToString()));
}
_GridHeading = "Physical Inventory Report";
yearEndInventoryBindingSource.DataSource = _dsyearend;// gridControl1.DataSource = _dsyearend;
txtstock.Properties.Mask.EditMask = "\\d+";
txtstock.Properties.Mask.MaskType = MaskType.RegEx;
}
