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");
}
