public static QuotationView GetOneQuote(int id)
{
OperationsEntities db = new OperationsEntities();
QuotationView quoteView = db.QuotationViews.Where(x => x.QuoteId == id).FirstOrDefault();
return(quoteView);
}
private void ToolStripButtonClicked(object sender, EventArgs e)
{
ToolStripButton tsbtn = (ToolStripButton)sender;
string tag = tsbtn.Tag.ToString();
foreach (ToolStripButton btn in tsSubMenu.Items)
{
btn.Font = new Font("Calibri", btn.Font.Size, FontStyle.Regular);
btn.BackColor = Color.WhiteSmoke;
}
tsbtn.Font = new Font("Calibri", tsbtn.Font.Size, FontStyle.Bold);
tsbtn.BackColor = Color.Gold;
UserControl uc = new UserControl();
switch (tag)
{
case "mViewer": uc = mouldview;
break;
case "mQuotation":
quotationview = new QuotationView();
quotationview.SavedEvent += new EventHandler(quotationview_SavedEvent);
uc = quotationview;
break;
}
this.LoadControl(uc);
}
public List <QuotationView> GetQuotationVersion(string custId)
{
QuotationDataAccess obj = new QuotationDataAccess();
var result = obj.GetQuotationUserVersions(custId);
List <QuotationView> quotations = new List <QuotationView>();
foreach (DataRow dr in result.Rows)
{
QuotationView quotation = new QuotationView();
quotation.QuotationId = Convert.ToInt64(dr["QuotationId"]);
quotation.Version = Convert.ToInt32(dr["VersionNumber"]);
quotations.Add(quotation);
}
return(quotations);
}
public List <QuotationView> GetAllQuotations(string CustName, int numberOfRecords, int pageNumber)
{
QuotationDataAccess obj = new QuotationDataAccess();
var result = obj.GetAllQuotations(CustName, numberOfRecords, pageNumber);
List <QuotationView> quotations = new List <QuotationView>();
foreach (DataRow dr in result.Rows)
{
QuotationView quotation = new QuotationView();
quotation.QuotationId = Convert.ToInt64(dr["QuotationId"]);
quotation.CustomerId = Convert.ToInt64(dr["CustomerId"]);
quotation.Version = Convert.ToInt32(dr["VersionNumber"]);
quotation.CustomerName = dr["Name"].ToString();
quotations.Add(quotation);
}
return(quotations);
}
public static JObject GetQuotationsOrders(FormCollection form = null)
{
OperationsEntities db = new OperationsEntities();
QuotationView quotationObj = new QuotationView();
string where = CommonHelper.AdvancedSearch <QuotationView>(form, quotationObj);
var quotationList = db.QuotationViews.Where(where.ToString())
.Select(x => new
{
x.QuoteId,
x.CarrierType,
x.OrderFrom,
x.CreateDate,
x.QuoteCode,
x.ShipperNameEn,
x.ConsigneeNameEn,
x.CarrierNameEn,
x.FromPort,
x.ToPort,
x.DateOfDeparture,
x.StatusName,
x.StatusId
})
.ToList();
JTokenWriter pJTokenWriter = new JTokenWriter();
JObject ordersJson = new JObject();
pJTokenWriter.WriteStartObject();
pJTokenWriter.WritePropertyName("data");
pJTokenWriter.WriteStartArray();
foreach (var item in quotationList)
{
pJTokenWriter.WriteStartObject();
pJTokenWriter.WritePropertyName("QuoteId");
pJTokenWriter.WriteValue(item.QuoteId);
pJTokenWriter.WritePropertyName("CarrierTypeImg");
switch (item.CarrierType)
{
case 1:
pJTokenWriter.WriteValue("<i class='fa fa-ship'></i>");
break;
case 2:
pJTokenWriter.WriteValue("<i class='fa fa-plane'></i>");
break;
}
pJTokenWriter.WritePropertyName("OrderFromText");
pJTokenWriter.WriteValue(item.OrderFrom == 1 ? "Export" : "Import");
pJTokenWriter.WritePropertyName("OrderFrom");
pJTokenWriter.WriteValue(item.OrderFrom);
pJTokenWriter.WritePropertyName("CarrierType");
pJTokenWriter.WriteValue(item.CarrierType);
pJTokenWriter.WritePropertyName("CreateDate");
pJTokenWriter.WriteValue(item.CreateDate.ToString("dd/MM/yyyy"));
pJTokenWriter.WritePropertyName("QuoteCode");
pJTokenWriter.WriteValue(item.QuoteCode);
pJTokenWriter.WritePropertyName("ShipperName");
pJTokenWriter.WriteValue(item.ShipperNameEn);
pJTokenWriter.WritePropertyName("ConsigneeName");
pJTokenWriter.WriteValue(item.ConsigneeNameEn);
pJTokenWriter.WritePropertyName("CarrierName");
pJTokenWriter.WriteValue(item.CarrierNameEn);
pJTokenWriter.WritePropertyName("FromPort");
pJTokenWriter.WriteValue(item.FromPort);
pJTokenWriter.WritePropertyName("ToPort");
pJTokenWriter.WriteValue(item.ToPort);
pJTokenWriter.WritePropertyName("DateOfDeparture");
pJTokenWriter.WriteValue(item.DateOfDeparture != null ? item.DateOfDeparture.Value.ToString("dd/MM/yyyy") : "");
pJTokenWriter.WritePropertyName("StatusName");
pJTokenWriter.WriteValue(item.StatusName);
pJTokenWriter.WritePropertyName("StatusId");
pJTokenWriter.WriteValue(item.StatusId);
pJTokenWriter.WriteEndObject();
}
pJTokenWriter.WriteEndArray();
pJTokenWriter.WriteEndObject();
ordersJson = (JObject)pJTokenWriter.Token;
return(ordersJson);
}
private void quotationview_SavedEvent(object sender, EventArgs e)
{
quotationview = new QuotationView();
quotationview.SavedEvent += new EventHandler(quotationview_SavedEvent);
this.LoadControl(quotationview);
}
