public IHttpActionResult PutQutationTable(int id, QutationTable qutationTable) { if (!ModelState.IsValid) { return(BadRequest(ModelState)); } if (id != qutationTable.QutationID) { return(BadRequest()); } db.Entry(qutationTable).State = EntityState.Modified; try { db.SaveChanges(); return(StatusCode(HttpStatusCode.OK)); } catch (DbUpdateConcurrencyException) { if (!QutationTableExists(id)) { return(NotFound()); } else { throw; } } }
public IHttpActionResult GetQutationTable(int id) { QutationTable qutationTable = db.QutationTables.Find(id); if (qutationTable == null) { return(NotFound()); } return(Ok(qutationTable)); }
public HttpResponseMessage post([FromBody] QutationTable qutationtable) { using (QutationEntities entities = new QutationEntities()) { entities.QutationTables.Add(qutationtable); entities.SaveChanges(); var massage = Request.CreateResponse(HttpStatusCode.Created, qutationtable); massage.Headers.Location = new Uri(Request.RequestUri + qutationtable.QutationID.ToString()); massage.Content.Headers.Add("idd", qutationtable.QutationID.ToString()); massage.RequestMessage.Headers.Add("idd", qutationtable.QutationID.ToString()); return(massage); } }
public IHttpActionResult DeleteQutationTable(int id) { QutationTable qutationTable = db.QutationTables.Find(id); if (qutationTable == null) { return(NotFound()); } db.QutationTables.Remove(qutationTable); db.SaveChanges(); return(Ok(qutationTable)); }
public IHttpActionResult PostQutationTable([FromBody] QutationTable qutationtable) { using (DBEntities entities = new DBEntities()) { try { qutationtable = entities.QutationTables.Add(qutationtable); entities.SaveChanges(); return(Ok(qutationtable)); } catch (Exception ex) { return(BadRequest()); } } }
public IHttpActionResult GetUpdateQuatationStatus(int Id) { QutationTable qt = new QutationTable(); try { qt = db.QutationTables.Where(q => q.QutationID == Id).FirstOrDefault(); if (qt != null) { qt.Status = "accepted"; db.Entry(qt).State = EntityState.Modified; db.SaveChanges(); return(Ok()); } return(NotFound()); } catch (Exception) { return(BadRequest()); throw; } }
public IHttpActionResult PutQutationTable(int id, QutationTable qutationTable) { if (!ModelState.IsValid) { return(BadRequest(ModelState)); } if (id != qutationTable.QutationID) { return(BadRequest()); } db.Entry(qutationTable).State = EntityState.Modified; try { db.SaveChanges(); return(StatusCode(HttpStatusCode.OK)); } catch (Exception ex) { throw ex; } }
protected void Page_Load(object sender, EventArgs e) { int Qut = Convert.ToInt32(Request.QueryString["id"]); string d = HttpContext.Current.Server.MapPath("/images/" + "6.jpg"); DBEntities entity = new DBEntities(); QutationTable table = entity.QutationTables.Where(x => x.QutationID == 44).FirstOrDefault(); List <Comp> info = entity.ComapnyInfoes.Where(x => x.CompanyID == 54).Select(c => new Comp { // Company Information CompanyID = c.CompanyID, CompanyTRN = c.CompanyTRN, CompanyName = c.CompanyName, CompanyAddress = c.CompanyAddress, CompanyPhone = c.CompanyPhone, CompanyCell = c.CompanyCell, CompanyEmail = c.CompanyEmail, CompanyLogo = c.CompanyLogo, CompanyCity = c.CompanyCity, CompanyCountry = c.CompanyCountry, StreetNumber = c.StreetNumber, PostalCode = c.PostalCode, IBANNumber = c.IBANNumber, Website = c.Website, BIC = c.BIC, KVK = c.KVK, BTW = c.BTW, BankName = c.BankName, UserName = c.UserName, }).ToList(); List <Contacts> Contact = entity.ContactsTables.Where(x => x.ContactsId == 66).Select(c => new Contacts { ContactName = c.ContactName, ContactAddress = c.ContactAddress, ContactCity = c.City, ContactLand = c.Land, ContactPostalCode = c.PostalCode, contactMobile = c.Mobile, Contacttelephone = c.telephone, ContactStreetNumber = c.StreetNumber, }).ToList(); List <GoodsTable> goodsTable = entity.QutationDetailsTables.Where(x => x.QutationID == 44 && x.Type == "Goods").Select(x => new GoodsTable { ProductName = x.ProductTable.ProductName, Quantity = x.Quantity ?? 0, Rate = x.Rate ?? 0, Total = x.Total ?? 0, Vat = x.Vat ?? 0, RowSubTotal = x.RowSubTotal ?? 0, }).ToList(); DateTime dt = DateTime.Today; List <ServicesTables> servicesTabless = entity.QutationDetailsTables.Where(x => x.QutationID == 44 && x.Type == "Service").Select(x => new ServicesTables { Date = x.ServiceDate.ToString(), ProductNames = x.ProductTable.ProductName, Descriptions = x.Description, Quantitys = x.Quantity ?? 0, Rates = x.Rate ?? 0, Totals = x.Total ?? 0, Vats = x.Vat ?? 0, RowSubTotals = x.RowSubTotal ?? 0, }).ToList(); List <ServicesTables> servicesTables = new List <ServicesTables>(); foreach (var x in servicesTabless) { ServicesTables Serv = new ServicesTables(); DateTime dtt = Convert.ToDateTime(x.Date); Serv.Date = dtt.ToShortDateString(); Serv.ProductNames = x.ProductNames; Serv.Descriptions = x.Descriptions; Serv.Quantitys = x.Quantitys; Serv.Rates = x.Rates; Serv.Totals = x.Totals; Serv.Vats = x.Vats; Serv.RowSubTotals = x.RowSubTotals; servicesTables.Add(Serv); } List <QuotationReportModel> quotationReportModels = entity.QutationTables.Where(x => x.QutationID == 44).Select(x => new QuotationReportModel { QutationID = x.QutationID, Qutation_ID = x.Qutation_ID, RefNumber = x.RefNumber, QutationDate = x.QutationDate.ToString(), DueDate = x.DueDate.ToString(), SubTotal = x.SubTotal ?? 0, TotalVat6 = x.TotalVat6 ?? 0, TotalVat21 = x.TotalVat21 ?? 0, DiscountAmount = x.DiscountAmount ?? 0, TotalAmount = x.TotalAmount ?? 0, CustomerNote = x.CustomerNote, Status = x.Status }).ToList(); List <QuotationReportModel> quotationReportModel = new List <QuotationReportModel>(); foreach (var x in quotationReportModels) { QuotationReportModel qut = new QuotationReportModel(); DateTime QT = Convert.ToDateTime(x.QutationDate); DateTime DQT = Convert.ToDateTime(x.DueDate); qut.QutationID = x.QutationID; qut.Qutation_ID = x.Qutation_ID; qut.RefNumber = x.RefNumber; qut.QutationDate = QT.ToShortDateString(); qut.DueDate = DQT.ToShortDateString(); qut.SubTotal = x.SubTotal; qut.TotalVat6 = x.TotalVat6; qut.TotalVat21 = x.TotalVat21; qut.DiscountAmount = x.DiscountAmount; qut.TotalAmount = x.TotalAmount; qut.CustomerNote = x.CustomerNote; qut.Status = x.Status; quotationReportModel.Add(qut); } //ReportDocument Report = new ReportDocument(); //// string rptPath = Server.MapPath("CrystalReport.rpt"); ReportDocument reportDocument = new ReportDocument(); ParameterField paramField = new ParameterField(); ParameterFields paramFields = new ParameterFields(); ParameterDiscreteValue paramDiscreteValue = new ParameterDiscreteValue(); paramField.Name = "ImageURL"; var s = Server.MapPath("~/images/" + info[0].CompanyLogo); paramDiscreteValue.Value = s; paramField.CurrentValues.Add(paramDiscreteValue); paramFields.Add(paramField); CrystalReportViewer1.ParameterFieldInfo = paramFields; reportDocument.Load(Server.MapPath("~/CrystalReport/QuotationDetails.rpt")); reportDocument.Database.Tables[0].SetDataSource(info); reportDocument.Database.Tables[1].SetDataSource(Contact); reportDocument.Database.Tables[2].SetDataSource(goodsTable); reportDocument.Database.Tables[3].SetDataSource(servicesTables); reportDocument.Database.Tables[4].SetDataSource(quotationReportModel); CrystalReportViewer1.ReportSource = reportDocument; //reportDocument.SetDatabaseLogon("sa", "sa", "OPWFMS-7KYGZ7SB", "test"); }