public sales_return New()
{
sales_return sales_return = new sales_return();
sales_return.State = EntityState.Added;
sales_return.id_range = Brillo.GetDefault.Return_RangeID(App.Names.SalesReturn);
sales_return.status = Status.Documents_General.Pending;
sales_return.trans_date = DateTime.Now;
sales_return.id_branch = CurrentSession.Id_Branch;
sales_return.app_branch = base.app_branch.Where(x => x.id_branch == sales_return.id_branch).FirstOrDefault();
sales_return.State = EntityState.Added;
sales_return.IsSelected = true;
//Get any value, so that it doesn't cause NotNull Exception. This data is not important.
sales_return.app_condition = base.app_condition.FirstOrDefault();
sales_return.app_contract = base.app_contract.Where(x => x.id_condition == sales_return.app_condition.id_condition).FirstOrDefault();
return(sales_return);
}
private void add_CRM(sales_return sales_return)
{
sales_invoice_detail sales_invoice_detail = sales_return.sales_return_detail.FirstOrDefault().sales_invoice_detail;
if (sales_invoice_detail == null)
{
crm_opportunity crm_opportunity = new crm_opportunity();
crm_opportunity.id_contact = sales_return.id_contact;
crm_opportunity.id_currency = sales_return.id_currencyfx;
crm_opportunity.value = sales_return.GrandTotal;
crm_opportunity.sales_return.Add(sales_return);
base.crm_opportunity.Add(crm_opportunity);
}
else
{
crm_opportunity crm_opportunity = sales_invoice.Where(x => x.id_sales_invoice == sales_invoice_detail.id_sales_invoice).FirstOrDefault().crm_opportunity;
crm_opportunity.sales_return.Add(sales_return);
base.crm_opportunity.Attach(crm_opportunity);
}
}
public void loadSalesReturnReport(int id)
{
try
{
ReportDataSource reportDataSource = new ReportDataSource();
reportDataSource.Name = "DataSet1"; // Name of the DataSet we set in .rdlc
sales_return sales_return = db.sales_return.Where(x => x.id_sales_return == id).FirstOrDefault();
List <sales_return_detail> sales_return_detail = db.sales_return_detail.Where(x => x.id_sales_return == sales_return.id_sales_return).ToList();
reportDataSource.Value = sales_return_detail
.Select(g => new
{
id_sales_return = g.id_sales_return,
id_sales_return_detail = g.id_sales_return_detail,
sales_return = g.id_sales_return_detail,
id_company = g.id_company,
add1 = g.sales_return.contact.address,
telephone = g.sales_return.contact.telephone,
email = g.sales_return.contact.email,
company_name = g.app_company.name,
item_code = g.item.code,
item_description = g.item.name,
Description = g.item.item_brand != null ? g.item.item_brand.name : "",
quantity = g.quantity,
sub_Total = g.SubTotal,
sub_Total_vat = g.SubTotal_Vat,
unit_cost = g.unit_cost,
unit_price = g.unit_cost,
unit_price_vat = g.UnitPrice_Vat,
terminale_name = g.sales_return.app_terminal.name,
code = g.sales_return.code,
contact_name = g.sales_return.contact.name,
trans_date = g.sales_return.trans_date,
id_vat_group = g.id_vat_group,
gov_id = g.sales_return.contact.gov_code,
Number = g.sales_return.number,
}).ToList();
string path = Environment.GetFolderPath(Environment.SpecialFolder.MyDocuments);
path = path + "\\CogntivoERP";
string SubFolder = "";
SubFolder = "\\TemplateFiles";
if (!Directory.Exists(path))
{
Directory.CreateDirectory(path);
Directory.CreateDirectory(path + SubFolder);
File.Copy(AppDomain.CurrentDomain.BaseDirectory + "\\bin\\debug\\Sales_Return.rdlc", path + SubFolder + "\\Sales_Return.rdlc");
}
else if (!Directory.Exists(path + SubFolder))
{
Directory.CreateDirectory(path + SubFolder);
File.Copy(AppDomain.CurrentDomain.BaseDirectory + "\\bin\\debug\\Sales_Return.rdlc", path + SubFolder + "\\Sales_Return.rdlc");
}
else if (!File.Exists(path + SubFolder + "\\Sales_Return.rdlc"))
{
File.Copy(AppDomain.CurrentDomain.BaseDirectory + "\\bin\\debug\\Sales_Return.rdlc", path + SubFolder + "\\Sales_Return.rdlc");
}
if (!sales_return.app_document_range.use_default_printer)
{
reportViewer.LocalReport.ReportPath = path + SubFolder + "\\Sales_Return.rdlc"; // Path of the rdlc file
reportViewer.LocalReport.DataSources.Add(reportDataSource);
reportViewer.RefreshReport();
}
else
{
try
{
if (sales_return.app_document_range.printer_name != null)
{
LocalReport report = new LocalReport();
PrintInvoice PrintInvoice = new PrintInvoice();
report.ReportPath = path + SubFolder + "\\Sales_Return.rdlc"; // Path of the rdlc file
report.DataSources.Add(reportDataSource);
PrintInvoice.Export(report);
PrintInvoice.Print(sales_return.app_document_range.printer_name);
}
else
{
NotSupportedException ex = new NotSupportedException();
throw ex;
}
}
catch
{
reportViewer.LocalReport.ReportPath = path + SubFolder + "\\Sales_Return.rdlc"; // Path of the rdlc file
reportViewer.LocalReport.DataSources.Add(reportDataSource);
reportViewer.RefreshReport();
Window window = new Window
{
Title = "Report",
Content = this
};
window.ShowDialog();
}
}
}
catch (Exception ex)
{
throw ex;
}
}