/// <summary> /// To Insert Upload Photo /// </summary> /// <param name="objUploadPhotoBO"></param> /// <returns></returns> public string InsertUploadPhoto(UploadPhotoBO objUploadPhotoBO) { UploadPhotoDAL UploadPhotoDAL = new UploadPhotoDAL(); //Data pass -to Database Layer try { return(UploadPhotoDAL.InsertUploadPhoto(objUploadPhotoBO)); } catch { throw; } finally { UploadPhotoDAL = null; } }
/// <summary> /// To Upload photo /// </summary> /// <param name="sender"></param> /// <param name="e"></param> protected void btnUpload_Click(object sender, EventArgs e) { if (photoFileUpload.HasFile) { string message = string.Empty; string AlertMessage = string.Empty; byte[] fileBytes = photoFileUpload.FileBytes; string FileName = photoFileUpload.FileName.ToString(); int splitcount = 0; string[] spiltValue = FileName.Split('.'); if (spiltValue.Length > 0) { string s = spiltValue[spiltValue.Length - 1]; if (s.ToLower() == "jpg" || s.ToLower() == "gif" || s.ToLower() == "png") { splitcount = splitcount + 1; } else { splitcount = 0; } } if (splitcount == 1) { int fileSize = photoFileUpload.PostedFile.ContentLength; Decimal MaxLength = Convert.ToDecimal(ConfigurationManager.AppSettings["UploadImageSize"].ToString()); if (fileSize <= MaxLength) { int HHID = Convert.ToInt32(Request.QueryString["HHID"]); string PhotoModule = Request.QueryString["PhotoModule"].ToString(); int otherHHID = Convert.ToInt32(Request.QueryString["PagePBID"]); objUploadPhotoBO = new UploadPhotoBO(); objUploadPhotoBLL = new UploadPhotoBLL(); objUploadPhotoBO.Hhid = HHID; objUploadPhotoBO.Photo = fileBytes; objUploadPhotoBO.UserID = Convert.ToInt32(Request.QueryString["userID"]); objUploadPhotoBO.PhotoModule = PhotoModule; objUploadPhotoBO.PKID = otherHHID; message = objUploadPhotoBLL.InsertUploadPhoto(objUploadPhotoBO); AlertMessage = "alert('" + message + "');"; if (string.IsNullOrEmpty(message) || message == "" || message == "null" || message == "-1") { message = "Photo uploaded successfully"; GetPhoto(); } AlertMessage = "alert('" + message + "');"; ScriptManager.RegisterClientScriptBlock(this, this.GetType(), "Added", AlertMessage, true); } else { message = "Cannot Upload. Uploaded file size exceeds the size limit."; AlertMessage = "alert('" + message + "');"; ScriptManager.RegisterClientScriptBlock(this, this.GetType(), "Added", AlertMessage, true); } } else { message = "Please Upload Photo of type jpg or gif or png."; AlertMessage = "alert('" + message + "');"; ScriptManager.RegisterClientScriptBlock(this, this.GetType(), "Added", AlertMessage, true); } } }
/// <summary> /// To Insert Upload Photo /// </summary> /// <param name="objUploadPhotoBO"></param> /// <returns></returns> public string InsertUploadPhoto(UploadPhotoBO objUploadPhotoBO) { string returnResult; OracleConnection cnn = new OracleConnection(AppConfiguration.ConnectionString); cnn.Open(); if (objUploadPhotoBO.PhotoModule == "PAPPB") { OracleCommand dcmd = new OracleCommand("USP_TRN_UPD_PHOTO_PERMSTRUCT", cnn); dcmd.CommandType = CommandType.StoredProcedure; int count = Convert.ToInt32(dcmd.CommandType); try { dcmd.Parameters.Add("P_PERM_STRUCTUREID", objUploadPhotoBO.PKID); dcmd.Parameters.Add("P_HHID", objUploadPhotoBO.Hhid); dcmd.Parameters.Add(new OracleParameter("PAPPSPHOTO_", OracleDbType.Blob)).Value = objUploadPhotoBO.Photo; dcmd.Parameters.Add("P_UPDATEDBY", objUploadPhotoBO.UserID); returnResult = Convert.ToString(dcmd.ExecuteNonQuery()); } catch { throw; } finally { dcmd.Dispose(); cnn.Close(); cnn.Dispose(); } } else if (objUploadPhotoBO.PhotoModule == "PAPNPB") { OracleCommand dcmd = new OracleCommand("USP_TRN_UPD_PHOTO_NPS", cnn); dcmd.CommandType = CommandType.StoredProcedure; int count = Convert.ToInt32(dcmd.CommandType); try { dcmd.Parameters.Add("N_NONPERM_STRUCTUREID", objUploadPhotoBO.PKID); dcmd.Parameters.Add("N_HHID", objUploadPhotoBO.Hhid); dcmd.Parameters.Add(new OracleParameter("PAPPSPHOTO_", OracleDbType.Blob)).Value = objUploadPhotoBO.Photo; dcmd.Parameters.Add("N_UPDATEDBY", objUploadPhotoBO.UserID); returnResult = Convert.ToString(dcmd.ExecuteNonQuery()); } catch (Exception ex) { throw ex; } finally { dcmd.Dispose(); cnn.Close(); cnn.Dispose(); } } else if (objUploadPhotoBO.PhotoModule == "DAMAGEDCROPS") { OracleCommand dcmd = new OracleCommand("USP_TRN_UPD_PHOTO_DAMCROP", cnn); dcmd.CommandType = CommandType.StoredProcedure; int count = Convert.ToInt32(dcmd.CommandType); try { dcmd.Parameters.Add("DAMAGECROPID", objUploadPhotoBO.PKID); dcmd.Parameters.Add("DAMAGEHHID", objUploadPhotoBO.Hhid); dcmd.Parameters.Add(new OracleParameter("DAMAGEPHOTO", OracleDbType.Blob)).Value = objUploadPhotoBO.Photo; dcmd.Parameters.Add("DAMAGEUPDATEDBY", objUploadPhotoBO.UserID); returnResult = Convert.ToString(dcmd.ExecuteNonQuery()); } catch (Exception ex) { throw ex; } finally { dcmd.Dispose(); cnn.Close(); cnn.Dispose(); } } else if (objUploadPhotoBO.PhotoModule == "PAPCROP") { OracleCommand dcmd = new OracleCommand("USP_TRN_UPD_PHOTO_PAPCROP", cnn); dcmd.CommandType = CommandType.StoredProcedure; int count = Convert.ToInt32(dcmd.CommandType); try { dcmd.Parameters.Add("PAP_CROPID_", objUploadPhotoBO.PKID); dcmd.Parameters.Add("HHID_", objUploadPhotoBO.Hhid); dcmd.Parameters.Add(new OracleParameter("CROPPHOTO_", OracleDbType.Blob)).Value = objUploadPhotoBO.Photo; dcmd.Parameters.Add("UPDATEDBY_", objUploadPhotoBO.UserID); returnResult = Convert.ToString(dcmd.ExecuteNonQuery()); } catch { throw; } finally { dcmd.Dispose(); cnn.Close(); cnn.Dispose(); } } else if (objUploadPhotoBO.PhotoModule == "PAPGRAVE") { OracleCommand dcmd = new OracleCommand("USP_TRN_UPD_PHOTO_PAPGRAVE", cnn); dcmd.CommandType = CommandType.StoredProcedure; int count = Convert.ToInt32(dcmd.CommandType); try { dcmd.Parameters.Add("PAP_GRAVEID_", objUploadPhotoBO.PKID); dcmd.Parameters.Add("HHID_", objUploadPhotoBO.Hhid); dcmd.Parameters.Add(new OracleParameter("GRAVEPHOTO_", OracleDbType.Blob)).Value = objUploadPhotoBO.Photo; dcmd.Parameters.Add("UPDATEDBY_", objUploadPhotoBO.UserID); returnResult = Convert.ToString(dcmd.ExecuteNonQuery()); } catch { throw; } finally { dcmd.Dispose(); cnn.Close(); cnn.Dispose(); } } else if (objUploadPhotoBO.PhotoModule == "PAPFENCE") { OracleCommand dcmd = new OracleCommand("USP_TRN_UPD_PHOTO_PAPFENCE", cnn); dcmd.CommandType = CommandType.StoredProcedure; int count = Convert.ToInt32(dcmd.CommandType); try { dcmd.Parameters.Add("PAP_FENCEID_", objUploadPhotoBO.PKID); dcmd.Parameters.Add("HHID_", objUploadPhotoBO.Hhid); dcmd.Parameters.Add(new OracleParameter("FENCEPHOTO_", OracleDbType.Blob)).Value = objUploadPhotoBO.Photo; dcmd.Parameters.Add("UPDATEDBY_", objUploadPhotoBO.UserID); returnResult = Convert.ToString(dcmd.ExecuteNonQuery()); } catch { throw; } finally { dcmd.Dispose(); cnn.Close(); cnn.Dispose(); } } else if (objUploadPhotoBO.PhotoModule == "PAPCP") { OracleCommand dcmd = new OracleCommand("USP_TRN_UPD_PHOTO_PAPCULTURAL", cnn); dcmd.CommandType = CommandType.StoredProcedure; int count = Convert.ToInt32(dcmd.CommandType); try { dcmd.Parameters.Add("CULTURALPROPID_", objUploadPhotoBO.PKID); dcmd.Parameters.Add("HHID_", objUploadPhotoBO.Hhid); dcmd.Parameters.Add(new OracleParameter("CULTURALPROPPHOTO_", OracleDbType.Blob)).Value = objUploadPhotoBO.Photo; dcmd.Parameters.Add("UPDATEDBY_", objUploadPhotoBO.UserID); returnResult = Convert.ToString(dcmd.ExecuteNonQuery()); } catch { throw; } finally { dcmd.Dispose(); cnn.Close(); cnn.Dispose(); } } else if (objUploadPhotoBO.PhotoModule == "PAPOHFIX") { OracleCommand dcmd = new OracleCommand("USP_TRN_UPDPHOTOPAPOHRFIX", cnn); dcmd.CommandType = CommandType.StoredProcedure; int count = Convert.ToInt32(dcmd.CommandType); try { dcmd.Parameters.Add("PAP_FIXTUREID_", objUploadPhotoBO.PKID); dcmd.Parameters.Add("HHID_", objUploadPhotoBO.Hhid); dcmd.Parameters.Add(new OracleParameter("FIXTUREPHOTO_", OracleDbType.Blob)).Value = objUploadPhotoBO.Photo; dcmd.Parameters.Add("UPDATEDBY_", objUploadPhotoBO.UserID); returnResult = Convert.ToString(dcmd.ExecuteNonQuery()); } catch { throw; } finally { dcmd.Dispose(); cnn.Close(); cnn.Dispose(); } } //PAPOHFIX else { OracleCommand dcmd = new OracleCommand("USP_TRN_UPD_PAP_PHOTO", cnn); dcmd.CommandType = CommandType.StoredProcedure; int count = Convert.ToInt32(dcmd.CommandType); try { dcmd.Parameters.Add("HHID_", objUploadPhotoBO.Hhid); if (objUploadPhotoBO.Photo != null) { dcmd.Parameters.Add(new OracleParameter("PAPPHOTO_", OracleDbType.Blob)).Value = objUploadPhotoBO.Photo; } else { dcmd.Parameters.Add("PAPPHOTO_", Oracle.DataAccess.Types.OracleBlob.Null); } //dcmd.Parameters.Add(new OracleParameter("PAPPHOTO_", OracleDbType.Blob)).Value = objUploadPhotoBO.Photo; dcmd.Parameters.Add("Updatedby_", objUploadPhotoBO.UserID); returnResult = Convert.ToString(dcmd.ExecuteNonQuery()); } catch { throw; } finally { dcmd.Dispose(); cnn.Close(); cnn.Dispose(); } } return(returnResult); }