public ActionResult getAllProfiles()
{
string strGender = "admin"; // Mugurtham admin, Sangam admin, public user
Mugurtham.Core.Login.LoggedInUser objLoggedIn = (Mugurtham.Core.Login.LoggedInUser)Session["LoggedInUser"];
if (objLoggedIn.roleID == "F62DDFBE55448E3A3") // User Profiles
{
if (!string.IsNullOrWhiteSpace(objLoggedIn.BasicInfoCoreEntity.Gender))
{
if (objLoggedIn.BasicInfoCoreEntity.Gender.ToLower().Trim() == "male".ToLower().Trim())
strGender = "female";
else
strGender = "male";
}
}
//string cs = System.Configuration.ConfigurationManager.ConnectionStrings["connectionStringName"].ConnectionString;
ProfileBasicViewEntity objProfileBasicViewEntity = new ProfileBasicViewEntity();
PorfileBasicInfoViewCore objPorfileBasicInfoViewCore = new PorfileBasicInfoViewCore();
using (objPorfileBasicInfoViewCore as IDisposable)
{
objPorfileBasicInfoViewCore.GetAllProfiles(Utility.connectionString(), strGender,
ref objProfileBasicViewEntity,
ref objLoggedIn
);
}
objPorfileBasicInfoViewCore = null;
//Uncommented the below code for performance optimization - Apr 11 2016 - Anand J
/*
List<ProfileCore> objProfileCoreList = new List<ProfileCore>();
ProfileCore objProfileCore = new ProfileCore();
using (objProfileCore as IDisposable)
objProfileCore.GetAll(ref objProfileCoreList, strGender, objLoggedIn.sangamID);
objProfileCore = null;*/
//Response.AddHeader("Content-Encoding", "gzip");
return this.Json(objProfileBasicViewEntity, JsonRequestBehavior.AllowGet);
}
public int GetInterestedProfiles(string strConnectionString, string strGender,
string strInterestedProfileID, string strSangamID,
ref ProfileBasicViewEntity objProfileBasicViewEntity,
ref Mugurtham.Core.Login.LoggedInUser objLoggedIn)
{
List<PhotoCoreEntity> objPhotoCoreEntityList = new List<PhotoCoreEntity>();
List<ProfileBasicInfoViewCoreEntity> objProfileBasicInfoViewCoreEntityList = new List<ProfileBasicInfoViewCoreEntity>();
try
{
if (objLoggedIn.roleID == Constants.RoleIDForUserProfile) // User Profiles
{
if (!string.IsNullOrWhiteSpace(objLoggedIn.BasicInfoCoreEntity.Gender))
{
if (objLoggedIn.BasicInfoCoreEntity.Gender.ToLower().Trim() == "male".ToLower().Trim())
strGender = "female";
else
strGender = "male";
}
}
using (SqlConnection objSqlConnection = new SqlConnection(strConnectionString))
{
objSqlConnection.Open();
// 1. create a command object identifying the stored procedure
SqlCommand objSqlCommand = new SqlCommand("uspGetInterestedProfiles", objSqlConnection);
// 2. set the command object so it knows to execute a stored procedure
objSqlCommand.CommandType = CommandType.StoredProcedure;
// 3. add parameter to command, which will be passed to the stored procedure
objSqlCommand.Parameters.Add(new SqlParameter("@GENDER", strGender));
objSqlCommand.Parameters.Add(new SqlParameter("@InterestedID", strInterestedProfileID));
objSqlCommand.Parameters.Add(new SqlParameter("@SangamID", strSangamID));
// execute the command
using (SqlDataReader objSqlDataReader = objSqlCommand.ExecuteReader())
{
while (objSqlDataReader.Read())
{
ProfileBasicInfoViewCoreEntity objProfileBasicInfoViewCoreEntity = new ProfileBasicInfoViewCoreEntity();
objProfileBasicInfoViewCoreEntity.SangamProfileID = objSqlDataReader["SangamProfileID"].ToString();
objProfileBasicInfoViewCoreEntity.MugurthamProfileID = objSqlDataReader["MugurthamProfileID"].ToString();
objProfileBasicInfoViewCoreEntity.Name = objSqlDataReader["Name"].ToString();
objProfileBasicInfoViewCoreEntity.Gender = objSqlDataReader["Gender"].ToString();
objProfileBasicInfoViewCoreEntity.Education = objSqlDataReader["Education"].ToString();
objProfileBasicInfoViewCoreEntity.Location = objSqlDataReader["Location"].ToString();
objProfileBasicInfoViewCoreEntity.Occupation = objSqlDataReader["Occupation"].ToString();
objProfileBasicInfoViewCoreEntity.SangamID = objSqlDataReader["SangamID"].ToString();
objProfileBasicInfoViewCoreEntity.SangamName = objSqlDataReader["SangamName"].ToString();
objProfileBasicInfoViewCoreEntity.SubCaste = objSqlDataReader["Subcaste"].ToString();
objProfileBasicInfoViewCoreEntity.Star = objSqlDataReader["Star"].ToString();
objProfileBasicInfoViewCoreEntity.AboutMe = objSqlDataReader["AboutMe"].ToString();
if (!string.IsNullOrEmpty(objSqlDataReader["Age"].ToString()))
objProfileBasicInfoViewCoreEntity.Age = Convert.ToInt32(objSqlDataReader["Age"].ToString());
objProfileBasicInfoViewCoreEntityList.Add(objProfileBasicInfoViewCoreEntity);
}
if (objSqlDataReader.NextResult())
{
while (objSqlDataReader.Read())
{
PhotoCoreEntity objPhotoCoreEntity = new PhotoCoreEntity();
using (objPhotoCoreEntity as IDisposable)
{
objPhotoCoreEntity.ID = objSqlDataReader["ID"].ToString();
objPhotoCoreEntity.ProfileID = objSqlDataReader["ProfileID"].ToString();
objPhotoCoreEntity.PhotoPath = objSqlDataReader["PhotoPath"].ToString();
objPhotoCoreEntity.IsProfilePic = Convert.ToDecimal(objSqlDataReader["IsProfilePic"].ToString());
objPhotoCoreEntityList.Add(objPhotoCoreEntity);
}
objPhotoCoreEntity = null;
}
}
objProfileBasicViewEntity.ProfileBasicInfoViewCoreEntityList = objProfileBasicInfoViewCoreEntityList;
objProfileBasicViewEntity.PhotoCoreEntityList = objPhotoCoreEntityList;
objSqlDataReader.Close();
}
objSqlCommand.Cancel();
objSqlCommand.Dispose();
objSqlConnection.Close();
objSqlConnection.Dispose();
}
}
catch (Exception objEx)
{
Helpers.LogExceptionInFlatFile(objEx);
}
return 0;
}
public ActionResult getViewedProfiles()
{
string strGender = "admin"; // Mugurtham admin, Sangam admin, public user
Mugurtham.Core.Login.LoggedInUser objLoggedIn = (Mugurtham.Core.Login.LoggedInUser)Session["LoggedInUser"];
if (objLoggedIn.roleID == "F62DDFBE55448E3A3") // User Profiles
{
if (!string.IsNullOrWhiteSpace(objLoggedIn.BasicInfoCoreEntity.Gender))
{
if (objLoggedIn.BasicInfoCoreEntity.Gender.ToLower().Trim() == "male".ToLower().Trim())
strGender = "female";
else
strGender = "male";
}
}
ProfileCore objProfileCore = new ProfileCore();
ProfileBasicViewEntity objProfileBasicViewEntity = new ProfileBasicViewEntity();
using (objProfileCore as IDisposable)
{
objProfileCore.GetViewedProfiles(Utility.connectionString(), strGender,
objLoggedIn.LoginID, objLoggedIn.sangamID,
ref objProfileBasicViewEntity,
ref objLoggedIn
);
}
objProfileCore = null;
return this.Json(objProfileBasicViewEntity, JsonRequestBehavior.AllowGet);
}
public int GetAllProfiles(string strConnectionString, string strGender, bool lazyLoad,
ref ProfileBasicViewEntity objProfileBasicViewEntity,
ref Mugurtham.Core.Login.LoggedInUser objLoggedIn)
{
try
{
List <PhotoCoreEntity> objPhotoCoreEntityList = new List <PhotoCoreEntity>();
List <ProfileBasicInfoViewCoreEntity> objProfileBasicInfoViewCoreEntityList = new List <ProfileBasicInfoViewCoreEntity>();
if (objLoggedIn.roleID == Constants.RoleIDForUserProfile) // User Profiles
{
if (!string.IsNullOrWhiteSpace(objLoggedIn.BasicInfoCoreEntity.Gender))
{
if (objLoggedIn.BasicInfoCoreEntity.Gender.ToLower().Trim() == "male".ToLower().Trim())
{
strGender = "female";
}
else
{
strGender = "male";
}
}
}
using (SqlConnection objSqlConnection = new SqlConnection(strConnectionString))
{
objSqlConnection.Open();
// 1. create a command object identifying the stored procedure
SqlCommand objSqlCommand = new SqlCommand("uspGetProfileBasicInfoViewLazyLoad", objSqlConnection);
// 2. set the command object so it knows to execute a stored procedure
objSqlCommand.CommandType = CommandType.StoredProcedure;
// 3. add parameter to command, which will be passed to the stored procedure
objSqlCommand.Parameters.Add(new SqlParameter("@GENDER", strGender));
objSqlCommand.Parameters.Add(new SqlParameter("@SangamID", objLoggedIn.sangamID));
objSqlCommand.Parameters.Add(new SqlParameter("@lazyLoad", lazyLoad));
//using (SqlDataAdapter objSqlDataAdapter = new SqlDataAdapter(objSqlCommand))
//{
// // Fill the DataSet using default values for DataTable names, etc
// DataSet objDataSet = new DataSet();
// objSqlDataAdapter.Fill(objDataSet);
//}
// execute the command
using (SqlDataReader objSqlDataReader = objSqlCommand.ExecuteReader())
{
while (objSqlDataReader.Read())
{
ProfileBasicInfoViewCoreEntity objProfileBasicInfoViewCoreEntity = new ProfileBasicInfoViewCoreEntity();
objProfileBasicInfoViewCoreEntity.SangamProfileID = objSqlDataReader["SangamProfileID"].ToString();
objProfileBasicInfoViewCoreEntity.MugurthamProfileID = objSqlDataReader["MugurthamProfileID"].ToString();
objProfileBasicInfoViewCoreEntity.Name = objSqlDataReader["Name"].ToString();
objProfileBasicInfoViewCoreEntity.Gender = objSqlDataReader["Gender"].ToString();
objProfileBasicInfoViewCoreEntity.Education = objSqlDataReader["Education"].ToString();
objProfileBasicInfoViewCoreEntity.Location = objSqlDataReader["Location"].ToString();
objProfileBasicInfoViewCoreEntity.Occupation = objSqlDataReader["Occupation"].ToString();
objProfileBasicInfoViewCoreEntity.SangamID = objSqlDataReader["SangamID"].ToString();
objProfileBasicInfoViewCoreEntity.SangamName = objSqlDataReader["SangamName"].ToString();
objProfileBasicInfoViewCoreEntity.SubCaste = objSqlDataReader["Subcaste"].ToString();
objProfileBasicInfoViewCoreEntity.Star = objSqlDataReader["Star"].ToString();
objProfileBasicInfoViewCoreEntity.AboutMe = objSqlDataReader["AboutMe"].ToString();
if (!string.IsNullOrEmpty(objSqlDataReader["Age"].ToString()))
{
objProfileBasicInfoViewCoreEntity.Age = Convert.ToInt32(objSqlDataReader["Age"].ToString());
}
objProfileBasicInfoViewCoreEntityList.Add(objProfileBasicInfoViewCoreEntity);
}
if (objSqlDataReader.NextResult())
{
while (objSqlDataReader.Read())
{
PhotoCoreEntity objPhotoCoreEntity = new PhotoCoreEntity();
using (objPhotoCoreEntity as IDisposable)
{
objPhotoCoreEntity.ID = objSqlDataReader["ID"].ToString();
objPhotoCoreEntity.ProfileID = objSqlDataReader["ProfileID"].ToString();
objPhotoCoreEntity.PhotoPath = objSqlDataReader["PhotoPath"].ToString();
objPhotoCoreEntity.IsProfilePic = Convert.ToDecimal(objSqlDataReader["IsProfilePic"].ToString());
objPhotoCoreEntityList.Add(objPhotoCoreEntity);
}
objPhotoCoreEntity = null;
}
}
objProfileBasicViewEntity.ProfileBasicInfoViewCoreEntityList = objProfileBasicInfoViewCoreEntityList;
objProfileBasicViewEntity.PhotoCoreEntityList = objPhotoCoreEntityList;
objSqlDataReader.Close();
}
objSqlCommand.Cancel();
objSqlCommand.Dispose();
objSqlConnection.Close();
objSqlConnection.Dispose();
}
}
catch (Exception objEx)
{
Helpers.LogExceptionInFlatFile(objEx);
}
return(0);
}