private void Set_AppFlyout_Loaded(object sender, RoutedEventArgs e)
{
try
{
Log.Info(" Before: To get from setting ,in Set_App");
Inventory.Model.Setting set = DatabaseAndQueries.Queries.GetDataByCondition <Inventory.Model.Setting>(x => x.Id == 1);
Log.Info(" After: To get from setting ,in Set_App");
_s = set;
if (set != null)
{
DataContext = set;
string[] add = set.Address.Split('$');
try
{
addressline1.Text = add[0];
}
catch (Exception)
{
}
try
{
addressline2.Text = add[1];
}
catch (Exception)
{
}
try
{
addressline3.Text = add[2];
}
catch (Exception)
{
}
try
{
addressline4.Text = add[3];
}
catch (Exception)
{
}
}
else
{
Log.Info("setting record not available: ,in Set_App");
}
}
catch (Exception ex)
{
Log.Error("Settings is Empty ,in Set_App");
}
}
private void UserControl_Loaded(object sender, RoutedEventArgs e)
{
Log.Info("Before : To generate bill in UserControl_Loaded SearchCustomer");
DataSet Ds = new DataSet();
DataTable dt = new DataTable();
dt.Columns.Add("Product");
dt.Columns.Add("Qty");
dt.Columns.Add("Price");
dt.Columns.Add("TotalAmount");
dt.Columns.Add("Advance");
dt.Columns.Add("SaleDate");
dt.Columns.Add("Type");
Log.Info("Before :To get data from salelist using foreach UserControl_Loaded SearchCustomer");
foreach (Sale item in productlst)
{
DataRow _r = dt.NewRow();
_r["Product"] = item.Product.Pname;
_r["Qty"] = item.Quantity;
_r["Price"] = item.Price;
_r["TotalAmount"] = item.TotalAmount;
_r["Advance"] = item.Advance;
_r["SaleDate"] = item.SaleDate.ToString("dd-MM-yyyy");
if (item.Type == true)
{
_r["Type"] = "Sale";
}
else
{
_r["Type"] = "Purchase";
}
dt.Rows.Add(_r);
}
Ds.Tables.Add(dt);
Log.Info("After :To get data from salelist using foreach UserControl_Loaded SearchCustomer");
string Apppath = System.IO.Path.GetDirectoryName(System.Diagnostics.Process.GetCurrentProcess().MainModule.FileName);
if (Apppath.IndexOf("\\bin\\Debug") != -1)
{
Apppath = Apppath.Remove(Apppath.IndexOf("\\bin\\Debug"));
}
Log.Info("Before : To get setting record from db in SearchCustomer");
Inventory.Model.Setting _Setting = DatabaseAndQueries.Queries.GetDataByCondition <Inventory.Model.Setting>
(x => x.Id == 1);
string[] address = _Setting.Address.Split('$');
Log.Info("After : To get setting record from db in SearchCustomer");
/*Report Parameters*/
/*image parametere*/
// ReportParameter imageParam = new ReportParameter("imageParam", "file:///" + Apppath + "\\Images\\logo.png");
ReportParameter companyName = new ReportParameter("comanyName", _Setting.CompanyName.ToUpper());
ReportParameter addressLine1 = new ReportParameter("addressLine1", address[0].ToUpper());
ReportParameter addressLine2 = new ReportParameter("addressLine2", address[1].ToUpper());
ReportParameter addressLine3 = new ReportParameter("addressLine3", address[2].ToUpper());
ReportParameter addressLine4 = new ReportParameter("addressLine4", address[3].ToUpper());
ReportParameter contact = new ReportParameter("contact", _Setting.ContactNo.ToString());
ReportParameter DateFromParam = new ReportParameter("DateFromParam", Fdate);
ReportParameter DateToParam = new ReportParameter("DateToParam", Ldate);
ReportParameter CustomerParam = new ReportParameter("CustomerParam", customername);
ReportParameter AdvanceParam = new ReportParameter("AdvanceParam", advance);
ReportParameter BalanceParam = new ReportParameter("BalanceParam", balance);
ReportDataSource reportDataSource = new ReportDataSource("ProductDataSet", dt);
reportViewer.LocalReport.EnableExternalImages = true;
reportViewer.LocalReport.ReportEmbeddedResource = "Inventory.Reports.SearchCustomer.rdlc";
this.reportViewer.LocalReport.SetParameters(new ReportParameter[] {//imageParam,
companyName, addressLine1, addressLine2, addressLine3, addressLine4, contact, DateFromParam
, DateToParam, CustomerParam, AdvanceParam, BalanceParam
});
this.reportViewer.LocalReport.DataSources.Clear();
reportViewer.LocalReport.DataSources.Add(reportDataSource);
reportViewer.RefreshReport();
Log.Info("After :To generate bill in UserControl_Loaded SearchCustomer");
}
private void UserControl_Loaded(object sender, RoutedEventArgs e)
{
Log.Info("Before: To get list of all sale record using billno SaleBill report");
List <Sale> saleslst = Queries.GetAllByCondition <Sale>(x => x.Billing == billno);
Log.Info("After: To get list of all sale record using billno SaleBill report");
if (saleslst.Count != 0)
{
Log.Info("Before: load datatable of SaleBill report");
DataSet Ds = new DataSet();
DataTable dt = new DataTable();
dt.Columns.Add("Product");
dt.Columns.Add("Price");
dt.Columns.Add("Qty");
dt.Columns.Add("Discount");
dt.Columns.Add("Vat");
dt.Columns.Add("TotalAmount");
dt.Columns.Add("Advance");
dt.Columns.Add("Type");
dt.Columns.Add("RemainingBalance");
foreach (Sale item in saleslst)
{
DataRow _r = dt.NewRow();
_r["Product"] = item.Product.Pname;
_r["Price"] = item.Price;
_r["Qty"] = item.Quantity;
_r["Discount"] = item.Discount;
_r["Vat"] = item.Vat;
_r["TotalAmount"] = item.TotalAmount;
_r["Advance"] = item.Advance;
if (item.Type == true)
{
_r["Type"] = "Sale";
}
else
{
_r["Type"] = "Purchase";
}
_r["RemainingBalance"] = item.RemainingBalance;
customer = item.Customer.Cname;
contactno = item.Customer.ContactNo.ToString();
add = item.Customer.Address.ToString();
sdate = item.SaleDate.ToString("dd-MM-yyyy");
dt.Rows.Add(_r);
}
Ds.Tables.Add(dt);
Log.Info("Before: getting setting data of SaleBill report");
string Apppath = System.IO.Path.GetDirectoryName(System.Diagnostics.Process.GetCurrentProcess().MainModule.FileName);
if (Apppath.IndexOf("\\bin\\Debug") != -1)
{
Apppath = Apppath.Remove(Apppath.IndexOf("\\bin\\Debug"));
}
Log.Info("Before: To get setting record SaleBill report");
Inventory.Model.Setting _Setting = DatabaseAndQueries.Queries.GetDataByCondition <Inventory.Model.Setting>
(x => x.Id == 1);
Log.Info("After: To get setting record SaleBill report");
string[] address = _Setting.Address.Split('$');
/*Report Parameters*/
/*image parametere*/
// ReportParameter imageParam = new ReportParameter("imageParam", "file:///" + Apppath + "\\Images\\logo.png");
ReportParameter companyName = new ReportParameter("comanyName", _Setting.CompanyName.ToUpper());
ReportParameter addressLine1 = new ReportParameter("addressLine1", address[0].ToUpper());
ReportParameter addressLine2 = new ReportParameter("addressLine2", address[1].ToUpper());
ReportParameter addressLine3 = new ReportParameter("addressLine3", address[2].ToUpper());
ReportParameter addressLine4 = new ReportParameter("addressLine4", address[3].ToUpper());
ReportParameter contact = new ReportParameter("contact", _Setting.ContactNo.ToString());
ReportParameter cusotmerName = new ReportParameter("customerName", customer.ToUpper());
ReportParameter customerAddress = new ReportParameter("customerAddress", add.ToUpper());
ReportParameter Customercontact = new ReportParameter("Customercontact", contactno.ToString());
ReportParameter purchasedate = new ReportParameter("purchasedate", sdate);
ReportParameter Billno = new ReportParameter("Billno", billno.ToString());
ReportDataSource reportDataSource = new ReportDataSource("BillDataset", dt);
// reportDataSource.Name = "CustomerReport"; // Name of the DataSet we set in .rdlc
reportViewer.LocalReport.EnableExternalImages = true;
reportViewer.LocalReport.ReportEmbeddedResource = "Inventory.Reports.SearchByCustomer.rdlc";
this.reportViewer.LocalReport.SetParameters(new ReportParameter[] {// imageParam,
companyName, addressLine1, addressLine2, addressLine3, addressLine4, contact, cusotmerName,
customerAddress, Customercontact, purchasedate, Billno
});
this.reportViewer.LocalReport.DataSources.Clear();
reportViewer.LocalReport.DataSources.Add(reportDataSource);
reportViewer.RefreshReport();
}
else
{
this.Close();
MessageBox.Show("Record not found");
}
}
public void Sldier_Tick(object sender, EventArgs e)
{
if (count < (Slider.Items.Count - 1))
{
count++;
Slider.SelectedIndex = count;
}
else
{
DatabaseAndQueries.SessionFactory.DatabaseType = DatabaseAndQueries.DBTYPE.SqlLite.ToString();
DatabaseAndQueries.SessionFactory.FilePath = Environment.GetFolderPath(Environment.SpecialFolder.LocalApplicationData) + @"\InventoryDBA\CTE_Data.db";
DatabaseAndQueries.SessionFactory.AssemblyName = System.Reflection.Assembly.GetExecutingAssembly().ToString();
Log.Info("Before: call copy database in LodingWindow");
CopyDataBase();
Log.Info("After: call copy database,successfully in LodingWindow");
Log.Info("Before: to get list of setting variable from DB in LoadingWindow");
IList <Setting> _Sp = Queries.GetAllByCondition <Setting>(x => x.Id == 1);
Log.Info("after: to get list of setting variable from DB in LoadingWindow");
var rdiction = new ResourceDictionary();
var rdiction1 = new ResourceDictionary();
if (_Sp == null)
{
Setting _setting = new Setting();
_setting.Accent = "Blue";
_setting.Theme = "Basedark";
Queries.Add <Setting>(_setting);
rdiction.Source = new Uri(string.Format("pack://application:,,,/MahApps.Metro;component/Styles/Accents/{0}.xaml", _setting.Accent));
Application.Current.Resources.MergedDictionaries.Add(rdiction);
rdiction1.Source = new Uri(string.Format("pack://application:,,,/MahApps.Metro;component/Styles/Accents/{0}.xaml", _setting.Theme));
Log.Info("After: to get list of setting variable from DB, Successfully in LoadingWindow");
}
else
{
Log.Info("Before: to get list of setting variable from DB in LoadingWindow");
Inventory.Model.Setting _S = _Sp.First();//DatabaseAndQueries.Queries.GetDataByCondition<Inventory.Model.Setting>(x => x.Id == 1);
Log.Info("After: to get list of setting variable from DB, Successfully in LoadingWindow");
rdiction.Source = new Uri(string.Format("pack://application:,,,/MahApps.Metro;component/Styles/Accents/{0}.xaml", _S.Accent));
Application.Current.Resources.MergedDictionaries.Add(rdiction);
rdiction1.Source = new Uri(string.Format("pack://application:,,,/MahApps.Metro;component/Styles/Accents/{0}.xaml", _S.Theme));
Log.Info("After: to get list of setting variable from DB, Successfully in LoadingWindow");
}
List <LoginUser> _lst = Queries.GetAllData <LoginUser>();
if (_lst.Count == 0)
{
new MasterPassword().Show();
}
else
{
LoginUser _lu = _lst.First <LoginUser>();
if (_lu.Trial.Date <= DateTime.Now.Date)
{
new TrialExpireWindow().Show(); // send to expire window.
Log.Info("After: To show trail Expire window, in LoadingWindow");
}
else
{
Application.Current.Resources.MergedDictionaries.Add(rdiction);
Application.Current.Resources.MergedDictionaries.Add(rdiction1);
new Login().Show();
}
}
newslider.Stop();
count = 0;
this.Close();
}
}
private void Window_Loaded(object sender, RoutedEventArgs e)
{
Log.Info("Before: load datatable of standard report in Standard_Customer");
DataSet Ds = new DataSet();
DataTable dt = new DataTable();
float sale = 0, purcahse = 0, remainbalance = 0;
dt.Columns.Add("BillNo");
dt.Columns.Add("SaleDate");
dt.Columns.Add("Product");
dt.Columns.Add("Qty");
dt.Columns.Add("Price");
//dt.Columns.Add("TotalAmount");
//dt.Columns.Add("Advance");
dt.Columns.Add("Sale");
dt.Columns.Add("Purchase");
foreach (Sale item in saleslst)
{
DataRow _r = dt.NewRow();
if (item.Type)
{
_r["BillNo"] = item.Billing;
_r["Sale"] = item.TotalAmount;
_r["Purchase"] = string.Empty;
sale = sale + item.TotalAmount;
}
else
{
_r["BillNo"] = item.PurchaseBill;
_r["Sale"] = string.Empty;
_r["Purchase"] = item.TotalAmount;
purcahse = purcahse + item.TotalAmount;
}
//if (productname == "Hello")
//{
// List<Sale> _lst = Queries.GetAllByCondition<Sale>(x => x.Customer.Cname.ToUpper() == customername);
// foreach (Sale items in _lst)
// {
// remainbalance = remainbalance + items.RemainingBalance;
// }
//}
_r["SaleDate"] = item.SaleDate.ToString("dd-MM-yyyy");
_r["Product"] = item.Product.Pname;
_r["Qty"] = item.Quantity;
_r["Price"] = item.Price;
// _r["TotalAmount"] = item.TotalAmount;
// _r["Advance"] = item.Advance;
dt.Rows.Add(_r);
}
var p = remainbalance;
Ds.Tables.Add(dt);
Log.Info("Before: getting setting data of standard report in Standard_Customer");
string Apppath = System.IO.Path.GetDirectoryName(System.Diagnostics.Process.GetCurrentProcess().MainModule.FileName);
if (Apppath.IndexOf("\\bin\\Debug") != -1)
{
Apppath = Apppath.Remove(Apppath.IndexOf("\\bin\\Debug"));
}
Log.Info("Before : To get setting record from db in Standard_Customer");
Inventory.Model.Setting _Setting = DatabaseAndQueries.Queries.GetDataByCondition <Inventory.Model.Setting>
(x => x.Id == 1);
string[] address = _Setting.Address.Split('$');
Log.Info("After: To get setting record from db in Standard_Customer");
/*Report Parameters*/
/*image parametere*/
ReportParameter companyName = new ReportParameter("comanyName", _Setting.CompanyName.ToUpper());
ReportParameter addressLine1 = new ReportParameter("addressLine1", address[0].ToUpper() + ", " + address[1].ToUpper());
ReportParameter addressLine2 = new ReportParameter("addressLine2", address[2].ToUpper() + ", " + address[3].ToUpper());
ReportParameter contact = new ReportParameter("contact", _Setting.ContactNo.ToString());
Log.Info("After: getting setting data of standard report, successfully in Standard_Customer");
Log.Info("Before: set parameter of standard report in Standard_Customer");
ReportParameter Nameparam = new ReportParameter("Nameparam", customername);
ReportParameter Dateparam = new ReportParameter("Dateparam", Fdate);
ReportParameter SecondDateparam = new ReportParameter("SecondDateparam", Ldate);
//if (productname == "Hello")
//{
// productname = remainbalance.ToString();
//}
ReportParameter prodparam = new ReportParameter("prodparam", productname);
ReportParameter secondstringparam = new ReportParameter("secondstringparam", secondstring);
ReportParameter firststringparam = new ReportParameter("firststringparam", firststring);
ReportParameter datestringparam = new ReportParameter("datestringparam", firstdatestring);
ReportParameter seconddatestringparam = new ReportParameter("seconddatestringparam", seconddatestring);
ReportParameter salesumparam = new ReportParameter("salesumparam", sale.ToString());
ReportParameter Purchasesumparam = new ReportParameter("Purchasesumparam", purcahse.ToString());
ReportDataSource reportDataSource = new ReportDataSource("GridDataSet", dt);
reportViewer.LocalReport.EnableExternalImages = true;
reportViewer.LocalReport.ReportEmbeddedResource = "Inventory.Reports.StandardReport.rdlc";
this.reportViewer.LocalReport.SetParameters(new ReportParameter[] { companyName, addressLine1, addressLine2,
contact, Nameparam,
Dateparam, SecondDateparam, prodparam
, secondstringparam, firststringparam,
datestringparam, seconddatestringparam, salesumparam, Purchasesumparam });
Log.Info("After: set parameter of standard report in Standard_Customer");
this.reportViewer.LocalReport.DataSources.Clear();
reportViewer.LocalReport.DataSources.Add(reportDataSource);
reportViewer.RefreshReport();
Log.Info("After:successful load datatable of standard report in Standard_Customer");
}
private void UserControl_Loaded(object sender, RoutedEventArgs e)
{
Log.Info("Before : To generate report in AllCustomer");
DataSet Ds = new DataSet();
DataTable dt = new DataTable();
dt.Columns.Add("Cid");
dt.Columns.Add("Cname");
dt.Columns.Add("Address");
dt.Columns.Add("ContactNo");
dt.Columns.Add("Email");
dt.Columns.Add("Date");
Log.Info("Before : To get List of all customer in AllCustomer");
List <Customer> _lst = Queries.GetAllData <Customer>();
Log.Info("After : To get List of all customer in AllCustomer");
foreach (Customer item in _lst)
{
DataRow _r = dt.NewRow();
_r["Cid"] = item.Cid;
_r["Cname"] = item.Cname;
_r["Address"] = item.Address;
_r["ContactNo"] = item.ContactNo;
_r["Email"] = item.Email;
_r["Date"] = item.Date;
dt.Rows.Add(_r);
}
Ds.Tables.Add(dt);
string Apppath = System.IO.Path.GetDirectoryName(System.Diagnostics.Process.GetCurrentProcess().MainModule.FileName);
if (Apppath.IndexOf("\\bin\\Debug") != -1)
{
Apppath = Apppath.Remove(Apppath.IndexOf("\\bin\\Debug"));
}
Log.Info("Before : To get setting record from db in AllCustomer");
Inventory.Model.Setting _Setting = DatabaseAndQueries.Queries.GetDataByCondition <Inventory.Model.Setting>
(x => x.Id == 1);
Log.Info("After : To get setting record from db in AllCustomer");
string[] address = _Setting.Address.Split('$');
/*Report Parameters*/
/*image parametere*/
// ReportParameter imageParam = new ReportParameter("imageParam", "file:///" + Apppath + "\\Images\\logo.png");
ReportParameter companyName = new ReportParameter("comanyName", _Setting.CompanyName.ToUpper());
ReportParameter addressLine1 = new ReportParameter("addressLine1", address[0].ToUpper());
ReportParameter addressLine2 = new ReportParameter("addressLine2", address[1].ToUpper());
ReportParameter addressLine3 = new ReportParameter("addressLine3", address[2].ToUpper());
ReportParameter addressLine4 = new ReportParameter("addressLine4", address[3].ToUpper());
ReportParameter contact = new ReportParameter("contact", _Setting.ContactNo.ToString());
ReportDataSource reportDataSource = new ReportDataSource("DataSet1", dt);
reportViewer.LocalReport.EnableExternalImages = true;
reportViewer.LocalReport.ReportEmbeddedResource = "Inventory.Reports.SearchAllCustomer.rdlc";
this.reportViewer.LocalReport.SetParameters(new ReportParameter[] {// imageParam,
companyName, addressLine1, addressLine2, addressLine3, addressLine4, contact
});
this.reportViewer.LocalReport.DataSources.Clear();
reportViewer.LocalReport.DataSources.Add(reportDataSource);
reportViewer.RefreshReport();
Log.Info("After : To generate report in AllCustomer");
}