protected void ButtonAssUpdate_Click(object sender, EventArgs e)
{
string filepath = "~/AssetImages/";
string filename = Path.GetFileName(FileUploadImg.PostedFile.FileName);
if (filename == "" || filename == null)
{
filepath = global_filepath;
}
else
{
FileUploadImg.SaveAs(Server.MapPath("AssetImages/" + filename));
filepath = "~/AssetImages/" + filename;
}
string squery = "Update [dbo].[AssetDescription] SET Status=@Status,Serial_Number=@Serial_Number,Category=@Category,Model=@Model,Description=@Description,Imgpath=@Imgpath WHERE Asset_ID='" + TextBoxAdAssID.Text + "' ";
SqlConnection con = new SqlConnection(strcon);
con.Open();
SqlCommand com = new SqlCommand(squery, con);
com.Parameters.AddWithValue("@Status", DropDownListStatus.SelectedItem.Text);
com.Parameters.AddWithValue("@Serial_Number", TextBoxSerial.Text);
com.Parameters.AddWithValue("@Category", DropDownListSelCat3.SelectedItem.Text);
com.Parameters.AddWithValue("@Model", DropDownListMod3.SelectedItem.Text);
com.Parameters.AddWithValue("@Description", TextBoxDes.Text);
com.Parameters.AddWithValue("@Imgpath", filepath);
}
protected void UploadFile(object sender, EventArgs e)
{
string folderPath = Server.MapPath("~/Files/");
if (Directory.Exists(folderPath) && FileUploadImg.HasFile && FileUploadImg.FileName != "")
{
//Save the File to the Directory (Folder).
string filename = folderPath + Path.GetFileName(FileUploadImg.FileName);
byte[] filearray = FileUploadImg.FileBytes;
FileUploadImg.SaveAs(filename);
//Display the Picture in Image control.
Image2.ImageUrl = "~/Files/" + Path.GetFileName(FileUploadImg.FileName);
// Send to blob
// For test we consider we have CAMERA1...CAMERA2
string req = "select enter from camera_pictures order by id desc";
ArrayList results = config.Select(req);
string enter = "1";
for (int l = 0; l < 1; l++)
{
NameValueCollection row = (NameValueCollection)results[l];
enter = row["enter"];
}
string camera = (enter == "1")? "CAMERA1": "CAMERA2";
config.writeCameraBlob(camera, enter, filearray);
labelSimuation.Text += "<br />" + getDateTimeNow() + " : " + camera + " " + enter;
}
}
protected void BtnUploadImg_Click(object sender, EventArgs e)
{
//(Andrew Muncey, 2013)
string productID = Request.QueryString["ID"];
string filename = productID + ".jpg";
string saveLocation = Server.MapPath("~/images" + filename);
FileUploadImg.SaveAs(saveLocation);
}
protected void ManageInsertsSubmitBtn_Click(object sender, EventArgs e)
{
Product p = new Product();
//Get user input from textboxes and put them into variables
string InsertCategory = manageInsertCategory.Text;
string InsertName = manageInsertName.Text;
int InsertStock = Convert.ToInt32(manageInsertStock.Text);
string InsertDescription = manageInsertDescription.Text;
double InsertPrice = Convert.ToDouble(manageInsertPrice.Text);
string InsertImage = "../img/" + Convert.ToString(FileUploadImg.FileName);
// Checks to see if all fields of user input are valid
if (IsValid)
{
/* Author:
* Use: To allow for an image to be uploaded and check for correct file type
* Website Name: ASP.net webform Tutorials
* Website Url: https://asp.net-tutorials.com/controls/file-upload-control
* Date: 11/04/19
* Page Used: ManageItems.aspx, ManageItems.aspx.cs
*/
//Check if image file is a certain type
if (FileUploadImg.PostedFile.ContentType == "image/jpeg" || FileUploadImg.PostedFile.ContentType == "image/png" || FileUploadImg.PostedFile.ContentType == "image/jpg")
{
//Error text is switched to invisible
insertImageFileError.Visible = false;
/* Author: Kudvenkat
* Use: Used to upload an image into the project
* Website Name: Fileupload control in asp.net Part 30 (4.40 seconds)
* Website Url: https://www.youtube.com/watch?v=irF6Zomjxwc&feature=youtu.be
* Date: 11/04/19
* Pahe used: ManageItems.aspx.cs
*/
//Save image into project
FileUploadImg.SaveAs(Server.MapPath("~/img/" + FileUploadImg.FileName));
//Add data inserted in globalData as a new product
p.Category = InsertCategory;
p.Name = InsertName;
p.Stock = InsertStock;
p.Description = InsertDescription;
p.Price = InsertPrice;
p.Quantity = 1;
p.Image = InsertImage;
QueryClass.AddProduct(p);
Response.Redirect("ManageProducts.aspx");
}
else
{
//Display error message by making text visible
insertImageFileError.Visible = true;
}
}
}
protected void btnUpload_Click(object sender, EventArgs e)
{
string directory = Server.MapPath(null);
if (!Directory.Exists(directory + "\\Signature"))
{
Directory.CreateDirectory(directory + "\\Signature");
}
else
{
}
if (FileUploadImg.HasFile)
{
ext = System.IO.Path.GetExtension(FileUploadImg.FileName);
if (ext.ToLower() != ".jpg" && ext.ToLower() != ".png" && ext.ToLower() != ".gif" && ext.ToLower() != ".jpeg")
{
lbUploadMessage.Text = "A valid image file is required!";
}
else
{
try
{
//string filename = Path.GetFileName(FileUploadImg.FileName);
lblext.Text = ext;
string filename = RadioButtonList1.SelectedValue + "(" + DeliveryDate.getDeliveryDate() + ")";
FileUploadImg.SaveAs(Server.MapPath("~/") + "\\Signature\\" + filename + ext);
imgCover.ImageUrl = "~/Signature/" + filename + ext;
lbUploadMessage.Text = "Upload status: File uploaded!";
}
catch (Exception ex)
{
lbUploadMessage.Text = "Upload status: The file could not be uploaded. The following error occured: " + ex.Message;
}
}
}
else
{
}
}
protected void ButtonUpload_Click(object sender, EventArgs e)
{
if (FileUploadImg.HasFile)
{
if (TextBoxImage.Text != "")
{
FileUploadImg.SaveAs(Server.MapPath("~/Pictures/") + TextBoxImage.Text.Trim());
LabelFileinfo.Text = "Image added to Picture folder.";
}
else
{
LabelFileinfo.Text = "Filename missing.";
}
}
else
{
LabelFileinfo.Text = "Wrong file name.";
}
}
// Modificar Material
protected void btnModificar_Click(object sender, EventArgs e)
{
try
{
Boolean fileOK = false;
String rutaMaterial = Server.MapPath("~/App_Data/Materiales/");
String rutaImagen = Server.MapPath("~/Vista/imgMateriales/");
if (FileUploadMaterial.HasFile)
{
String fileExtension = System.IO.Path.GetExtension(FileUploadMaterial.FileName).ToLower();
String[] extensionesValidas = { ".zip", ".rar", ".iso" };
for (int i = 0; i < extensionesValidas.Length; i++)
{
if (fileExtension == extensionesValidas[i])
{
fileOK = true;
}
}
if (fileOK)
{
String fileName = FileUploadMaterial.FileName;
rutaMaterial += fileName;
FileUploadMaterial.SaveAs(rutaMaterial);
//labelMaterial.Text = "Archivo Cargado!";
}
else
{
throw new Exception("Solo se adminten archivos de tipo .rar .zip o .iso");
//labelMaterial.Text = "Cannot accept files of this type.";
}
}
if (FileUploadImg.HasFile)
{
String fileExtension = System.IO.Path.GetExtension(FileUploadImg.FileName).ToLower();
String[] extensionesValidas = { ".jpg", ".jpeg", ".png", ".gif" };
for (int i = 0; i < extensionesValidas.Length; i++)
{
if (fileExtension == extensionesValidas[i])
{
fileOK = true;
}
}
if (fileOK)
{
String fileName = FileUploadImg.FileName;
rutaImagen += fileName;
FileUploadImg.SaveAs(rutaImagen);
//labelMaterial.Text = "Archivo Cargado!";
}
else
{
throw new Exception("Solo se adminten archivos de tipo .jpg .jpeg .png o .gif");
//labelMaterial.Text = "Cannot accept files of this type.";
}
}
Material objMaterial = new Material();
Area[] objAreas = new Area[listBoxArea.Items.Count];
Audiencia[] objAudiencias = new Audiencia[listBoxAudiencia.Items.Count];
Autor[] objAutores = new Autor[listBoxAutor.Items.Count];
Formato[] objFormatos = new Formato[listBoxFormato.Items.Count];
Keyword[] objKeywords = new Keyword[listBoxKeyword.Items.Count];
Lenguaje[] objLenguajes = new Lenguaje[listBoxLenguaje.Items.Count];
objMaterial.IdMaterial = txtIdmaterial.Text;
objMaterial.Titulo = txtTitulomaterial.Text;
objMaterial.Descripcion = txtDescripcion.Text;
objMaterial.Requerimientos = txtRequerimientos.Text;
objMaterial.Tipo = txtTipomaterial.Text;
objMaterial.Ruta = rutaMaterial;
objMaterial.Imagen = rutaImagen;
//objMaterial.FechaIngreso = DateTime.Parse(txtfechaIngreso.Text);
//objMaterial.FechaModificacion = DateTime.Parse(txtFechamodificacion.Text);
objMaterial.Propietario = txtPropietario.Text;
objMaterial.Movil = checkMovil.Checked;
objMaterial.Costo = Double.Parse(txtCosto.Text);
for (int i = 0; i < listBoxArea.Items.Count; i++)
{
// replicar en los demás metadatos
Console.WriteLine("listBoxArea: " + listBoxArea.ToString());
Console.WriteLine("listBoxArea.Itemns.Count: " + listBoxArea.Items.Count);
objAreas[i] = new Area();
objAreas[i].Nombre = listBoxArea.Items[i].Text;
Console.WriteLine("objAreas[" + i + "]: " + objAreas[i].Nombre);
}
for (int i = 0; i < listBoxAudiencia.Items.Count; i++)
{
objAudiencias[i] = new Audiencia();
objAudiencias[i].Nombre = listBoxAudiencia.Items[i].Text;
}
for (int i = 0; i < listBoxAutor.Items.Count; i++)
{
objAutores[i] = new Autor();
objAutores[i].Nombre = listBoxAutor.Items[i].Text;
}
for (int i = 0; i < listBoxFormato.Items.Count; i++)
{
objFormatos[i] = new Formato();
objFormatos[i].Nombre = listBoxFormato.Items[i].Text;
}
for (int i = 0; i < listBoxKeyword.Items.Count; i++)
{
objKeywords[i] = new Keyword();
objKeywords[i].Nombre = listBoxKeyword.Items[i].Text;
}
for (int i = 0; i < listBoxLenguaje.Items.Count; i++)
{
objLenguajes[i] = new Lenguaje();
objLenguajes[i].Nombre = listBoxLenguaje.Items[i].Text;
}
objMaterial.Areas = objAreas;
objMaterial.Audiencia = objAudiencias;
objMaterial.Autores = objAutores;
objMaterial.Formatos = objFormatos;
objMaterial.Keywords = objKeywords;
objMaterial.Lenguajes = objLenguajes;
controlMaterial objControl = new controlMaterial(objMaterial);
labelMaterial.Text = objControl.modificarMaterial();
}
catch (Exception objExc)
{
labelMaterial.Text = objExc.Message;
}
}
