/// <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);
}
