public static bool SetAlbumPassword(string ApplicationID, string Password, MatrimonialAlbumManager.ImageType imageType)
{
/* * * * * * * * * * * * * * * * * * * * * * * * * * * *
* Procedure Name : UserAlbum_SetHoroscopePassword
* : UserAlbum_SetPhotoPassword
* * * * * * * * * * * * * * * * * * * * * * * * * * * *
* Type: UPDATE
* * * * * * * * * * * * * * * * * * * * * * * * * * * *
* Parameters :
* * * * * * * * * * * * * * * * * * * * * * * * * * * *
* @ApplicationID - varchar(25)
* @HoroPassword - varchar(25)
* @PhotoPassword - varchar(25)
* * * * * * * * * * * * * * * * * * * * * * * * * * * */
using (SqlConnection objConnection = DBConnection.GetSqlConnection())
{
try
{
//Inserting data into
//Creating Command object
SqlCommand objCommand = new SqlCommand("UserAlbum_SetPhotoPassword", objConnection);
objCommand.CommandType = CommandType.StoredProcedure;
//Adding new Parameters
if (imageType == MatrimonialAlbumManager.ImageType.Horoscope)
{
objCommand = new SqlCommand("UserAlbum_SetHoroscopePassword", objConnection);
objCommand.CommandType = CommandType.StoredProcedure;
}
objCommand.Parameters.Add(new SqlParameter("@Password", SqlDbType.VarChar));
objCommand.Parameters["@Password"].Value = Password;
objCommand.Parameters.Add(new SqlParameter("@ApplicationID", SqlDbType.VarChar));
objCommand.Parameters["@ApplicationID"].Value = ApplicationID;
objConnection.Open();
int intTemp = objCommand.ExecuteNonQuery();
objConnection.Close();
return(true);
}
catch (Exception)
{
objConnection.Close();
return(false);
}
}
}
protected void IB_Crop_Click(object sender, ImageClickEventArgs e)
{
try
{
MatrimonialAlbumManager.ImageType enuImageType = MatrimonialAlbumManager.ImageType.Photo;
switch (Convert.ToSByte(Session["ImageID"]))
{
case 1:
enuImageType = MatrimonialAlbumManager.ImageType.Photo;
break;
case 2:
enuImageType = MatrimonialAlbumManager.ImageType.Album1;
break;
case 3:
enuImageType = MatrimonialAlbumManager.ImageType.Album2;
break;
case 4:
enuImageType = MatrimonialAlbumManager.ImageType.Album3;
break;
default:
Response.Redirect("image.aspx?id=Error");
break;
}
///GetImage
byte[] byteArray = (byte[])Session["ImageToCrop"];
// Removing image from session
Session.Remove("ImageToCrop");
/// Get Application String
HttpCookieCollection objHttpCookieCollection = Request.Cookies;
HttpCookie objHttpCookie = objHttpCookieCollection.Get("MatCookie5639sb");
string strApplicationID = Crypto.DeCrypto(objHttpCookie.Values["ApplicationID"]);
/// crop image
byteArray = EditImage.CropImageFile(byteArray, Convert.ToInt32(HiddenW.Value), Convert.ToInt32(HiddenH.Value), Convert.ToInt32(HiddenX.Value), Convert.ToInt32(HiddenY.Value));
/// make thumbnail
if (enuImageType == MatrimonialAlbumManager.ImageType.Photo)
{
byteArray = EditImage.GetThumbNail(byteArray, 128, 128, false);
}
else
{
byteArray = EditImage.GetThumbNail(byteArray, 600, 600, true);
}
/// water mark image
byteArray = EditImage.SetWatermark(byteArray, WebConfig.GetValues("FName"), 80, true, 16);
//Which image is to be uploaded ?
/// Add new image(Insert) or change newimage (Update) ?
switch (MatrimonialAlbumManager.IsAlbumExists(strApplicationID))
{
case false:
// Insert Image into database
if (MatrimonialAlbumManager.InsertPhoto(strApplicationID, byteArray, enuImageType))
{
Response.Redirect("../Extras/Sucess.aspx");
}
else
{
Response.Redirect("image.aspx?id=Error");
}
break;
case true: // Update Image
if (MatrimonialAlbumManager.InsertPhoto(strApplicationID, byteArray, enuImageType))
{
Response.Redirect("../Extras/Sucess.aspx");
}
else
{
Response.Redirect("image.aspx?id=Error");
}
break;
default:
Response.Redirect("imaxge.aspx?id=Error");
break;
}
}
catch (Exception)
{
}
}
public static byte[] GetProtectedImage(string ToID, string FromID, MatrimonialAlbumManager.ImageType imageType)
{
/* * * * * * * * * * * * * * * * * * * * * * * * * * * *
* Procedure Name : UserAlbum_GetProtectedImage
* * * * * * * * * * * * * * * * * * * * * * * * * * * *
* Type: SELECT
* * * * * * * * * * * * * * * * * * * * * * * * * * * *
* Parameters :
* * * * * * * * * * * * * * * * * * * * * * * * * * * *
* @FromID varchar(15)
* @ToID varchar(15)
* @Type smallint
* * * * * * * * * * * * * * * * * * * * * * * * * * * */
byte[] byteImageArray = null;
using (SqlConnection objConnection = DBConnection.GetSqlConnection())
{
try
{
SqlCommand objCommand;
SqlDataReader objReader;
//Creating Command object
objCommand = new SqlCommand("UserAlbum_GetProtectedImage", objConnection);
objCommand.CommandType = CommandType.StoredProcedure;
//Adding new Parameters
objCommand.Parameters.Add(new SqlParameter("@FromID", SqlDbType.VarChar));
objCommand.Parameters["@FromID"].Value = FromID;
//Adding new Parameters
objCommand.Parameters.Add(new SqlParameter("@ToID", SqlDbType.VarChar));
objCommand.Parameters["@ToID"].Value = ToID;
switch (imageType)
{
case MatrimonialAlbumManager.ImageType.Photo:
//Adding new Parameters
objCommand.Parameters.Add(new SqlParameter("@Type", SqlDbType.TinyInt));
objCommand.Parameters["@Type"].Value = 1;
break;
case MatrimonialAlbumManager.ImageType.Album1:
//Adding new Parameters
objCommand.Parameters.Add(new SqlParameter("@Type", SqlDbType.TinyInt));
objCommand.Parameters["@Type"].Value = 2;
break;
case MatrimonialAlbumManager.ImageType.Album2:
//Adding new Parameters
objCommand.Parameters.Add(new SqlParameter("@Type", SqlDbType.TinyInt));
objCommand.Parameters["@Type"].Value = 3;
break;
case MatrimonialAlbumManager.ImageType.Album3:
//Adding new Parameters
objCommand.Parameters.Add(new SqlParameter("@Type", SqlDbType.TinyInt));
objCommand.Parameters["@Type"].Value = 4;
break;
case MatrimonialAlbumManager.ImageType.Horoscope:
//Adding new Parameters
objCommand.Parameters.Add(new SqlParameter("@Type", SqlDbType.TinyInt));
objCommand.Parameters["@Type"].Value = 5;
break;
default: throw new Exception("Image type not found");
}
objConnection.Open();
objReader = objCommand.ExecuteReader();
objReader.Read();
byteImageArray = (byte[])objReader["IMAGE"];
objReader.Close();
objReader = null;
objConnection.Close();
}
catch (Exception EX)
{
ErrorLog.WriteErrorLog("GetData- GetProtectedImage- From:" + FromID + " To :" + ToID, EX);
objConnection.Close();
byteImageArray = null;
}
}
return(byteImageArray);
}
public static bool IsImageExists(string ApplicationID, MatrimonialAlbumManager.ImageType imageType)
{
/* * * * * * * * * * * * * * * * * * * * * * * * * * * *
* Procedure Name : UserAlbum_IsImageExists
* * * * * * * * * * * * * * * * * * * * * * * * * * * *
* Type: SELECT
* * * * * * * * * * * * * * * * * * * * * * * * * * * *
* Parameters :
* * * * * * * * * * * * * * * * * * * * * * * * * * * *
* @ApplicationID varchar(25)
* @Flag Tinyint
* * * * * * * * * * * * * * * * * * * * * * * * * * * *
* Flag bit
* * * * * * * * * * * * * * * * * * * * * * * * * * * */
using (SqlConnection objConnection = DBConnection.GetSqlConnection())
{
try
{
SqlCommand objCommand;
SqlDataReader objReader;
objCommand = new SqlCommand("UserAlbum_IsImageExists", objConnection);
objCommand.CommandType = CommandType.StoredProcedure;
//Adding new Parameters
objCommand.Parameters.Add(new SqlParameter("@ID", SqlDbType.VarChar));
objCommand.Parameters["@ID"].Value = ApplicationID;
switch (imageType)
{
case MatrimonialAlbumManager.ImageType.Photo:
//Adding new Parameters
objCommand.Parameters.Add(new SqlParameter("@Flag", SqlDbType.TinyInt));
objCommand.Parameters["@Flag"].Value = 0;
break;
case MatrimonialAlbumManager.ImageType.Album1:
//Adding new Parameters
objCommand.Parameters.Add(new SqlParameter("@Flag", SqlDbType.TinyInt));
objCommand.Parameters["@Flag"].Value = 1;
break;
case MatrimonialAlbumManager.ImageType.Album2:
objCommand.Parameters.Add(new SqlParameter("@Flag", SqlDbType.TinyInt));
objCommand.Parameters["@Flag"].Value = 2;
break;
case MatrimonialAlbumManager.ImageType.Album3:
objCommand.Parameters.Add(new SqlParameter("@Flag", SqlDbType.TinyInt));
objCommand.Parameters["@Flag"].Value = 3;
break;
case MatrimonialAlbumManager.ImageType.Horoscope:
objCommand.Parameters.Add(new SqlParameter("@Flag", SqlDbType.TinyInt));
objCommand.Parameters["@Flag"].Value = 4;
break;
default:
return(false);
}
objConnection.Open();
objReader = objCommand.ExecuteReader();
objReader.Read();
bool boolreturn = Convert.ToBoolean(objReader["Flag"]);
objReader = null;
objConnection.Close();
return(boolreturn);
}
catch (Exception)
{
objConnection.Close();
return(false);
}
}
}
public static bool IsImageProtected(string ApplicationID, MatrimonialAlbumManager.ImageType imageType)
{
/* * * * * * * * * * * * * * * * * * * * * * * * * * * *
* Procedure Name : UserAlbum_IsPasswordProtected
* * * * * * * * * * * * * * * * * * * * * * * * * * * *
* Type: SELECT
* * * * * * * * * * * * * * * * * * * * * * * * * * * *
* Parameters :
* * * * * * * * * * * * * * * * * * * * * * * * * * * *
* @ApplicationID varchar(25)
* * * * * * * * * * * * * * * * * * * * * * * * * * * *
* HoroPassword
* PhotoPassword
* * * * * * * * * * * * * * * * * * * * * * * * * * * */
bool boolPassword = false;
using (SqlConnection objConnection = DBConnection.GetSqlConnection())
{
try
{
SqlCommand objCommand = new SqlCommand("UserAlbum_IsPasswordProtected", objConnection);
objCommand.CommandType = CommandType.StoredProcedure;
objCommand.Parameters.Add(new SqlParameter("@ApplicationID", SqlDbType.VarChar));
objCommand.Parameters["@ApplicationID"].Value = ApplicationID;
SqlDataReader objReader;
switch (imageType)
{
case MatrimonialAlbumManager.ImageType.Photo:
objConnection.Open();
objReader = objCommand.ExecuteReader();
objReader.Read();
boolPassword = Convert.ToBoolean(objReader["PhotoPassword"]);
break;
case MatrimonialAlbumManager.ImageType.Album1:
//Creating Command object
objConnection.Open();
objReader = objCommand.ExecuteReader();
objReader.Read();
boolPassword = Convert.ToBoolean(objReader["PhotoPassword"]);
break;
case MatrimonialAlbumManager.ImageType.Album2:
objConnection.Open();
objReader = objCommand.ExecuteReader();
objReader.Read();
boolPassword = Convert.ToBoolean(objReader["PhotoPassword"]);
break;
case MatrimonialAlbumManager.ImageType.Album3:
objConnection.Open();
objReader = objCommand.ExecuteReader();
objReader.Read();
boolPassword = Convert.ToBoolean(objReader["PhotoPassword"]);
break;
case MatrimonialAlbumManager.ImageType.Horoscope:
objConnection.Open();
objReader = objCommand.ExecuteReader();
objReader.Read();
boolPassword = Convert.ToBoolean(objReader["HoroPassword"]);
break;
default:
return(false);
}
objReader = null;
objConnection.Close();
}
catch (Exception)
{
objConnection.Close();
}
return(boolPassword);
}
}
public static byte[] GetImage(string ID, MatrimonialAlbumManager.ImageType imageType)
{
/* * * * * * * * * * * * * * * * * * * * * * * * * * * *
* Procedure Name : UserAlbum_GetAlbum
* * * * * * * * * * * * * * * * * * * * * * * * * * * *
* Type: SELECT
* * * * * * * * * * * * * * * * * * * * * * * * * * * *
* Parameters :
* * * * * * * * * * * * * * * * * * * * * * * * * * * *
* @ID varchar(25)
* @Flag TinyInt
* * * * * * * * * * * * * * * * * * * * * * * * * * * *
* Photo
* Album1
* Album2
* Album3
* Horoscope
* SucessStory
* * * * * * * * * * * * * * * * * * * * * * * * * * * */
byte[] byteImageArray;
using (SqlConnection objConnection = DBConnection.GetSqlConnection())
{
try
{
SqlCommand objCommand;
SqlDataReader objReader;
//Creating Command object
objCommand = new SqlCommand("UserAlbum_GetAlbum", objConnection);
objCommand.CommandType = CommandType.StoredProcedure;
//Adding new Parameters
objCommand.Parameters.Add(new SqlParameter("@ID", SqlDbType.VarChar));
objCommand.Parameters["@ID"].Value = ID;
// Selecting Which Image Needed
switch (imageType)
{
//Flag = 0
case MatrimonialAlbumManager.ImageType.Photo:
//Adding new Parameters
objCommand.Parameters.Add(new SqlParameter("@Flag", SqlDbType.TinyInt));
objCommand.Parameters["@Flag"].Value = 0;
break;
case MatrimonialAlbumManager.ImageType.Album1:
//Adding new Parameters
objCommand.Parameters.Add(new SqlParameter("@Flag", SqlDbType.TinyInt));
objCommand.Parameters["@Flag"].Value = 1;
break;
case MatrimonialAlbumManager.ImageType.Album2:
//Adding new Parameters
objCommand.Parameters.Add(new SqlParameter("@Flag", SqlDbType.TinyInt));
objCommand.Parameters["@Flag"].Value = 2;
break;
case MatrimonialAlbumManager.ImageType.Album3:
//Adding new Parameters
objCommand.Parameters.Add(new SqlParameter("@Flag", SqlDbType.TinyInt));
objCommand.Parameters["@Flag"].Value = 3;
break;
case MatrimonialAlbumManager.ImageType.Horoscope:
//Adding new Parameters
objCommand.Parameters.Add(new SqlParameter("@Flag", SqlDbType.TinyInt));
objCommand.Parameters["@Flag"].Value = 4;
break;
case MatrimonialAlbumManager.ImageType.SucessStory:
//Adding new Parameters
objCommand.Parameters.Add(new SqlParameter("@Flag", SqlDbType.TinyInt));
objCommand.Parameters["@Flag"].Value = 5;
break;
default:
byteImageArray = null;
break;
}
objConnection.Open();
objReader = objCommand.ExecuteReader();
objReader.Read();
byteImageArray = (byte[])objReader["AlumImage"];
objReader = null;
objConnection.Close();
}
catch (Exception)
{
objConnection.Close();
byteImageArray = null;
}
}
return(byteImageArray);
}
public static bool DeleteImage(string ApplicationID, MatrimonialAlbumManager.ImageType imageType)
{
/* * * * * * * * * * * * * * * * * * * * * * * * * * * *
* Procedure Name : UserAlbum_DropAlbum
* * * * * * * * * * * * * * * * * * * * * * * * * * * *
* Type: INSERT
* * * * * * * * * * * * * * * * * * * * * * * * * * * *
* Parameters :
* * * * * * * * * * * * * * * * * * * * * * * * * * * *
* @ApplicationID - varchar(25)
* * * * * * * * * * * * * * * * * * * * * * * * * * * *
* @Photo1 image - Null
* * * * * * * * * * * * * * * * * * * * * * * * * * * *
* @Album1 image - Null
* * * * * * * * * * * * * * * * * * * * * * * * * * * *
* @Album2 image - Null
* * * * * * * * * * * * * * * * * * * * * * * * * * * *
* @Album3 image - Null
* * * * * * * * * * * * * * * * * * * * * * * * * * * *
* @Horoscope image - Null
* * * * * * * * * * * * * * * * * * * * * * * * * * * */
try
{
using (SqlConnection objConnection = DBConnection.GetSqlConnection())
{
SqlCommand objCommand;
objCommand = new SqlCommand("UserAlbum_DropAlbum", objConnection);
objCommand.CommandType = CommandType.StoredProcedure;
/// Inserting parameters
objCommand.Parameters.Add(new SqlParameter("@ID", SqlDbType.VarChar));
objCommand.Parameters["@iD"].Value = ApplicationID;
switch (imageType)
{
case MatrimonialAlbumManager.ImageType.Album1:
//Adding new Parameters
objCommand.Parameters.Add(new SqlParameter("@Flag", SqlDbType.TinyInt));
objCommand.Parameters["@Flag"].Value = 1;
break;
case MatrimonialAlbumManager.ImageType.Album2:
//Adding new Parameters
objCommand.Parameters.Add(new SqlParameter("@Flag", SqlDbType.TinyInt));
objCommand.Parameters["@Flag"].Value = 2;
break;
case MatrimonialAlbumManager.ImageType.Album3:
//Adding new Parameters
objCommand.Parameters.Add(new SqlParameter("@Flag", SqlDbType.TinyInt));
objCommand.Parameters["@Flag"].Value = 3;
break;
case MatrimonialAlbumManager.ImageType.Photo:
//Adding new Parameters
objCommand.Parameters.Add(new SqlParameter("@Flag", SqlDbType.TinyInt));
objCommand.Parameters["@Flag"].Value = 0;
break;
case MatrimonialAlbumManager.ImageType.Horoscope:
//Adding new Parameters
objCommand.Parameters.Add(new SqlParameter("@Flag", SqlDbType.TinyInt));
objCommand.Parameters["@Flag"].Value = 4;
break;
default:
objConnection.Close();
return(false);
}
objConnection.Open();
objCommand.ExecuteNonQuery();
objConnection.Close();
}
return(true);
}
catch (Exception ex)
{
return(false);
}
}
