public int EditAcJDetails(int acjournalId, decimal amount)
{
using (SHIPPING_FinalEntities Context1 = new SHIPPING_FinalEntities())
{
var query = (from t in Context1.AcJournalDetails where t.AcJournalID == acjournalId select t).ToList();
foreach (var itme1 in query)
{
AcJournalDetail acjD = new AcJournalDetail();
acjD.AcJournalDetailID = itme1.AcJournalDetailID;
acjD.AcJournalID = itme1.AcJournalID;
acjD.AcHead = itme1.AcHead;
acjD.AcHeadID = itme1.AcHeadID;
if (itme1.Amount < 0)
{
acjD.Amount = -(amount);
}
else
{
acjD.Amount = (amount);
}
acjD.BranchID = itme1.BranchID;
acjD.ID = itme1.ID;
Context1.Entry(itme1).CurrentValues.SetValues(acjD);
Context1.SaveChanges();
}
return(1);
}
}
public int EditRecpayDetailsCustR(int recpayid, decimal amount)
{
using (SHIPPING_FinalEntities Context1 = new SHIPPING_FinalEntities())
{
var obj = (from t in Context1.RecPayDetails where t.RecPayID == recpayid && t.InvoiceID == 0 select t).FirstOrDefault();
//var obj = Context1.RecPayDetails.Find(recpayid,0);
if (obj != null)
{
RecPayDetail recpdetail = new RecPayDetail();
recpdetail.RecPayDetailID = obj.RecPayDetailID;
recpdetail.Amount = -(amount);
// recpdetail.CurrencyID = cueencyid;
//recpd.InvDate = item.InvoiceDate.Value;
recpdetail.RecPayID = obj.RecPayID;
// recpdetail.Remarks = remark;
recpdetail.InvoiceID = 0;
recpdetail.StatusInvoice = obj.StatusInvoice;
recpdetail.InvDate = obj.InvDate;
recpdetail.InvNo = obj.InvNo;
recpdetail.Lock = false;
Context1.Entry(obj).CurrentValues.SetValues(recpdetail);
// Context1.Entry(recpdetail).State = EntityState.Modified;
Context1.SaveChanges();
return(1);
}
else
{
return(0);
}
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
SHIPPING_FinalEntities entity = new SHIPPING_FinalEntities();
string fromdate = Request.QueryString["fromdate"].ToString();
string todate = Request.QueryString["todate"].ToString();
ReportViewer1.SizeToReportContent = true;
ReportViewer1.LocalReport.ReportPath = Server.MapPath("~/Reports/ContainerReport.rdlc");
ReportViewer1.LocalReport.DataSources.Clear();
DataTable dtcompany = new DataTable();
dtcompany.Columns.Add("CompanyName");
dtcompany.Columns.Add("Address1");
dtcompany.Columns.Add("Address2");
dtcompany.Columns.Add("Address3");
dtcompany.Columns.Add("Phone");
dtcompany.Columns.Add("Todate");
dtcompany.Columns.Add("AcHead");
var company = entity.AcCompanies.FirstOrDefault();
DataRow dr = dtcompany.NewRow();
dr[0] = company.AcCompany1;
dr[1] = company.Address1;
dr[2] = company.Address2;
dr[3] = company.Address3;
dr[4] = company.Phone;
dr[5] = TrueBooksMVC.Models.CommanFunctions.GetShortDateFormat(todate);
dr[6] = "";
dtcompany.Rows.Add(dr);
DataTable dtuser = new DataTable();
dtuser.Columns.Add("UserName");
DataRow dr1 = dtuser.NewRow();
int uid = Convert.ToInt32(Session["UserID"].ToString());
dr1[0] = (from c in entity.UserRegistrations where c.UserID == uid select c.UserName).FirstOrDefault();
dtuser.Rows.Add(dr1);
ReportDataSource _rsource;
var dt = entity.ContainerReport(Convert.ToDateTime(fromdate), Convert.ToDateTime(todate));
_rsource = new ReportDataSource("Report", dt);
ReportDataSource _rsource1 = new ReportDataSource("Company", dtcompany);
ReportDataSource _rsource2 = new ReportDataSource("User", dtuser);
ReportViewer1.LocalReport.DataSources.Add(_rsource);
ReportViewer1.LocalReport.DataSources.Add(_rsource1);
ReportViewer1.LocalReport.DataSources.Add(_rsource2);
ReportViewer1.LocalReport.Refresh();
}
}
protected void Page_Load(object sender, EventArgs e)
{
SHIPPING_FinalEntities entity = new SHIPPING_FinalEntities();
int custid = 0;
DateTime frmdate;
DateTime todate;
// supid = Convert.ToInt32(Request.QueryString["supid"].ToString());
// frmdate = Convert.ToDateTime(Request.QueryString["fromdate"].ToString()) ;
//todate = Convert.ToDateTime(Request.QueryString["todate"].ToString());
if (!IsPostBack)
{
DataTable dtcompany = new DataTable();
dtcompany.Columns.Add("CompanyName");
dtcompany.Columns.Add("Address1");
dtcompany.Columns.Add("Address2");
dtcompany.Columns.Add("Address3");
dtcompany.Columns.Add("Phone");
dtcompany.Columns.Add("Todate");
dtcompany.Columns.Add("AcHead");
var company = entity.AcCompanies.FirstOrDefault();
DataRow dr = dtcompany.NewRow();
dr[0] = company.AcCompany1;
dr[1] = company.Address1;
dr[2] = company.Address2;
dr[3] = company.Address3;
dr[4] = company.Phone;
dr[5] = DateTime.Now;
dr[6] = "";
dtcompany.Rows.Add(dr);
ReportViewer1.SizeToReportContent = true;
ReportViewer1.LocalReport.ReportPath = Server.MapPath("~/Reports/Job_Register.rdlc");
ReportViewer1.LocalReport.DataSources.Clear();
ReportDataSource _rsource;
var dt = entity.CustOutstanding(0, Convert.ToDateTime("01 Jan 2013"), Convert.ToDateTime("30-Dec-2016")).ToList();
_rsource = new ReportDataSource("CustOutStanding", dt);
ReportDataSource _rsource1 = new ReportDataSource("Company", dtcompany);
ReportViewer1.LocalReport.DataSources.Add(_rsource);
ReportViewer1.LocalReport.DataSources.Add(_rsource1);
ReportViewer1.LocalReport.Refresh();
}
}
public ActionResult Invoice(string Command, int id)
{
SalesInvoice SI = new SalesInvoice();
//PurchaseInvoiceModel vm = new PurchaseInvoiceModel();
SI = SM.GetSalesInvoiceByID(id);
var context = new SHIPPING_FinalEntities();
if (SI.SalesInvoiceID == 0)
{
var salesinvoiceId = (from c in context.SalesInvoices orderby c.SalesInvoiceID descending select c.SalesInvoiceID).FirstOrDefault();
salesinvoiceId = salesinvoiceId + 1;
var Gen_salesno = salesinvoiceId.ToString("00000");
var salesNo = "SI-" + Gen_salesno;
SI.SalesInvoiceNo = salesNo;
}
BindAllMasters();
return(View(SI));
}
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
SHIPPING_FinalEntities entity = new SHIPPING_FinalEntities();
////int JobID = 2;
//int JobID = 6764;
//JobID = Convert.ToInt32(JobID);
//int acid = 0;
//if (jobid == "")
//{
// acid = 0;
//}
//else
//{
// acid = Convert.ToInt32(jobid);
//}
DateTime fromdate = Convert.ToDateTime(Request.QueryString["fromdate"].ToString());
DateTime todate = Convert.ToDateTime(Request.QueryString["todate"].ToString());
int custid = Convert.ToInt32(Request.QueryString["custid"].ToString());
int jobid = Convert.ToInt32(Request.QueryString["jobid"].ToString());
int status = Convert.ToInt32(Request.QueryString["status"].ToString());
//DateTime fromdate = Convert.ToDateTime("01 Jan 2016");
//DateTime todate = Convert.ToDateTime("31 Dec 2016");
ReportViewer1.SizeToReportContent = true;
ReportViewer1.LocalReport.ReportPath = Server.MapPath("~/Reports/JobCostReport.rdlc");
ReportViewer1.LocalReport.DataSources.Clear();
DataTable dtcompany = new DataTable();
dtcompany.Columns.Add("CompanyName");
dtcompany.Columns.Add("Address1");
dtcompany.Columns.Add("Address2");
dtcompany.Columns.Add("Address3");
dtcompany.Columns.Add("Phone");
dtcompany.Columns.Add("AcHead");
dtcompany.Columns.Add("Todate");
var company = entity.AcCompanies.FirstOrDefault();
DataRow dr = dtcompany.NewRow();
dr[0] = company.AcCompany1;
dr[1] = company.Address1;
dr[2] = company.Address2;
dr[3] = company.Address3;
dr[4] = company.Phone;
dr[5] = "";
dr[6] = "";
dtcompany.Rows.Add(dr);
ReportDataSource _rsource;
//todo:fix to run by sethu
// var data = entity.SP_GetJOBCostReport(fromdate, todate, custid, jobid,status).ToList();
var data = entity.SP_GetJOBCostReport(fromdate, todate, custid, jobid).ToList();
_rsource = new ReportDataSource("JobCostReport", data);
ReportViewer1.LocalReport.DataSources.Add(_rsource);
ReportDataSource _rsource1 = new ReportDataSource("Company", dtcompany);
ReportViewer1.LocalReport.DataSources.Add(_rsource);
ReportViewer1.LocalReport.DataSources.Add(_rsource1);
DataTable dtuser = new DataTable();
dtuser.Columns.Add("UserName");
DataRow dr1 = dtuser.NewRow();
int uid = Convert.ToInt32(Session["UserID"].ToString());
dr1[0] = (from c in entity.UserRegistrations where c.UserID == uid select c.UserName).FirstOrDefault();
dtuser.Rows.Add(dr1);
ReportDataSource _rsource2 = new ReportDataSource("User", dtuser);
ReportViewer1.LocalReport.DataSources.Add(_rsource2);
DataTable dtfilter = new DataTable();
dtfilter.Columns.Add("FromDate");
dtfilter.Columns.Add("UptoDate");
DataRow drfilterrow = dtfilter.NewRow();
drfilterrow[0] = TrueBooksMVC.Models.CommanFunctions.GetShortDateFormat(fromdate);
drfilterrow[1] = TrueBooksMVC.Models.CommanFunctions.GetShortDateFormat(todate);
dtfilter.Rows.Add(drfilterrow);
ReportDataSource _rsource3 = new ReportDataSource("FilterDate", dtfilter);
ReportViewer1.LocalReport.DataSources.Add(_rsource3);
DataTable dtcustomer = new DataTable();
dtcustomer.Columns.Add("CustomerName");
DataRow dtcust = dtcustomer.NewRow();
if (custid == 0)
{
dtcust[0] = "";
}
else
{
string custname = (from c in entity.CUSTOMERs where c.CustomerID == custid select c.Customer1).FirstOrDefault();
dtcust[0] = custname;
}
dtcustomer.Rows.Add(dtcust);
ReportDataSource _rsource4 = new ReportDataSource("Customer", dtcustomer);
ReportViewer1.LocalReport.DataSources.Add(_rsource4);
ReportViewer1.LocalReport.Refresh();
}
}
public ActionResult Invoice(FormCollection formCollection, string Command, int id)
{
SalesInvoice SI = new SalesInvoice();
// UpdateModel<SalesInvoice>(SI);
SI.SalesInvoiceID = Common.ParseInt(formCollection["SalesInvoiceID"]);
SI.SalesInvoiceNo = (formCollection["SalesInvoiceNo"]);
SI.SalesInvoiceDate = Common.ParseDate(formCollection["SalesInvoiceDate"]);
SI.Reference = (formCollection["Reference"]);
SI.LPOReference = (formCollection["LPOReference"]);
SI.CustomerID = Common.ParseInt(formCollection["SelectedCustomerID"]);
//SI.EmployeeID = Common.ParseInt(formCollection["EmployeeeID"]);
SI.EmployeeID = Common.ParseInt(formCollection["SelectedEmployeeID"]);
SI.CurrencyID = Common.ParseInt(formCollection["SelectedCurrencyID"]);
SI.ExchangeRate = Common.ParseDecimal(formCollection["ExchangeRate"]);
SI.CreditDays = 0;
SI.DueDate = Common.ParseDate(formCollection["DueDate"]);
SI.BranchID = Common.ParseInt(Session["branchid"].ToString());;
SI.Discount = 0;
SI.StatusDiscountAmt = false;
SI.OtherCharges = 0;
SI.PaymentTerm = "";
SI.Remarks = (formCollection["Remarks"]);
SI.FYearID = Common.ParseInt(Session["fyearid"].ToString());
SI.DeliveryId = Common.ParseInt(formCollection["SelectedDeliveryId"]);
SI.QuotationNumber = (formCollection["QuotationNumber"]);
SI.DiscountType = Common.ParseInt(formCollection["DiscountType"]);
SI.DiscountValueLC = Common.ParseDecimal(formCollection["DiscountValueLC"]);
SI.DiscountValueFC = Common.ParseDecimal(formCollection["DiscountValueFC"]);
BindAllMasters();
if (Session["UserID"] == null)
{
return(RedirectToAction("Login", "Login"));
}
if (Command == "Save")
{
//SI.SalesInvoiceDate = System.DateTime.UtcNow;
var context = new SHIPPING_FinalEntities();
var salesinvoiceId = (from c in context.SalesInvoices orderby c.SalesInvoiceID descending select c.SalesInvoiceID).FirstOrDefault();
salesinvoiceId = salesinvoiceId + 1;
var Gen_salesno = salesinvoiceId.ToString("00000");
var salesNo = "SI-" + Gen_salesno;
SI.SalesInvoiceNo = salesNo;
int i = 0;
SI.AcJournalID = 0;
SI.IsShipping = true;
i = SM.AddSalesInvoice(SI);
SI.SalesInvoiceID = i;
DeleteAndInsertRecords(formCollection, i);
AcJournalMaster acJournalMaster = new AcJournalMaster();
acJournalMaster.AcFinancialYearID = Convert.ToInt32(Session["fyearid"].ToString());
acJournalMaster.AcJournalID = objectSourceModel.GetMaxNumberAcJournalMasters();
acJournalMaster.VoucherType = "SI";
int max = (from c in context.AcJournalMasters select c).ToList().Count();
acJournalMaster.VoucherNo = salesNo; //(max + 1).ToString();
acJournalMaster.UserID = Convert.ToInt32(Session["UserID"].ToString());
acJournalMaster.TransDate = SI.SalesInvoiceDate;
acJournalMaster.StatusDelete = false;
acJournalMaster.ShiftID = null;
acJournalMaster.Remarks = SI.Remarks;
acJournalMaster.AcCompanyID = Convert.ToInt32(Session["AcCompanyID"].ToString());
acJournalMaster.Reference = SI.Reference;
context.AcJournalMasters.Add(acJournalMaster);
context.SaveChanges();
var acmasterid = acJournalMaster.AcJournalID;
SI.AcJournalID = acmasterid;
SM.UpdateSalesInvoice(SI);
if (acmasterid > 0)
{
DeleteorInsertAcJounalDetails(acmasterid, i);
}
if (i > 0)
{
Session["SalesInvoiceID"] = i;
SI.SalesInvoiceID = i;
//return RedirectToAction("Invoice", "SalesInvoice", new { ID = i });
return(RedirectToAction("Index", "SalesInvoice"));
}
}
else if (Command == "Update")
{
SI.SalesInvoiceID = id;
var salesinvoice = (from d in entity.SalesInvoices where d.SalesInvoiceID == id select d).FirstOrDefault();
SI.AcJournalID = salesinvoice.AcJournalID;
if (SI.AcJournalID == null)
{
SI.AcJournalID = 0;
}
int k = SM.UpdateSalesInvoice(SI);
DeleteAndInsertRecords(formCollection, id);
if (SI.AcJournalID > 0)
{
DeleteorInsertAcJounalDetails(SI.AcJournalID, id);
}
return(RedirectToAction("Index", "SalesInvoice"));
//return RedirectToAction("Invoice", "SalesInvoice", new { ID = SI.SalesInvoiceID });
}
else if (Command == "SaveInvoice")
{
}
return(RedirectToAction("Index", "SalesInvoice"));
//return View(SI);
}
protected void Page_Load(object sender, EventArgs e)
{
SHIPPING_FinalEntities entity = new SHIPPING_FinalEntities();
int JobID = 6764;
//JobID = Convert.ToInt32(JobID);
JobID = Convert.ToInt32(Request.QueryString["jobid"].ToString());
//int acid = 0;
//if (jobid == "")
//{
// acid = 0;
//}
//else
//{
// acid = Convert.ToInt32(jobid);
//}
DateTime fromdate = new DateTime(2016, 01, 01);
DateTime todate = new DateTime(2016, 04, 25);
ReportViewer1.SizeToReportContent = true;
ReportViewer1.LocalReport.ReportPath = Server.MapPath("~/Reports/DeliveryNoteFormatted.rdlc");
ReportViewer1.LocalReport.DataSources.Clear();
DataTable dtcompany = new DataTable();
dtcompany.Columns.Add("CompanyName");
dtcompany.Columns.Add("Address1");
dtcompany.Columns.Add("Address2");
dtcompany.Columns.Add("Address3");
dtcompany.Columns.Add("Phone");
dtcompany.Columns.Add("AcHead");
dtcompany.Columns.Add("Todate");
var company = entity.AcCompanies.FirstOrDefault();
DataRow dr = dtcompany.NewRow();
dr[0] = company.AcCompany1;
dr[1] = company.Address1;
dr[2] = company.Address2;
dr[3] = company.Address3;
dr[4] = company.Phone;
dr[5] = "";
dr[6] = DateTime.Now;
dtcompany.Rows.Add(dr);
ReportDataSource _rsource;
var dd = entity.SP_GetDeliveryNoteReport(JobID).ToList();
_rsource = new ReportDataSource("DeliveryNoteDS", dd);
ReportDataSource _rsource1 = new ReportDataSource("Company", dtcompany);
//ReportViewer1.LocalReport.DataSources.Add(_rsource);
ReportViewer1.LocalReport.DataSources.Add(_rsource);
ReportViewer1.LocalReport.DataSources.Add(_rsource1);
DataTable dtuser = new DataTable();
dtuser.Columns.Add("UserName");
DataRow dr1 = dtuser.NewRow();
int uid = Convert.ToInt32(Session["UserID"].ToString());
dr1[0] = (from c in entity.UserRegistrations where c.UserID == uid select c.UserName).FirstOrDefault();
dtuser.Rows.Add(dr1);
ReportDataSource _rsource2 = new ReportDataSource("User", dtuser);
ReportViewer1.LocalReport.DataSources.Add(_rsource2);
ReportViewer1.LocalReport.Refresh();
}
protected void Page_Load(object sender, EventArgs e)
{
//string acheadid = Request.QueryString["acheadid"].ToString();
//DateTime fromdate = Convert.ToDateTime(Request.QueryString["frmdate"].ToString());
//DateTime todate = Convert.ToDateTime(Request.QueryString["todate"].ToString());
//if (Session["AcCompanyID"].ToString() == "")
//{
// Response.Redirect("../Views/Login/Login");
//}
if (!IsPostBack)
{
SHIPPING_FinalEntities db = new SHIPPING_FinalEntities();
int acid = Convert.ToInt32(Request.QueryString["acheadid"].ToString());
DateTime fromdate = Convert.ToDateTime(Request.QueryString["fromdate"].ToString());
DateTime todate = Convert.ToDateTime(Request.QueryString["todate"].ToString());
ReportViewer1.SizeToReportContent = true;
ReportViewer1.LocalReport.ReportPath = Server.MapPath("~/Reports/BankBook.rdlc");
ReportViewer1.LocalReport.DataSources.Clear();
DataTable dtcompany = new DataTable();
dtcompany.Columns.Add("CompanyName");
dtcompany.Columns.Add("Address1");
dtcompany.Columns.Add("Address2");
dtcompany.Columns.Add("Address3");
dtcompany.Columns.Add("Phone");
dtcompany.Columns.Add("AcHead");
dtcompany.Columns.Add("Todate");
var company = entity.AcCompanies.FirstOrDefault();
DataRow dr = dtcompany.NewRow();
dr[0] = company.AcCompany1;
dr[1] = company.Address1;
dr[2] = company.Address2;
dr[3] = company.Address3;
dr[4] = company.Phone;
dr[5] = TrueBooksMVC.Models.CommanFunctions.GetShortDateFormat(todate);
dr[6] = (from c in db.AcHeads where c.AcHeadID == acid select c.AcHead1).FirstOrDefault();
dtcompany.Rows.Add(dr);
ReportDataSource _rsource;
//var dt = entity.Report_CashAndBankBook(Convert.ToInt32(Session["fyearid"].ToString()), Convert.ToDateTime("01 Jan 2016"), Convert.ToDateTime("04 Apr 2016"), acid, Convert.ToInt32(Session["AcCompanyID"].ToString())).ToList();
var dt = entity.Report_CashAndBankBook(Convert.ToInt32(Session["fyearid"].ToString()), fromdate, todate, acid, Convert.ToInt32(Session["AcCompanyID"].ToString())).ToList();
_rsource = new ReportDataSource("BankBook", dt);
ReportDataSource _rsource1 = new ReportDataSource("Company", dtcompany);
ReportViewer1.LocalReport.DataSources.Add(_rsource);
ReportViewer1.LocalReport.DataSources.Add(_rsource1);
DataTable dtuser = new DataTable();
dtuser.Columns.Add("UserName");
DataRow dr1 = dtuser.NewRow();
int uid = Convert.ToInt32(Session["UserID"].ToString());
dr1[0] = (from c in entity.UserRegistrations where c.UserID == uid select c.UserName).FirstOrDefault();
dtuser.Rows.Add(dr1);
ReportDataSource _rsource2 = new ReportDataSource("User", dtuser);
ReportViewer1.LocalReport.DataSources.Add(_rsource2);
ReportViewer1.LocalReport.Refresh();
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
SHIPPING_FinalEntities entity = new SHIPPING_FinalEntities();
DateTime fromdate = Convert.ToDateTime(Request.QueryString["fromdate"].ToString());
DateTime todate = Convert.ToDateTime(Request.QueryString["todate"].ToString());
int CustomerID = Convert.ToInt32(Request.QueryString["custid"].ToString());
int JobTypeID = Convert.ToInt32(Request.QueryString["jobtypeid"].ToString());
int Employee = Convert.ToInt32(Request.QueryString["empid"].ToString());
ReportViewer1.SizeToReportContent = true;
ReportViewer1.LocalReport.ReportPath = Server.MapPath("~/Reports/Report_JobCost.rdlc");
ReportViewer1.LocalReport.DataSources.Clear();
DataTable dtcompany = new DataTable();
dtcompany.Columns.Add("CompanyName");
dtcompany.Columns.Add("Address1");
dtcompany.Columns.Add("Address2");
dtcompany.Columns.Add("Address3");
dtcompany.Columns.Add("Phone");
dtcompany.Columns.Add("Todate");
dtcompany.Columns.Add("AcHead");
var company = entity.AcCompanies.FirstOrDefault();
DataRow dr = dtcompany.NewRow();
dr[0] = company.AcCompany1;
dr[1] = company.Address1;
dr[2] = company.Address2;
dr[3] = company.Address3;
dr[4] = company.Phone;
dr[5] = TrueBooksMVC.Models.CommanFunctions.GetShortDateFormat(todate);
dr[6] = "";
dtcompany.Rows.Add(dr);
ReportDataSource _rsource;
//var dt = entity.Report_CashAndBankBook(Convert.ToInt32(Session["fyearid"].ToString()), Convert.ToDateTime("01 Jan 2016"), Convert.ToDateTime("04 Apr 2016"), acid, Convert.ToInt32(Session["AcCompanyID"].ToString())).ToList();
var dt = entity.JobAnalysisReport(fromdate, todate).ToList();
_rsource = new ReportDataSource("JobAnalysisRepor", dt);
ReportDataSource _rsource1 = new ReportDataSource("Company", dtcompany);
ReportViewer1.LocalReport.DataSources.Add(_rsource);
ReportViewer1.LocalReport.DataSources.Add(_rsource1);
DataTable dtuser = new DataTable();
dtuser.Columns.Add("UserName");
DataRow dr1 = dtuser.NewRow();
int uid = Convert.ToInt32(Session["UserID"].ToString());
dr1[0] = (from c in entity.UserRegistrations where c.UserID == uid select c.UserName).FirstOrDefault();
dtuser.Rows.Add(dr1);
ReportDataSource _rsource3 = new ReportDataSource("User", dtuser);
ReportViewer1.LocalReport.DataSources.Add(_rsource3);
DataTable dtfilter = new DataTable();
dtfilter.Columns.Add("FromDate");
dtfilter.Columns.Add("UptoDate");
DataRow drfilterrow = dtfilter.NewRow();
drfilterrow[0] = TrueBooksMVC.Models.CommanFunctions.GetShortDateFormat(fromdate);
drfilterrow[1] = TrueBooksMVC.Models.CommanFunctions.GetShortDateFormat(todate);
dtfilter.Rows.Add(drfilterrow);
ReportDataSource _rsource4 = new ReportDataSource("ReportPeriod", dtfilter);
ReportViewer1.LocalReport.DataSources.Add(_rsource4);
ReportViewer1.LocalReport.Refresh();
}
}
protected void Page_Load(object sender, EventArgs e)
{
SHIPPING_FinalEntities entity = new SHIPPING_FinalEntities();
int JobID = 6764;
JobID = Convert.ToInt32(Request.QueryString["jobid"].ToString());
////int JobID = 2;
//int JobID = 6764;
//JobID = Convert.ToInt32(JobID);
//int acid = 0;
//if (jobid == "")
//{
// acid = 0;
//}
//else
//{
// acid = Convert.ToInt32(jobid);
//}
ReportViewer1.SizeToReportContent = true;
ReportViewer1.LocalReport.ReportPath = Server.MapPath("~/Reports/InvoiceReportFormatted.rdlc");
ReportViewer1.LocalReport.DataSources.Clear();
DataTable dtcompany = new DataTable();
dtcompany.Columns.Add("CompanyName");
dtcompany.Columns.Add("Address1");
dtcompany.Columns.Add("Address2");
dtcompany.Columns.Add("Address3");
dtcompany.Columns.Add("Phone");
dtcompany.Columns.Add("AcHead");
dtcompany.Columns.Add("Todate");
var company = entity.AcCompanies.FirstOrDefault();
DataRow dr = dtcompany.NewRow();
dr[0] = company.AcCompany1;
dr[1] = company.Address1;
dr[2] = company.Address2;
dr[3] = company.Address3;
dr[4] = company.Phone;
dr[5] = "";
dr[6] = DateTime.Now;
dtcompany.Rows.Add(dr);
ReportDataSource _rsource;
var dd = entity.SP_GetInvoiceReport(JobID).ToList();
_rsource = new ReportDataSource("InvoiceReport", dd);
ReportDataSource _rsource1 = new ReportDataSource("Company", dtcompany);
//ReportViewer1.LocalReport.DataSources.Add(_rsource);
ReportViewer1.LocalReport.DataSources.Add(_rsource);
ReportViewer1.LocalReport.DataSources.Add(_rsource1);
DataTable dtuser = new DataTable();
dtuser.Columns.Add("UserName");
DataRow dr1 = dtuser.NewRow();
int uid = Convert.ToInt32(Session["UserID"].ToString());
dr1[0] = (from c in entity.UserRegistrations where c.UserID == uid select c.UserName).FirstOrDefault();
dtuser.Rows.Add(dr1);
ReportDataSource _rsource2 = new ReportDataSource("User", dtuser);
ReportViewer1.LocalReport.DataSources.Add(_rsource2);
DataTable dtcurrency = new DataTable();
dtcurrency.Columns.Add("SalesCurrency");
dtcurrency.Columns.Add("ForeignCurrency");
dtcurrency.Columns.Add("SalesCurrencySymbol");
dtcurrency.Columns.Add("ForeignCurrencySymbol");
dtcurrency.Columns.Add("InWords");
decimal provtotal = dd.Sum(x => x.SalesHome).Value;
var cur = (from c in entity.CurrencyMasters where c.StatusBaseCurrency == true select c).FirstOrDefault();
DataRow r = dtcurrency.NewRow();
r[0] = cur.CurrencyName;
r[1] = dd.First().CurrencyName;
r[2] = "(" + cur.Symbol + ")";
r[3] = "(" + dd.First().Symbol + ")";
r[4] = NumberToWords(Convert.ToInt32(provtotal));
dtcurrency.Rows.Add(r);
ReportDataSource _rsource3 = new ReportDataSource("Currency", dtcurrency);
ReportViewer1.LocalReport.DataSources.Add(_rsource3);
ReportViewer1.LocalReport.Refresh();
}
protected void Page_Load(object sender, EventArgs e)
{
int recpayid = 32998;
recpayid = Convert.ToInt32(Request.QueryString["recpayid"].ToString());
int?currencyId = 0;
////int JobID = 2;
//int JobID = 6764;
//JobID = Convert.ToInt32(JobID);
//int acid = 0;
//if (jobid == "")
//{
// acid = 0;
//}
//else
//{
// acid = Convert.ToInt32(jobid);
//}
decimal?totalamt = 0;
SHIPPING_FinalEntities entity = new SHIPPING_FinalEntities();
ReportViewer1.SizeToReportContent = true;
ReportViewer1.LocalReport.ReportPath = Server.MapPath("~/Reports/SupplierPayment.rdlc");
ReportViewer1.LocalReport.DataSources.Clear();
DataTable dtcompany = new DataTable();
dtcompany.Columns.Add("CompanyName");
dtcompany.Columns.Add("Address1");
dtcompany.Columns.Add("Address2");
dtcompany.Columns.Add("Address3");
dtcompany.Columns.Add("Phone");
dtcompany.Columns.Add("AcHead");
dtcompany.Columns.Add("Todate");
var company = entity.AcCompanies.FirstOrDefault();
string imagePath = new Uri(Server.MapPath("~/Content/Logo/" + company.logo)).AbsoluteUri;
DataRow dr = dtcompany.NewRow();
dr[0] = company.AcCompany1;
dr[1] = company.Address1;
dr[2] = company.Address2;
dr[3] = company.Address3;
dr[4] = company.Phone;
dr[5] = imagePath;
dr[6] = DateTime.Now;
dtcompany.Rows.Add(dr);
var receipt = (from d in entity.RecPays where d.RecPayID == recpayid select d).FirstOrDefault();
totalamt = receipt.FMoney;
if (receipt.IsTradingReceipt == true)
{
var recpaydetails = (from d in entity.RecPayDetails where d.RecPayID == recpayid where d.InvoiceID > 0 select d).ToList();
var cust = entity.Suppliers.Where(d => d.SupplierID == receipt.SupplierID).FirstOrDefault();
var listofdet = new List <ReportCustomerReceipt_Result>();
foreach (var item in recpaydetails)
{
var sinvoicedet = (from d in entity.PurchaseInvoiceDetails where d.PurchaseInvoiceDetailID == item.InvoiceID select d).FirstOrDefault();
var currency = recpaydetails.Where(d => d.CurrencyID > 0).FirstOrDefault();
if (currency != null)
{
currencyId = currency.CurrencyID;
}
var sinvoice = (from d in entity.PurchaseInvoices where d.PurchaseInvoiceID == sinvoicedet.PurchaseInvoiceID select d).FirstOrDefault();
var customerrecpay = new ReportCustomerReceipt_Result();
customerrecpay.Date = receipt.RecPayDate.Value.ToString("dd-MMM-yyyy");
customerrecpay.ReceivedFrom = cust.SupplierName;
customerrecpay.DocumentNo = receipt.DocumentNo;
customerrecpay.Amount = Convert.ToDecimal(receipt.FMoney);
customerrecpay.Remarks = receipt.Remarks;
customerrecpay.Account = receipt.BankName;
if (receipt.ChequeDate != null)
{
customerrecpay.ChequeDate = receipt.ChequeDate.Value.ToString("dd-MMM-yyyy");
}
else
{
customerrecpay.ChequeDate = "";
}
if (!string.IsNullOrEmpty(receipt.ChequeNo))
{
customerrecpay.ChequeNo = Convert.ToDecimal(receipt.ChequeNo);
}
customerrecpay.CustomerBank = "";
customerrecpay.DetailDocNo = sinvoice.PurchaseInvoiceNo;
customerrecpay.DocDate = sinvoice.PurchaseInvoiceDate.Value.ToString("dd-MMM-yyyy");
customerrecpay.DocAmount = Convert.ToDecimal(sinvoicedet.NetValue);
if (item.Amount > 0)
{
customerrecpay.SettledAmount = Convert.ToDecimal(item.Amount);
customerrecpay.AdjustmentAmount = Convert.ToInt32(item.AdjustmentAmount);
}
else
{
customerrecpay.SettledAmount = Convert.ToDecimal(item.Amount);
customerrecpay.AdjustmentAmount = Convert.ToInt32(item.AdjustmentAmount);
}
listofdet.Add(customerrecpay);
}
ReportDataSource _rsource;
//var dd = entity.ReportCustomerReceipt(recpayid).ToList();
_rsource = new ReportDataSource("ReceiptVoucher", listofdet);
ReportViewer1.LocalReport.DataSources.Add(_rsource);
}
else
{
var recpaydetails = (from d in entity.RecPayDetails where d.RecPayID == recpayid where d.InvoiceID > 0 select d).ToList();
var currency = recpaydetails.Where(d => d.CurrencyID > 0).FirstOrDefault();
if (currency != null)
{
currencyId = currency.CurrencyID;
}
var cust = entity.Suppliers.Where(d => d.SupplierID == receipt.SupplierID).FirstOrDefault();
var listofdet = new List <ReportCustomerReceipt_Result>();
foreach (var item in recpaydetails)
{
var sinvoicedet = (from d in entity.JInvoices where d.InvoiceID == item.InvoiceID select d).FirstOrDefault();
var sinvoice = (from d in entity.JobGenerations where d.JobID == sinvoicedet.JobID select d).FirstOrDefault();
var customerrecpay = new ReportCustomerReceipt_Result();
customerrecpay.Date = receipt.RecPayDate.Value.ToString("dd-MMM-yyyy");
customerrecpay.ReceivedFrom = cust.SupplierName;
customerrecpay.DocumentNo = receipt.DocumentNo;
customerrecpay.Amount = Convert.ToDecimal(receipt.FMoney);
customerrecpay.Remarks = receipt.Remarks;
customerrecpay.Account = receipt.BankName;
if (receipt.ChequeDate != null)
{
customerrecpay.ChequeDate = receipt.ChequeDate.Value.ToString("dd-MMM-yyyy");
}
else
{
customerrecpay.ChequeDate = "";
}
if (!string.IsNullOrEmpty(receipt.ChequeNo))
{
customerrecpay.ChequeNo = Convert.ToDecimal(receipt.ChequeNo);
}
customerrecpay.CustomerBank = "";
customerrecpay.DetailDocNo = sinvoice.InvoiceNo.ToString();
customerrecpay.DocDate = sinvoice.InvoiceDate.Value.ToString("dd-MMM-yyyy");
customerrecpay.DocAmount = Convert.ToDecimal(sinvoicedet.SalesHome);
if (item.Amount > 0)
{
customerrecpay.SettledAmount = Convert.ToDecimal(item.Amount);
customerrecpay.AdjustmentAmount = Convert.ToInt32(item.AdjustmentAmount);
}
else
{
customerrecpay.SettledAmount = Convert.ToDecimal(item.Amount) * -1;
customerrecpay.AdjustmentAmount = Convert.ToInt32(item.AdjustmentAmount);
}
listofdet.Add(customerrecpay);
}
ReportDataSource _rsource;
//var dd = entity.ReportCustomerReceipt(recpayid).ToList();
_rsource = new ReportDataSource("ReceiptVoucher", listofdet);
ReportViewer1.LocalReport.DataSources.Add(_rsource);
}
ReportDataSource _rsource1 = new ReportDataSource("Company", dtcompany);
ReportViewer1.LocalReport.DataSources.Add(_rsource1);
//foreach (var item in dd)
//{
// totalamt = 5000;
//}
//totalamt = 5000;
//DataTable dtuser = new DataTable();
//dtuser.Columns.Add("UserName");
//DataRow dr1 = dtuser.NewRow();
//int uid = Convert.ToInt32(Session["UserID"].ToString());
//dr1[0] = (from c in entity.UserRegistrations where c.UserID == uid select c.UserName).FirstOrDefault();
//dtuser.Rows.Add(dr1);
//ReportDataSource _rsource2 = new ReportDataSource("User", dtuser);
//ReportViewer1.LocalReport.DataSources.Add(_rsource2);
DataTable dtcurrency = new DataTable();
dtcurrency.Columns.Add("SalesCurrency");
dtcurrency.Columns.Add("ForeignCurrency");
dtcurrency.Columns.Add("SalesCurrencySymbol");
dtcurrency.Columns.Add("ForeignCurrencySymbol");
dtcurrency.Columns.Add("InWords");
var currencyName = (from d in entity.CurrencyMasters where d.CurrencyID == currencyId select d).FirstOrDefault();
if (currencyName == null)
{
currencyName = new CurrencyMaster();
}
DataRow r = dtcurrency.NewRow();
r[0] = currencyName.CurrencyName;
r[1] = "";
r[2] = "";
r[3] = "";
r[4] = currencyName.CurrencyName + ", " + NumberToWords(Convert.ToInt32(totalamt)) + " /00 baisa.";
dtcurrency.Rows.Add(r);
ReportDataSource _rsource3 = new ReportDataSource("Currency", dtcurrency);
ReportViewer1.LocalReport.DataSources.Add(_rsource3);
ReportViewer1.LocalReport.EnableExternalImages = true;
ReportViewer1.LocalReport.Refresh();
}
protected void Page_Load(object sender, EventArgs e)
{
SHIPPING_FinalEntities entity = new SHIPPING_FinalEntities();
if (!IsPostBack)
{
int jobid = 0;
jobid = Convert.ToInt32(Request.QueryString["jobid"].ToString());
DataTable dtcompany = new DataTable();
dtcompany.Columns.Add("CompanyName");
dtcompany.Columns.Add("Address1");
dtcompany.Columns.Add("Address2");
dtcompany.Columns.Add("Address3");
dtcompany.Columns.Add("Phone");
dtcompany.Columns.Add("Todate");
dtcompany.Columns.Add("AcHead");
var company = entity.AcCompanies.FirstOrDefault();
DataRow dr = dtcompany.NewRow();
dr[0] = company.AcCompany1;
dr[1] = company.Address1;
dr[2] = company.Address2;
dr[3] = company.Address3;
dr[4] = company.Phone;
dr[5] = DateTime.Now;
dr[6] = "";
dtcompany.Rows.Add(dr);
ReportViewer1.SizeToReportContent = true;
ReportViewer1.LocalReport.ReportPath = Server.MapPath("~/Reports/JobRegisterReport.rdlc");
ReportViewer1.LocalReport.DataSources.Clear();
ReportDataSource _rsource;
DataSet ds = DAL.SP_JobRegisterReportPrintByJObID(jobid);
_rsource = new ReportDataSource("JobRegister", ds.Tables[0]);
ReportDataSource _rsCargo;
_rsCargo = new ReportDataSource("Cargo", ds.Tables[1]);
ReportDataSource _rsBillOfEntry;
_rsBillOfEntry = new ReportDataSource("BillOfEntry", ds.Tables[2]);
ReportDataSource _rsource1 = new ReportDataSource("Comapny", dtcompany);
// DataTable ddcharges = new DataTable();
// var dd = entity.GetChargesByJobIDForJobRegister(jobid).ToList();
ReportDataSource _rsource2 = new ReportDataSource("Charges", ds.Tables[3]);
ReportDataSource _rsourceContainerDetails = new ReportDataSource("ContainerDetails", ds.Tables[4]);
ReportDataSource _rsourceAuditLog = new ReportDataSource("AuditLog", ds.Tables[5]);
DataTable druser = new DataTable();
druser.Columns.Add("UserName");
DataRow dr1 = druser.NewRow();
//int uid = Convert.ToInt32(Session["UserID"].ToString());
int uid = Convert.ToInt32(Session["UserID"].ToString());
dr1[0] = (from c in entity.UserRegistrations where c.UserID == uid select c.UserName).FirstOrDefault();
druser.Rows.Add(dr1);
ReportDataSource _rsource3 = new ReportDataSource("User", druser);
ReportViewer1.LocalReport.DataSources.Add(_rsource2);
ReportViewer1.LocalReport.DataSources.Add(_rsource);
ReportViewer1.LocalReport.DataSources.Add(_rsCargo);
ReportViewer1.LocalReport.DataSources.Add(_rsBillOfEntry);
ReportViewer1.LocalReport.DataSources.Add(_rsource1);
ReportViewer1.LocalReport.DataSources.Add(_rsource3);
ReportViewer1.LocalReport.DataSources.Add(_rsourceContainerDetails);
ReportViewer1.LocalReport.DataSources.Add(_rsourceAuditLog);
ReportViewer1.LocalReport.Refresh();
}
}
private void BindReport()
{
SHIPPING_FinalEntities entity = new SHIPPING_FinalEntities();
int InvoiceId = 0;
InvoiceId = Convert.ToInt32(Request.QueryString["id"].ToString());
DateTime fromdate = new DateTime(2016, 01, 01);
DateTime todate = new DateTime(2016, 04, 25);
ReportViewer1.SizeToReportContent = true;
ReportViewer1.LocalReport.ReportPath = Server.MapPath("~/Reports/PurchaseInvoiceReport.rdlc");
ReportViewer1.LocalReport.DataSources.Clear();
DataTable dtcompany = new DataTable();
dtcompany.Columns.Add("CompanyName");
dtcompany.Columns.Add("Address1");
dtcompany.Columns.Add("Address2");
dtcompany.Columns.Add("Address3");
dtcompany.Columns.Add("Phone");
dtcompany.Columns.Add("AcHead");
dtcompany.Columns.Add("Todate");
var company = entity.AcCompanies.FirstOrDefault();
var invoice = entity.PurchaseInvoices.Where(d => d.PurchaseInvoiceID == InvoiceId).FirstOrDefault();
var getsupplier = entity.Suppliers.Where(d => d.SupplierID == invoice.SupplierID).FirstOrDefault();
DataRow dr = dtcompany.NewRow();
dr[0] = company.AcCompany1;
dr[1] = company.Address1;
dr[2] = company.Address2;
dr[3] = company.Address3;
dr[4] = company.Phone;
dr[5] = "";
dr[6] = DateTime.Now;
dtcompany.Rows.Add(dr);
ReportDataSource _rsourceInvoice;
DataSet ds = DAL.SP_GetPurchaseInvoiceReport(InvoiceId);
_rsourceInvoice = new ReportDataSource("PurchaseInvoice", ds.Tables[0]);
DataTable dtsupplier = new DataTable();
dtsupplier.Columns.Add("SupplierName");
dtsupplier.Columns.Add("Address1");
dtsupplier.Columns.Add("Address2");
dtsupplier.Columns.Add("Address3");
dtsupplier.Columns.Add("Phone");
dtsupplier.Columns.Add("Country");
dtsupplier.Columns.Add("City");
DataRow dr2 = dtsupplier.NewRow();
dr2[0] = getsupplier.SupplierName;
dr2[1] = getsupplier.Address1;
dr2[2] = getsupplier.Address2;
dr2[3] = getsupplier.Address3;
dr2[4] = getsupplier.Phone;
dr2[5] = getsupplier.CountryID;
dr2[6] = invoice.ExchangeRate;
dtsupplier.Rows.Add(dr2);
ReportDataSource _resourceSupplier = new ReportDataSource("Supplier", dtsupplier);
ReportDataSource _rsourceCompany = new ReportDataSource("Company", dtcompany);
ReportDataSource _rsourceInvoiceDetails = new ReportDataSource("PurchaseInvoiceDetails", ds.Tables[1]);
ReportViewer1.LocalReport.DataSources.Add(_rsourceInvoice);
ReportViewer1.LocalReport.DataSources.Add(_rsourceCompany);
ReportViewer1.LocalReport.DataSources.Add(_rsourceInvoiceDetails);
ReportViewer1.LocalReport.DataSources.Add(_resourceSupplier);
DataTable dtuser = new DataTable();
dtuser.Columns.Add("UserName");
DataRow dr1 = dtuser.NewRow();
int uid = Convert.ToInt32(Session["UserID"].ToString());
dr1[0] = (from c in entity.UserRegistrations where c.UserID == uid select c.UserName).FirstOrDefault();
dtuser.Rows.Add(dr1);
ReportDataSource _rsource2 = new ReportDataSource("User", dtuser);
ReportViewer1.LocalReport.DataSources.Add(_rsource2);
ReportViewer1.LocalReport.Refresh();
}
