private void PopupModelControl_Load(object sender, EventArgs e)
{
if (_dealer == null)
{
LPMC_Title.Text = "ADD New Dealer";
BPMC_AddOrUpdate.Text = "Add";
_dealer = new DealerModel
{
Address = "",
Code = "",
Contact = "",
Date = DateTime.Now.ToString("dd-MMM-yy"),
DealerName = "",
Sl = (DealerManager.GetAllDealersCount() + 1).ToString(),
};
}
else
{
LPMC_Title.Text = "Edit Dealer";
BPMC_AddOrUpdate.Text = "Update";
}
BindObjectDataToInterface();
}
private void BDC_Delete_Click(object sender, EventArgs e)
{
DataGridViewRow row = this.DGV_DealerList.SelectedRows[0];
if (row != null)
{
DialogResult dialogResult = MessageBox.Show(" Are you sure? ", "Confirm Delete?", MessageBoxButtons.YesNo);
if (dialogResult == DialogResult.Yes)
{
DealerModel dealer = row.DataBoundItem as DealerModel;
DealerManager.DeleteDealer(dealer);
MessageBox.Show("Dealer has been deleated successfully!");
_dealerList = DealerManager.GetAllDealers();
BindObjectDataToInterface();
}
else if (dialogResult == DialogResult.No)
{
//do something else
}
}
else
{
MessageBox.Show("Select a Dealer to Delete.");
}
}
public static void ExecuteMongoDBOperations()
{
try
{
if (CheckForInternetConnection())
{
//var dealerRepo = new DealerRepository(new MongoDbContext());
var dealerRepo = new DynamicRepository <DealerEntity>(new MongoDbContext());
var results = dealerRepo.GetAllData().Result;
//dealerRepo.DropDealer();
var dealers = DealerManager.GetAllDealers();
var dealerList = JsonConvert.DeserializeObject <List <DealerEntity> >(JsonConvert.SerializeObject(dealers));
foreach (var dealer in dealerList)
{
dealer.Created_On = DateTime.Now;
dealer.Modified_On = DateTime.Now;
dealerRepo.Save(dealer);
}
//var results = dealerRepo.GetAllDealers().Result;
}
}
catch (Exception ex)
{
Console.WriteLine(ex.Message);
}
}
private static void AddDealer(DealerManager dealerManager)
{
dealerManager.Add(new Dealer
{
DealerExplanation = "Dealer explanation",
DealerStatusName = "Admin",
UserId = 1
});
}
private static void ListAllDealer(DealerManager dealerManager)
{
var dealers = dealerManager.GetAll();
foreach (var dealer in dealers.Data)
{
Console.WriteLine($"{dealer.DealerExplanation}" + " " + $"{dealer.DealerStatusName}");
}
}
public SalesAndCollectionControl(Panel hPanel, Panel vPanel)
: this()
{
_hPanel = hPanel;
_vPanel = vPanel;
isPartyLedger = false;
isTimePeriodChanged = false;
_fullPath = string.Empty;
_dealerList = DealerManager.GetAllDealers();
}
private void SelectDealerControl_Load(object sender, EventArgs e)
{
DGV_SDC_Dealers.SelectionMode = DataGridViewSelectionMode.FullRowSelect;
DGV_SDC_Dealers.MultiSelect = false;
_dealerList = DealerManager.GetAllDealers();
var bindingList = new BindingList <DealerModel>(_dealerList);
var source = new BindingSource(bindingList, null);
DGV_SDC_Dealers.DataSource = source;
}
private static void DealerDetailsList(DealerManager dealerManager)
{
var result = dealerManager.GetDealerDetails();
foreach (var details in result.Data)
{
Console.WriteLine("First Name :" + details.FirstName + " "
+ "Last Name :" + details.LastName + " " +
"Dealer Explanation " + details.DealerExplanation + " " +
"Dealer Status Name " + details.DealerStatusName);
}
}
private void DealerControl_Load(object sender, EventArgs e)
{
DGV_DealerList.SelectionMode = DataGridViewSelectionMode.FullRowSelect;
DGV_DealerList.MultiSelect = false;
_dealerList = DealerManager.GetAllDealers();
BindObjectDataToInterface();
DGV_DealerList.SelectionMode = DataGridViewSelectionMode.FullRowSelect;
DGV_DealerList.MultiSelect = false;
DGV_DealerList.Columns["Sl"].ReadOnly = true;
DGV_DealerList.Columns["Date"].ReadOnly = true;
}
static void Main(string[] args)
{
DealerManager dealerManager = new DealerManager(new EfDealerDal());
StatusManager statusManager = new StatusManager(new EfStatusDal());
//AddStatusAndList(statusManager);
//AddDealer(dealerManager);
//ListAllDealer(dealerManager);
//DealerDetailsList(dealerManager);
byte[] numbers = { 0, 16, 104, 213 };
Console.WriteLine(Encoding.UTF8.GetString(numbers));
}
public InvoiceControl(Panel hPanel, Panel vPanel, PageModel page)
: this()
{
_hPanel = hPanel;
_vPanel = vPanel;
_page = page;
_dealerList = DealerManager.GetAllDealers();
_productList = ProductManager.GetAllProducts();
_invoicePage = JsonConvert.DeserializeObject <InvoicePageModel>(JsonConvert.SerializeObject(_page));
TBIC_Discount.MaxLength = 2;
BindObjectDataToInterface();
}
public int SaveDealer(DealerUI objUI, System.Data.SqlClient.SqlTransaction objTrans)
{
int DealerID = 0;
bool flagTransation = true;
DealerDB objDB = new DealerDB();
objDB.Code = objUI.Code;
objDB.Dealer = objUI.Dealer;
objDB.RegionID = objUI.RegionID;
objDB.IsActive = objUI.IsActive;
objDB.Id = objUI.Id;
objDB.CheckID = objUI.CheckID;
objDB.City = objUI.City;
objDB.InstallerName = objUI.InstallerName;
objDB.IsOperatingDealer = objUI.IsOperatingDealer;
DataAccessLayer objDataAccess = new DataAccessLayer();
try
{
if (objTrans == null)
{
flagTransation = false;
objDataAccess.GetConnection.Open();
SqlTransaction objTransaction = objDataAccess.GetConnection.BeginTransaction();
objTrans = objTransaction;
}
DealerManager objManager = new DealerManager();
DealerID = objManager.SaveDealer(objDB, objTrans);
if (!flagTransation)
objTrans.Commit();
return DealerID;
}
catch (Exception ex)
{
if (!flagTransation)
objTrans.Rollback();
throw ex;
}
finally
{
objDataAccess.GetConnection.Close();
}
}
public InvoiceControl(Panel hPanel, Panel vPanel, InvoicePageModel invoicePage)
: this()
{
_hPanel = hPanel;
_vPanel = vPanel;
_invoicePage = invoicePage;
_page = JsonConvert.DeserializeObject <PageModel>(JsonConvert.SerializeObject(_invoicePage));
_dealerList = DealerManager.GetAllDealers();
_productList = ProductManager.GetAllProducts();
if (_invoicePage.sale != null)
{
_itemList = CommonHelper.CloneList <ItemModel>(_invoicePage.AllProducts);
}
TBIC_Discount.MaxLength = 2;
BindObjectDataToInterface();
}
public PopupCollectionModelControl(Panel vPanel, Panel hPanel, Form popUpForm, SalesAndCollectionControl salesAndCollectionControl, string dealerCode)
{
_popUpForm = popUpForm;
_vPanel = vPanel;
_hPanel = hPanel;
_salesAndCollectionControl = salesAndCollectionControl;
_dealerList = DealerManager.GetAllDealers();
if (string.IsNullOrEmpty(dealerCode) || dealerCode.ToLower().Equals("any"))
{
_dealer = null;
}
else
{
_dealer = DealerManager.FindDealer(dealerCode);
}
InitializeComponent();
this.Load += new System.EventHandler(this.PopupModelControl_Load);
}
private void BindInterfaceDataToObject()
{
_dealer.DealerName = TB_PMC_DealerName.Text;
_dealer.Code = TB_PMC_DealerCode.Text;
_dealer.Address = TB_PMC_DealerAddress.Text;
_dealer.Contact = TB_PMC_DealerContact.Text;
if (_dealer.DealerName.Equals("") ||
_dealer.Code.Equals("") ||
_dealer.Address.Equals("") ||
_dealer.Contact.Equals(""))
{
MessageBox.Show("Fill up all boxes!!");
}
else
{
ConfirmChange();
}
void ConfirmChange()
{
DialogResult dialogResult = MessageBox.Show(BPMC_AddOrUpdate.Text + " Dealer? ", "Confirm Change?", MessageBoxButtons.YesNo);
if (dialogResult == DialogResult.Yes)
{
if (_dealer != null)
{
if (BPMC_AddOrUpdate.Text.Equals("Update"))
{
if (DealerManager.UpdateDealer(_dealer))
{
MessageBox.Show("Dealer Updated successfully!");
ReloadDealerControl();
}
else
{
MessageBox.Show("Error! Dealer Code already Exist! Dealer Code must be unique!");
}
}
else if (BPMC_AddOrUpdate.Text.Equals("Add"))
{
if (DealerManager.AddDealer(_dealer))
{
MessageBox.Show("Dealer Added successfully!");
ReloadDealerControl();
}
else
{
MessageBox.Show("Error! Dealer Code already Exist! Dealer Code must be unique!");
}
}
}
else
{
}
}
else if (dialogResult == DialogResult.No)
{
//do something else
}
void ReloadDealerControl()
{
_hPanel.Controls.Clear();
_dealerControl = new DealerControl(_vPanel, _hPanel);
_hPanel.Controls.Add(_dealerControl);
_dealerControl.Dock = DockStyle.Fill;
_dealerControl.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;
}
