private void PopupModelControl_Load(object sender, EventArgs e)
{
if (_dealer != null)
{
CB_PMC_SelectDealer.Text = _dealer.Code;
}
if (_dealerList != null)
{
LPMC_Title.Text = "ADD New Collection";
BPMC_Add.Text = "Add";
_collection = new SalesAndCollectionModel
{
Id = Guid.NewGuid().ToString("N"),
Sl = (SalesAndCollectionManager.GetAllSalesAndCollectionsCount() + 1).ToString(),
DealerName = "",
Address = "",
Contact = "",
DealerCode = "",
Date = DTP_PMC_Date.Value.Date,
IC_NO = "",
MR_NO = "",
OpeningBalance = null,
SalesAmount = 0,
CollectionAmount = 0,
ClosingBalance = null,
Remarks = "",
SyncType = "Collection"
};
}
BindObjectDataToInterface();
}
private void BSAC_DeleteSOC_Click(object sender, EventArgs e)
{
if (_tempedSalesAndCollections.Count > 0)
{
DataGridViewRow row = this.DGV_SAC_SalesAndCollectionList.SelectedRows[0];
if (row != null)
{
DialogResult dialogResult = MessageBox.Show(" Are you sure? ", "Confirm Delete?", MessageBoxButtons.YesNo);
if (dialogResult == DialogResult.Yes)
{
SalesAndCollectionModel soc = row.DataBoundItem as SalesAndCollectionModel;
if (CKB_GroupBy.Checked)
{
if (CB_SAC_DealerCode.Text.ToLower().Equals("any"))
{
MessageBox.Show("Please select a Dealer code!");
}
else
{
if (SalesAndCollectionManager.DeleteSaleOrCollection(soc, true))
{
MessageBox.Show("All sales and collections for Dealer :" + soc.DealerName + "(" + soc.DealerCode + ") on Date : " + soc.Date + " has been Deleated!");
BindAllFilters();
}
else
{
MessageBox.Show("Error! Something went wrong while Deleting!!");
}
}
}
else
{
if (SalesAndCollectionManager.DeleteSaleOrCollection(soc, false))
{
MessageBox.Show("Deleated Successfully!");
BindAllFilters();
}
else
{
MessageBox.Show("Error! Something went wrong while Deleting!!");
}
}
}
else if (dialogResult == DialogResult.No)
{
//do something else
}
}
else
{
MessageBox.Show("Select a row to delete!");
}
}
else
{
MessageBox.Show("List is Empty :(");
}
}
private void BackgroundWorker_DoWork(object sender, DoWorkEventArgs e)
{
bool isSuccess = false;
if (isPartyLedger)
{
isSuccess = SalesAndCollectionManager.ExportAsPartyLedgerExcell(_fullPath, _tempedSalesAndCollections);
}
else
{
isSuccess = SalesAndCollectionManager.ExportAsDailyExcell(_fullPath, _tempedSalesAndCollections);
}
if (isSuccess)
{
MessageBox.Show("File has been saved successfully");
}
else
{
MessageBox.Show("Error! Something went wrong while saving file!!");
}
}
private void BindInterfaceDataToObject()
{
var selectedDealer = _dealerList.Where(x => x.Code.Equals(CB_PMC_SelectDealer.Text)).FirstOrDefault();
_collection.DealerName = selectedDealer.DealerName;
_collection.DealerCode = selectedDealer.Code;
_collection.Address = selectedDealer.Address;
_collection.Contact = selectedDealer.Contact;
_collection.MR_NO = TB_PMC_MR_No.Text;
_collection.IC_NO = TB_PMC_IC_No.Text;
_collection.CollectionAmount = Convert.ToInt32(TB_PMC_CollectionAmount.Text);
_collection.Remarks = TB_PMC_Remark.Text;
_collection.Date = DTP_PMC_Date.Value.Date;
if (_collection.CollectionAmount <= 0
//|| _collection.MR_NO.Equals("")
//|| _collection.IC_NO.Equals("")
)
{
MessageBox.Show("Make sure Collection amount is not 0 ");
}
else
{
ConfirmChange();
}
void ConfirmChange()
{
DialogResult dialogResult = MessageBox.Show(BPMC_Add.Text + " Collection? ", "Confirm Change?", MessageBoxButtons.YesNo);
if (dialogResult == DialogResult.Yes)
{
if (_collection != null)
{
if (BPMC_Add.Text.Equals("Add"))
{
if (SalesAndCollectionManager.AddNewSale(_collection))
{
MessageBox.Show("Collection Added successfully!");
ReloadDealerControl();
}
else
{
MessageBox.Show("Error! Something went wrong!!");
}
}
}
else
{
}
}
else if (dialogResult == DialogResult.No)
{
//do something else
}
void ReloadDealerControl()
{
_hPanel.Controls.Clear();
_salesAndCollectionControl = new SalesAndCollectionControl(_hPanel, _vPanel);
_hPanel.Controls.Add(_salesAndCollectionControl);
_salesAndCollectionControl.Dock = DockStyle.Fill;
_salesAndCollectionControl.Show();
_popUpForm.Close();
}
}
}
private void BindAllFilters()
{
var filteredSalesAndCollections = new List <SalesAndCollectionModel>();
if (string.IsNullOrEmpty(CB_SAC_DealerCode.Text))
{
CB_SAC_DealerCode.Text = "Any";
CB_SAC_DealerCode.Items.Add("Any");
CB_SAC_DealerCode.Items.AddRange(_dealerList.Select(x => x.Code).ToArray());
}
else if (CB_SAC_DealerCode.Items.Count <= 1)
{
CB_SAC_DealerCode.Items.Add("Any");
CB_SAC_DealerCode.Items.AddRange(_dealerList.Select(x => x.Code).ToArray());
}
if (CB_SAC_DealerCode.Text.ToLower().Equals("any"))
{
_dealer = null;
}
else
{
if (!string.IsNullOrEmpty(CB_SAC_DealerCode.Text))
{
_dealer = DealerManager.FindDealer(CB_SAC_DealerCode.Text);
}
}
if (_dealer != null)
{
CB_SAC_DealerCode.Text = _dealer.Code;
LSAC_PartyName.Visible = true;
LSAC_PartyAddress.Visible = true;
LSAC_PartyContact.Visible = true;
TB_SAC_PartyName.Visible = true;
TB_SAC_PartyAddress.Visible = true;
TB_SAC_PartyContact.Visible = true;
TB_SAC_PartyName.Text = _dealer.DealerName;
TB_SAC_PartyAddress.Text = _dealer.Address;
TB_SAC_PartyContact.Text = _dealer.Contact;
//TB_SAC_PartyName.Enabled = false;
//TB_SAC_PartyAddress.Enabled = false;
//TB_SAC_PartyContact.Enabled = false;
}
else
{
LSAC_PartyName.Visible = false;
LSAC_PartyAddress.Visible = false;
LSAC_PartyContact.Visible = false;
TB_SAC_PartyName.Visible = false;
TB_SAC_PartyAddress.Visible = false;
TB_SAC_PartyContact.Visible = false;
TB_SAC_PartyName.Text = "";
TB_SAC_PartyAddress.Text = "";
TB_SAC_PartyContact.Text = "";
}
if (CKB_GroupBy.Checked)
{
if (CB_SAC_DealerCode.Text.ToLower().Equals("any"))
{
filteredSalesAndCollections = SalesAndCollectionManager.EverydaySalesAndCollections();
}
else
{
filteredSalesAndCollections = SalesAndCollectionManager.EverydaySalesAndCollections(CB_SAC_DealerCode.Text);
}
}
else
{
if (CB_SAC_DealerCode.Text.ToLower().Equals("any"))
{
filteredSalesAndCollections = SalesAndCollectionManager.GetAllSalesAndCollections();
}
else
{
filteredSalesAndCollections = SalesAndCollectionManager.GetSalesAndCollections(CB_SAC_DealerCode.Text);
}
}
if (filteredSalesAndCollections.Count > 0)
{
if (!string.IsNullOrEmpty(TB_SAC_Search.Text))
{
filteredSalesAndCollections = SearchResult(TB_SAC_Search.Text, filteredSalesAndCollections);
}
if (CB_SAC_TimePeriod.Text.Equals("Custom"))
{
filteredSalesAndCollections = filteredSalesAndCollections.Where(x => x.Date >= DTP_SAC_FromDate.Value && x.Date <= DTP_SAC_ToDate.Value).ToList();
}
else if (CB_SAC_TimePeriod.Text.Equals("Today"))
{
DTP_SAC_FromDate.Value = DateTime.Today;
DTP_SAC_ToDate.Value = DTP_SAC_FromDate.Value;
filteredSalesAndCollections = filteredSalesAndCollections.Where(x => x.Date > DTP_SAC_FromDate.Value.AddDays(-1) && x.Date <= DTP_SAC_ToDate.Value).ToList();
}
else if (CB_SAC_TimePeriod.Text.Equals("Yesterday"))
{
DTP_SAC_FromDate.Value = DateTime.Today.AddDays(-1);
DTP_SAC_ToDate.Value = DTP_SAC_FromDate.Value;
filteredSalesAndCollections = filteredSalesAndCollections.Where(x => x.Date > DTP_SAC_FromDate.Value.AddDays(-1) && x.Date <= DTP_SAC_ToDate.Value).ToList();
}
else if (CB_SAC_TimePeriod.Text.Equals("Weekly"))
{
DTP_SAC_FromDate.Value = DateTime.Today.AddDays(-7);
DTP_SAC_ToDate.Value = DateTime.Today;
filteredSalesAndCollections = filteredSalesAndCollections.Where(x => x.Date > DTP_SAC_FromDate.Value && x.Date <= DTP_SAC_ToDate.Value).ToList();
}
else if (CB_SAC_TimePeriod.Text.Equals("Monthly"))
{
DTP_SAC_FromDate.Value = DateTime.Today.AddDays(-30);
DTP_SAC_ToDate.Value = DateTime.Today;
filteredSalesAndCollections = filteredSalesAndCollections.Where(x => x.Date > DTP_SAC_FromDate.Value && x.Date <= DTP_SAC_ToDate.Value).ToList();
}
else if (CB_SAC_TimePeriod.Text.Equals("This Month"))
{
DateTime date = DateTime.Today;
DTP_SAC_FromDate.Value = new DateTime(date.Year, date.Month, 1);
DTP_SAC_ToDate.Value = DTP_SAC_FromDate.Value.AddMonths(1).AddDays(-1);
filteredSalesAndCollections = filteredSalesAndCollections.Where(x => x.Date >= DTP_SAC_FromDate.Value && x.Date <= DTP_SAC_ToDate.Value).ToList();
}
else if (CB_SAC_TimePeriod.Text.Equals("Last Month"))
{
DateTime date = DateTime.Today;
DTP_SAC_FromDate.Value = new DateTime(date.Year, date.AddMonths(-1).Month, 1);
DTP_SAC_ToDate.Value = DTP_SAC_FromDate.Value.AddMonths(1).AddDays(-1);
filteredSalesAndCollections = filteredSalesAndCollections.Where(x => x.Date >= DTP_SAC_FromDate.Value && x.Date <= DTP_SAC_ToDate.Value).ToList();
}
else if (CB_SAC_TimePeriod.Text.Equals("Default"))
{
DTP_SAC_FromDate.Value = new DateTime(2020, 1, 1);
DTP_SAC_ToDate.Value = DateTime.Today;
filteredSalesAndCollections = filteredSalesAndCollections.Where(x => x.Date >= DTP_SAC_FromDate.Value && x.Date <= DTP_SAC_ToDate.Value).ToList();
}
var allDates = filteredSalesAndCollections.Select(x => x.Date).Distinct().ToList();
allDates.RemoveAll(item => item == null);
if (CKB_Ascending.Checked)
{
allDates = allDates.OrderBy(x => x.Value).ToList();
}
else
{
allDates = allDates.OrderByDescending(x => x.Value).ToList();
}
var mapSalesAndCollections = new List <SalesAndCollectionModel>();
foreach (var date in allDates)
{
var thatDaysHistory = filteredSalesAndCollections.Where(x => x.Date == date).ToList();
var allDealerForThatDay = thatDaysHistory.Select(x => x.DealerCode).Distinct().ToList();
foreach (var dealerCode in allDealerForThatDay)
{
var dealerHistoryForThatDay = thatDaysHistory.Where(x => x.DealerCode.Equals(dealerCode)).ToList();
mapSalesAndCollections.AddRange(dealerHistoryForThatDay);
}
}
filteredSalesAndCollections = mapSalesAndCollections;
int count = 1;
foreach (var soc in filteredSalesAndCollections)
{
soc.Sl = (count++).ToString();
}
}
if (filteredSalesAndCollections != null)
{
BindDataTable(filteredSalesAndCollections);
_tempedSalesAndCollections = filteredSalesAndCollections;
}
isTimePeriodChanged = false;
}
private void BackgroundWorker_RunWorkerCompleted(object sender, RunWorkerCompletedEventArgs e)
{
IC_ProgressPanel.Visible = false;
InvoiceProgressBar.Visible = false;
_vPanel.Enabled = true;
_hPanel.Enabled = true;
void UpdateProductStock()
{
foreach (var item in _invoicePage.AllProducts)
{
var product = _productList.Where(x => x.ProductCode.Equals(item.ProductCode)).FirstOrDefault();
if (product != null)
{
if (_itemList != null)
{
var previousItem = _itemList.Where(x => x.ProductCode.Equals(item.ProductCode)).FirstOrDefault();
product.StockAvailable += previousItem.Quantity;
}
product.StockAvailable -= item.Quantity;
}
}
ProductManager.UpdateAllProducts(_productList);
}
void SaveInvoiceLogFile()
{
if (!string.IsNullOrEmpty(_invoicePage.CurrentLogFile))
{
_invoicePage.PreviousLogFile = _invoicePage.CurrentLogFile;
FileSystemUtility.DeleteFile(_invoicePage.CurrentLogFile);
}
Files invoiceLog = new Files();
invoiceLog.FileLocation = Environment.GetFolderPath(Environment.SpecialFolder.MyDocuments) + @"\Invoiceasy\InvoiceLog";
invoiceLog.FileName = "InvoiceLog-" + _invoicePage.No + "_" + DTP_IC_Date.Value.ToString("dd MMMM yyyy") + " " + DateTime.Now.ToString("HH-mm-ss") + ".txt";
_invoicePage.CurrentLogFile = invoiceLog.FileLocation + @"\" + invoiceLog.FileName;
invoiceLog.FileText = JsonConvert.SerializeObject(_invoicePage);
FileSystemUtility.DeleteFile(_invoicePage.CurrentLogFile);
FileSystemUtility.Initialize(true, invoiceLog);
FileSystemUtility.WriteFile();
var logFilePath = Environment.GetFolderPath(Environment.SpecialFolder.MyDocuments) + @"\Invoiceasy" + @"\InvoiceItems\" + "Invoice-" + _invoicePage.No + "_" + "ItemList_" + DTP_IC_Date.Value.ToString("dd MMMM yyyy HH-mm-ss") + ".txt";
FileSystemUtility.CreateFolder(Environment.GetFolderPath(Environment.SpecialFolder.MyDocuments) + @"\Invoiceasy" + @"\InvoiceItems");
CsvHelperUtility.WriteDataToFile <ItemModel>(true, logFilePath, ",", _invoicePage.AllProducts);
}
void AddSale()
{
var sale = new SalesAndCollectionModel
{
Id = Guid.NewGuid().ToString("N"),
Sl = (SalesAndCollectionManager.GetAllSalesAndCollectionsCount() + 1).ToString(),
DealerName = _invoicePage.Dealer.DealerName,
Address = _invoicePage.Dealer.Address,
Contact = _invoicePage.Dealer.Contact,
DealerCode = _invoicePage.Dealer.Code,
Date = DTP_IC_Date.Value,
IC_NO = _invoicePage.No,
MR_NO = "",
OpeningBalance = null,
SalesAmount = _invoicePage.PayableAmount,
CollectionAmount = 0,
ClosingBalance = null,
Remarks = "",
SyncType = "Sales"
};
if (_invoicePage.sale == null)
{
_invoicePage.sale = sale;
SalesAndCollectionManager.AddNewSale(sale);
}
else
{
SalesAndCollectionManager.UpdateSale(_invoicePage.sale, sale);
}
}
BindInterfaceDataToObject();
UpdateProductStock();
AddSale();
SaveInvoiceLogFile();
if (_isSuccess)
{
MessageBox.Show("Invoice file has been saved successfully");
}
else
{
MessageBox.Show("Error! Something Went Wrong while saving the file");
}
LoadChallanForm();
}
