void FillBackSideTextByDrawText(Graphics gr, VehicleLicense obj)
{
const int textMainMargin = 468;
const int textMargin = textMainMargin + 41;
const int textWidth = 450;
GraphicsHelper.DrawText(gr, "9.", textMainMargin, 38);
GraphicsHelper.DrawText(gr, obj.Vehicle.YearOfManufacture.ToString(), textMargin, 38, textWidth);
GraphicsHelper.DrawText(gr, "10.", textMainMargin, 88);
GraphicsHelper.DrawText(gr, obj.Vehicle.Type.ToUpper(), textMargin, 88, textWidth);
GraphicsHelper.DrawText(gr, "11.", textMainMargin, 138);
//GraphicsHelper.DrawText(gr, obj.Vehicle.RegNumber.ToUpper(), textMargin, 138, textWidth);
GraphicsHelper.DrawText(gr, "12.", textMainMargin, 190);
GraphicsHelper.DrawText(gr, obj.Vehicle.GrossWeight.ToString("n2"), textMargin, 190, textWidth);
GraphicsHelper.DrawText(gr, "13.", textMainMargin, 242);
GraphicsHelper.DrawText(gr, obj.Vehicle.CurbWeight.ToString("n2"), textMargin, 242, textWidth);
GraphicsHelper.DrawText(gr, "14.", textMainMargin, 293);
GraphicsHelper.DrawText(gr, obj.Vehicle.EngineNumber.ToUpper(), textMargin, 293, textWidth);
GraphicsHelper.DrawText(gr, "15.", textMainMargin, 345);
GraphicsHelper.DrawText(gr, obj.Vehicle.EnginePower.ToString(), textMargin, 345, textWidth);
GraphicsHelper.DrawText(gr, "16.", textMainMargin, 395);
GraphicsHelper.DrawText(gr, obj.Vehicle.FuelType.ToUpper(), textMargin, 395, textWidth);
GraphicsHelper.DrawText(gr, "17.", textMainMargin, 448);
GraphicsHelper.DrawText(gr, obj.Vehicle.NumberOfSeats.ToSafeString(), textMargin, 448, textWidth);
GraphicsHelper.DrawText(gr, "18.", textMainMargin, 499);
GraphicsHelper.DrawText(gr, obj.Vehicle.NumberOfStandees.ToSafeString(), textMargin, 499, textWidth);
GraphicsHelper.DrawText(gr, "19.", textMainMargin, 549);
GraphicsHelper.DrawText(gr, obj.Vehicle.SpecialMarks.ToUpper(), textMargin, 549, textWidth);
}
public Bitmap CreateBackCard(VehicleLicense obj)
{
var canvasWidthInPixel = (int)Math.Round(GraphicsHelper.Dpi * GraphicsHelper.CanvasWidth);
var canvasHeightInPixel = (int)Math.Round(GraphicsHelper.Dpi * GraphicsHelper.CanvasHeight);
var cardBitmap = new Bitmap(canvasWidthInPixel, canvasHeightInPixel, PixelFormat.Format32bppArgb);
cardBitmap.SetResolution(GraphicsHelper.Dpi, GraphicsHelper.Dpi);
//var background = Background;
using (var gr = Graphics.FromImage(cardBitmap))
{
gr.SmoothingMode = SmoothingMode.HighQuality;
gr.InterpolationMode = InterpolationMode.HighQualityBicubic;
gr.PixelOffsetMode = PixelOffsetMode.HighQuality;
gr.TextRenderingHint = TextRenderingHint.ClearTypeGridFit;
gr.PageUnit = GraphicsUnit.Pixel;
gr.CompositingQuality = CompositingQuality.HighQuality;
gr.Clear(Color.Transparent);
//gr.DrawImage(background, 0, 0, canvasWidthInPixel, canvasHeightInPixel);
FillBackSideTextByDrawText(gr, obj);
}
return(cardBitmap);
}
void FillFrontSideTextByDrawText(Graphics gr, VehicleLicense obj)
{
var textMargin = GraphicsHelper.DefaultMainTextMargin + 26;
GraphicsHelper.DrawMainText(gr, "1.", 146);
GraphicsHelper.DrawText(gr, obj.Vehicle.RegNumber.ToUpper(), textMargin, 146);
GraphicsHelper.DrawMainText(gr, "2.", 183);
GraphicsHelper.DrawText(gr, obj.ModelName.ToUpper(), textMargin, 183);
GraphicsHelper.DrawMainText(gr, "3.", 220);
GraphicsHelper.DrawText(gr, obj.Color.ToUpper(), textMargin, 220);
GraphicsHelper.DrawMainText(gr, "4.", 257);
//GraphicsHelper.DrawText(gr, obj.Owner.ToUpper(), textMargin, 257, GraphicsHelper.DefaultTextBlockWidth, 65);
GraphicsHelper.DrawMainText(gr, "5.", 330);
//GraphicsHelper.DrawText(gr, obj.Address, textMargin, 330, GraphicsHelper.DefaultTextBlockWidth, 85);
GraphicsHelper.DrawMainText(gr, "6.", 425);
var dt = obj.DateOfIssue.ToShortDateString();
GraphicsHelper.DrawText(gr, dt.ToUpper(), textMargin, 425);
GraphicsHelper.DrawMainText(gr, "7.", 466);
GraphicsHelper.DrawText(gr, obj.PlaceOfIssue.ToUpper(), textMargin, 466);
GraphicsHelper.DrawMainText(gr, "8.", 510);
//GraphicsHelper.DrawText(gr, obj.PersonalNumber.ToUpper(), textMargin, 510);
}
public static List <VehicleLicense> GetItems(int isInd, int skip)
{
var etc = "ORDER BY Id DESC LIMIT 50";
if (skip > 0)
{
etc = String.Format("ORDER BY Id DESC LIMIT 50 OFFSET {0}", skip);
}
var db = new DbHelper(Setting.VlDbPath);
var table = db.FetchAll("VehicleLicenses", String.Format("WHERE IsIndividual = {0}", isInd), etc);
if (ReferenceEquals(table, null))
{
_lastError = db.LastError;
return(null);
}
var rs = new List <VehicleLicense>();
for (var i = 0; i < table.Rows.Count; i++)
{
var row = table.Rows[i];
var id = row["Id"].ConvertTo <long>();
var stateNumberPlate = row["StateNumberPlate"].ConvertTo <string>();
var make = row["Make"].ConvertTo <string>();
var model = row["Model"].ConvertTo <string>();
var color = row["Color"].ConvertTo <string>();
var region = row["Region"].ConvertTo <string>();
var city = row["City"].ConvertTo <string>();
var address = row["Address"].ConvertTo <string>();
var placeOfIssue = row["PlaceOfIssue"].ConvertTo <string>();
var personalNumber = row["PersonalNumber"].ConvertTo <string>();
var lastName = row["LastName"].ConvertTo <string>();
var firstName = row["FirstName"].ConvertTo <string>();
var middleName = row["MiddleName"].ConvertTo <string>();
var type = row["Type"].ConvertTo <string>();
var vehicleIdentificationNumber = row["VehicleIdentificationNumber"].ConvertTo <string>();
var engineNumber = row["EngineNumber"].ConvertTo <string>();
var fuelType = row["FuelType"].ConvertTo <string>();
var specialMarks = row["SpecialMarks"].ConvertTo <string>();
var companyName = row["CompanyName"].ConvertTo <string>();
var yearOfManufacture = row["YearOfManufacture"].ConvertTo <int>();
var enginePower = row["EnginePower"].ConvertTo <int>();
var numberOfSeats = row["NumberOfSeats"].ConvertTo <int>();
var numberOfStandees = row["NumberOfStandees"].ConvertTo <int>();
var grossWeight = row["GrossWeight"].ConvertTo <decimal>();
var curbWeight = row["CurbWeight"].ConvertTo <decimal>();
var dateOfIssue = row["DateOfIssue"].ConvertTo <DateTime>();
var isSentToPrint = row["IsSentToPrint"].ConvertTo <bool>();
var isIndividual = row["IsIndividual"].ConvertTo <bool>();
var item = new VehicleLicense
{
Id = id,
//StateNumberPlate = stateNumberPlate,
//Make = make,
//Model = model,
//MakeModel = String.Format("{0} / {1}", make, model),
//Color = color,
//Region = region,
//City = city,
//Address = address,
//LastName = lastName,
//FirstName = firstName,
//MiddleName = middleName,
//Type = type,
//PlaceOfIssue = placeOfIssue,
//PersonalNumber = personalNumber,
//Inn = personalNumber,
//VehicleIdentificationNumber = vehicleIdentificationNumber,
//EngineNumber = engineNumber,
//FuelType = fuelType,
//SpecialMarks = specialMarks,
//YearOfManufacture = yearOfManufacture,
//EnginePower = enginePower,
//NumberOfSeats = numberOfSeats,
//NumberOfStandees = numberOfStandees,
//GrossWeight = grossWeight,
//CurbWeight = curbWeight,
//DateOfIssue = dateOfIssue,
//IsSentToPrint = isSentToPrint,
//EnginePowerStr = enginePower.ToSafeString(),
//YearOfManufactureStr = yearOfManufacture.ToSafeString(),
//CompanyName = companyName,
//IsIndividual = isIndividual
};
rs.Add(item);
}
return(rs);
}
