public ActionResult Result() { string decoded = DecodeCapturedPhoto(); if (decoded == "") { return(View("Error")); } BarCode barcode = BarCode.GetData(decoded); if (!barcode.valid) { ViewBag.QrResult = barcode.code + " are un format invalid"; } else if (!CheckIfRecordExists(barcode.code, barcode.quantity)) { ViewBag.QrResult = barcode.code + " nu a putut fi gasit in baza de date"; } else if (!DeleteEntry(barcode.code, barcode.quantity)) { ViewBag.QrResult = barcode.code + " nu a putut fi sters din baza de date"; } else { ViewBag.QrResult = barcode.code + " " + barcode.quantity + " a fost sters din baza de date"; } return(View()); }
private void Encode(BarCode data) { MessagingToolkit.QRCode.Codec.QRCodeEncoder encoder = new MessagingToolkit.QRCode.Codec.QRCodeEncoder(); encoder.QRCodeScale = 10; var bitmap = encoder.Encode(data.code + " " + data.quantity); Image generatedImage = (Image)bitmap; string currentTime = DateTime.Now.Year.ToString() + "." + DateTime.Now.Month.ToString() + "." + DateTime.Now.Day.ToString() + " " + DateTime.Now.Hour.ToString() + "." + DateTime.Now.Minute.ToString() + "." + DateTime.Now.Second.ToString(); generatedImage.Save(Server.MapPath("~/GeneratedImages/generated_qr" + currentTime + ".jpg"), System.Drawing.Imaging.ImageFormat.Jpeg); ViewBag.GeneratedQrImagePath = "~/GeneratedImages/generated_qr" + currentTime + ".jpg"; }
private bool SqlValid(BarCode data) { string dbCommand = ""; if (!CheckIfRecordExists(data.code)) { dbCommand = "INSERT INTO Produse VALUES('" + data.code + "', '" + data.quantity.ToString() + "')"; } if (!ExecuteDbCommand(dbCommand)) { return(false); } return(true); }
// GET: DataBase public ActionResult Index() { try { if (con.State == ConnectionState.Open) { con.Close(); } con.Open(); var model = new List <BarCode>(); SqlCommand cmd = con.CreateCommand(); cmd.CommandType = CommandType.Text; cmd.CommandText = "SELECT * FROM Produse"; cmd.ExecuteNonQuery(); SqlDataReader rdr = cmd.ExecuteReader(); while (rdr.Read()) { BarCode bc = new BarCode("", 0); bc.id = int.Parse(rdr["Id"].ToString()); bc.code = rdr["codProdus"].ToString(); bc.quantity = int.Parse(rdr["cantitate"].ToString()); model.Add(bc); } ViewBag.List = model; con.Close(); } catch { if (con.State == ConnectionState.Open) { con.Close(); } return(View("Error")); } if (con.State == ConnectionState.Open) { con.Close(); } return(View()); }
public ActionResult Index(string barcode) { BarCode codeData = BarCode.GetData(barcode); if (!codeData.valid || codeData.quantity <= 0) { return(View("Error")); } if (!SqlValid(codeData)) { return(View("Error")); } Encode(codeData); DecodeGeneratedCodes(); return(View()); }
public static BarCode GetData(string barcode) { BarCode generatedCode = new BarCode(barcode, 0, false); if (barcode.Split(' ').Length != 2) { return(generatedCode); } try { string code = barcode.Split(' ')[0]; int quantity = int.Parse(barcode.Split(' ')[1]); generatedCode.code = code; generatedCode.quantity = quantity; generatedCode.valid = true; } catch { return(generatedCode); } return(generatedCode); }