public void GetTributeOnIdTest()
{
UserInfoManager target = new UserInfoManager(); // TODO: Initialize to an appropriate value
int UserId = InsertDummyUser("tj_op");
int tributeId = 0;
GetMyTributes _objtribute = new GetMyTributes();
_objtribute.UserId = UserId;
object[] _param = { _objtribute, 0, 1, 1 };
if (_objtribute.CustomError == null)
{
List<GetMyTributes> Mytributes = new List<GetMyTributes>();
Mytributes = target.GetMyTributes(_param);
Assert.AreEqual(true, Mytributes.Count > 0);
tributeId = Mytributes[0].TributeId;
}
TributesUserInfo _objTributeUserinfo = new TributesUserInfo(); // TODO: Initialize to an appropriate value
_objTributeUserinfo.Tributes = new Tributes();
_objTributeUserinfo.Tributes.TributeId = tributeId;
target.GetTributeOnId(_objTributeUserinfo);
//Write Asserts here once the stored procedure is fixed
//Assert.Inconclusive("A method that does not return a value cannot be verified.");
}
public void UpdateEmailAlertsTest()
{
UserInfoManager target = new UserInfoManager(); // TODO: Initialize to an appropriate value
int UserId = InsertDummyUser("tj_op");
//////////////////////////Get tribute of type 0 for userId////GetMyTributes unit test//
int tributeId = 0;
GetMyTributes _objtribute = new GetMyTributes();
_objtribute.UserId = UserId;
object[] _param = { _objtribute, 0, 1, 1 };
if (_objtribute.CustomError == null)
{
List<GetMyTributes> Mytributes = new List<GetMyTributes>();
Mytributes = target.GetMyTributes(_param);
Assert.AreEqual(true, Mytributes.Count > 0);
tributeId = Mytributes[0].TributeId;
}
///////////////////////////
Tributes objTribute = new Tributes();
objTribute.UserTributeId = UserId;
objTribute.TributeId = tributeId;
objTribute.IsActive = false;
object[] _Tributes = { objTribute }; // TODO: Initialize to an appropriate value
target.UpdateEmailAlerts(_Tributes);
/////GetMyTribute Unit test/////
GetMyTributes objtribute = new GetMyTributes();
objtribute.UserId = UserId;
object[] param = { objtribute, tributeId };
List<GetMyTributes> mytribute = target.GetMyTribute(param);
Assert.AreEqual(mytribute[0].TributeId, tributeId);
if (mytribute[0].TributeId == tributeId)
{
Assert.AreEqual(false, mytribute[0].EmailAlert);
}
//Assert.Inconclusive("A method that does not return a value cannot be verified.");
}
public void GetTributeByIDTest()
{
UserInfoManager target = new UserInfoManager(); // TODO: Initialize to an appropriate value
int UserId = InsertDummyUser("tj_op");
int tributeId = 0;
GetMyTributes _objtribute = new GetMyTributes();
_objtribute.UserId = UserId;
object[] _param = { _objtribute, 0, 1, 2 };
if (_objtribute.CustomError == null)
{
List<GetMyTributes> Mytributes = new List<GetMyTributes>();
Mytributes = target.GetMyTributes(_param);
Assert.AreEqual(true, Mytributes.Count > 0);
tributeId = Mytributes[0].TributeId;
}
TributesUserInfo _objTributeUserinfo = new TributesUserInfo(); // TODO: Initialize to an appropriate value
_objTributeUserinfo.Tributes = new Tributes();
_objTributeUserinfo.Tributes.TributeId = tributeId;
target.GetTributeByID(_objTributeUserinfo);
Assert.AreEqual("tj", _objTributeUserinfo.Tributes.TributeName);
Assert.AreEqual("xyz", _objTributeUserinfo.Tributes.TributeUrl);
Assert.AreEqual("Birthday", _objTributeUserinfo.Tributes.TypeDescription);
Assert.AreEqual("tj", _objTributeUserinfo.Tributes.TributeName);
Assert.AreEqual("11-03-1983 AM 12:00:00", _objTributeUserinfo.Tributes.Date1.ToString());
//Assert.Inconclusive("A method that does not return a value cannot be verified.");
}
public void IsUserOwnerTest()
{
UserInfoManager target = new UserInfoManager(); // TODO: Initialize to an appropriate value
//UserAdminOwnerInfo objUserInfo = null; // TODO: Initialize to an appropriate value
bool expected = true; // TODO: Initialize to an appropriate value
bool actual;
UserAdminOwnerInfo objUserInfo = new UserAdminOwnerInfo();
int UserId = InsertDummyUser("tj_op");
objUserInfo.UserId = UserId;
//Find Tributes for User ID
int tributeId = 0;
GetMyTributes _objtribute = new GetMyTributes();
_objtribute.UserId = UserId;
object[] _param = { _objtribute, 0, 1, 1 };
if (_objtribute.CustomError == null)
{
List<GetMyTributes> Mytributes = new List<GetMyTributes>();
Mytributes = target.GetMyTributes(_param);
Assert.AreEqual(true, Mytributes.Count > 0);
tributeId = Mytributes[0].TributeId;
}
objUserInfo.TributeId = tributeId;
//FINd Photo Album ID for Tribute id
object[] objParam = { tributeId };
DataSet dsPhotoAlbumList = GetDataSet("usp_GetPhotoAlbumListInTribute", objParam);
List<PhotoAlbum> objListOfPhotoAlbum = new List<PhotoAlbum>();
//to fill records in the Photo Gallery list
if (dsPhotoAlbumList.Tables[0].Rows.Count > 0)
{
foreach (DataRow dr in dsPhotoAlbumList.Tables[0].Rows)
{
PhotoAlbum objAlbum = new PhotoAlbum();
objAlbum.PhotoAlbumId = int.Parse(dr["PhotoAlbumId"].ToString());
objListOfPhotoAlbum.Add(objAlbum);
objAlbum = null;
}
}
int PhotoAlbumId = 0;
if (objListOfPhotoAlbum.Count > 0)
{
PhotoAlbumId = objListOfPhotoAlbum[0].PhotoAlbumId;
}
//Get Photo id in PhotoAlbumId/////////////
List<Photos> objListPhotos = new List<Photos>();
try
{
object[] objParam1 = {PhotoAlbumId,
1,
1,
"ASC"
};
DataSet dsPhotos = GetDataSet("usp_GetPhotos", objParam1);
int totalRecords = 0;
//objGetPhotos.SortOrder
if (dsPhotos.Tables[0].Rows.Count > 0)
{
DataRow dr = dsPhotos.Tables[0].Rows[0];
totalRecords = int.Parse(dr["TotalRecords"].ToString());
}
//to fill records in the Photo list
if (dsPhotos.Tables[1].Rows.Count > 0)
{
foreach (DataRow dr in dsPhotos.Tables[1].Rows)
{
Photos objPhoto = new Photos();
objPhoto.PhotoId = int.Parse(dr["UserPhotoId"].ToString());
objPhoto.PhotoAlbumId = int.Parse(dr["PhotoAlbumId"].ToString());
objPhoto.PhotoImage = dr["PhotoImage"].ToString();
objPhoto.CommentCount = int.Parse(dr["CommentCount"].ToString());
objPhoto.CreatedDate = DateTime.Parse(dr["CreatedDate"].ToString());
objPhoto.TotalRecords = totalRecords;
objListPhotos.Add(objPhoto);
objPhoto = null;
}
}
}
catch (Exception ex)
{
throw ex;
}
//////////////////////////////////////////
objUserInfo.TypeId = objListPhotos[0].PhotoId;
objUserInfo.TypeName = "ManagePhoto";
actual = target.IsUserOwner(objUserInfo);
Assert.AreEqual(expected, actual);
//Assert.Inconclusive("Verify the correctness of this test method.");
}
protected void EmptyGridFix(GridView grdView)
{
// normally executes after a grid load method
if (grdView.DataSource == null)
{
GetMyTributes objtrib = new GetMyTributes();
objtrib.TributeName = null;
objtrib.TypeDescription = null;
objtrib.Enddate = null;
objtrib.EmailAlert = false;
objtrib.TributeId=0;
objtrib.UserId = 0;
List<GetMyTributes> emptyTribyte = new List<GetMyTributes>();
emptyTribyte.Add(objtrib);
grdView.DataSource = emptyTribyte;
grdView.DataBind();
DropDownList ddlist = (DropDownList)grdView.HeaderRow.FindControl("ddlFavourite");
if (ddlist != null)
{
if (ddlist.Items.Count <= 0)
{
ddlist.DataSource = _TributeTypes2;
ddlist.DataTextField = ParameterTypesCodes.Parameters.TypeDescription.ToString();
ddlist.DataValueField = ParameterTypesCodes.Parameters.TypeCode.ToString();
ddlist.DataBind();
ddlist.SelectedIndex = ddlist.Items.IndexOf(ddlist.Items.FindByText(tributeType2));
}
}
// hide row
grdView.Rows[0].Visible = false;
grdView.Rows[0].Controls.Clear();
}
}
/// <summary>
///
/// </summary>
/// <param name="objValue"></param>
/// <returns></returns>
public List<GetMyTributes> GetMyTributes(object[] objValue)
{
GetMyTributes objUserReg = (GetMyTributes)objValue[0];
List<GetMyTributes> lstTributes = new List<GetMyTributes>();
try
{
object[] objParam = { objUserReg.UserId, int.Parse(objValue[1].ToString()), int.Parse(objValue[2].ToString()), int.Parse(objValue[3].ToString()) };
DataSet _objDataSet = GetDataSet("usp_GetMyTributes", objParam);
if (_objDataSet.Tables[0].Rows.Count > 0)
{
foreach (DataRow dr in _objDataSet.Tables[0].Rows)
{
int _packageId = 0;
int tributeId = 0;
GetMyTributes objMyTributes = new GetMyTributes();
objMyTributes.TributeId = int.Parse(dr["TributeId"].ToString());
tributeId = int.Parse(dr["TributeId"].ToString());
objMyTributes.TributeName = dr["TributeName"].ToString();
objMyTributes.TypeDescription = dr["TypeDescription"].ToString();
objMyTributes.StartDate = DateTime.Parse(dr["StartDate"].ToString());
#region PakageId
if (dr["PackageId"] != null)
{
if (dr["Enddate"].ToString().Equals("Never"))
{
//LHK: 12/19/2011 Yt speedup Issue
int.TryParse(dr["PackageId"].ToString(), out _packageId);
switch (_packageId)
{
case 1:
if (dr["TypeDescription"].ToString().ToLower().Equals("video"))
objMyTributes.Enddate = "Video Tribute (Lifetime)";// + " (" + dr["Enddate"].ToString() + ")"; Updated in yt phase 1
else
objMyTributes.Enddate = "Memorial Tribute (Lifetime)";// +" (" + dr["Enddate"].ToString() + ")";// updated in yt phase 1
break;
case 4:
objMyTributes.Enddate = "Memorial Tribute (Lifetime)";// +" (" + dr["Enddate"].ToString() + ")";// updated in yt phase 1
break;
case 6:
objMyTributes.Enddate = "Premium Obituary (Lifetime)";// +" (" + dr["Enddate"].ToString() + ")"; //"Photo Tribute" + " (" + dr["Enddate"].ToString() + ")"; updated in phase 1
break;
case 8:
objMyTributes.Enddate = "Obituary (Lifetime)";// "Announce (Free)"; updated in yt phase 1
break;
case 11:
if (dr["TypeDescription"].ToString().ToLower().Equals("video"))
objMyTributes.Enddate = "Video (Lifetime)";//
break;
default:
objMyTributes.Enddate = "Celebrate (Lifetime)";// +" (" + dr["Enddate"].ToString() + ")";
break;
}
}
else
{
string[] date = dr["Enddate"].ToString().Split('/');
DateTime date2 = new DateTime(int.Parse(date[2]), int.Parse(date[0]), int.Parse(date[1]));
if (date2 < DateTime.Now)
{
//LHK: 12/19/2011 Yt speedup Issue
int.TryParse(dr["PackageId"].ToString(), out _packageId);
switch (_packageId)
{
case 2:
if (dr["TypeDescription"].ToString().ToLower().Equals("video"))
objMyTributes.Enddate = "Video Tribute (Expired)";
else
objMyTributes.Enddate = "Memorial Tribute (Expired)";// "Tribute (Expired)"; updated in phase 1
break;
case 3:
objMyTributes.Enddate = "Announce (Free)";
break;
case 5:
objMyTributes.Enddate = "Memorial Tribute (Expired)"; //Tribute (Expired)"; updated in yt phase 1
break;
case 7:
objMyTributes.Enddate = "Premium Obituary (Expired)"; //"Photo Tribute (Expired)"; updates in yt phase 1
break;
case 8:
objMyTributes.Enddate = "Obituary (Lifetime)";// "Announce (Free)"; updated in yt phase 1
break;
case 9:
if (dr["TypeDescription"].ToString().ToLower().Equals("video"))
objMyTributes.Enddate = "Video Tribute (Expired)";
break;
case 10:
if (dr["TypeDescription"].ToString().ToLower().Equals("video"))
objMyTributes.Enddate = "Video Tribute (Expired)";
break;
case 12:
if (dr["TypeDescription"].ToString().ToLower().Equals("video"))
objMyTributes.Enddate = "Video (Expired)";
break;
case 13:
if (dr["TypeDescription"].ToString().ToLower().Equals("video"))
objMyTributes.Enddate = "Video (Expired)";
break;
case 14:
if (dr["TypeDescription"].ToString().ToLower().Equals("video"))
objMyTributes.Enddate = "Video (Expired)";
break;
default:
objMyTributes.ExpiredOn = date2.ToString("MMMM dd, yyyy");
break;
}
}
else
{
//LHK: 12/19/2011 Yt speedup Issue
int.TryParse(dr["PackageId"].ToString(), out _packageId);
switch (_packageId)
{
case 2:
if (dr["TypeDescription"].ToString().ToLower().Equals("video"))
objMyTributes.Enddate = "Video Tribute" + " (" + dr["Enddate"].ToString() + ")";
else
objMyTributes.Enddate = "Memorial Tribute" + " (" + dr["Enddate"].ToString() + ")"; // updated in yt phase 1
break;
case 3:
objMyTributes.Enddate = "Tribute Free Trial" + " (" + dr["Enddate"].ToString() + ")";
break;
case 5:
objMyTributes.Enddate = "Memorial Tribute" + " (" + dr["Enddate"].ToString() + ")";// updated in yt phase 1
break;
case 7:
objMyTributes.Enddate = "Premium Obituary" + " (" + dr["Enddate"].ToString() + ")"; //"Photo Tribute" + " (" + dr["Enddate"].ToString() + ")"; updated in phase 1
break;
case 8:
objMyTributes.Enddate = "Obituary (Lifetime)";// "Tribute Free Trial" + " (" + dr["Enddate"].ToString() + ")"; updated for phase 1
break;
case 9:
if (dr["TypeDescription"].ToString().ToLower().Equals("video"))
objMyTributes.Enddate = "Video Tribute" + " (" + dr["Enddate"].ToString() + ")";
break;
case 10:
if (dr["TypeDescription"].ToString().ToLower().Equals("video"))
objMyTributes.Enddate = "Video Tribute" + " (" + dr["Enddate"].ToString() + ")";
break;
case 12:
if (dr["TypeDescription"].ToString().ToLower().Equals("video"))
objMyTributes.Enddate = "Video " + " (" + dr["Enddate"].ToString() + ")";
break;
case 13:
if (dr["TypeDescription"].ToString().ToLower().Equals("video"))
objMyTributes.Enddate = "Video " + " (" + dr["Enddate"].ToString() + ")";
break;
case 14:
if (dr["TypeDescription"].ToString().ToLower().Equals("video"))
objMyTributes.Enddate = "Video " + " (" + dr["Enddate"].ToString() + ")";
break;
default:
objMyTributes.ExpiredOn = date2.ToString("MMMM dd, yyyy");
break;
}
}
}
}
#endregion
objMyTributes.Visit = int.Parse(dr["Visit"].ToString());
objMyTributes.EmailAlert = bool.Parse(dr["EmailAlert"].ToString());
objMyTributes.Renewaldate = DateTime.Parse(dr["Renewaldate"].ToString());
objMyTributes.TributeUrl = dr["TributeUrl"].ToString();
//LHK: speed up issue
if (dr["TypeDescription"].ToString().ToLower() == "video")
{
if (WebConfig.ApplicationMode.Equals("local"))
{
objMyTributes.TributeHomeUrl = WebConfig.AppBaseDomain.ToString() + "video/videotribute.aspx?tributeId=" + tributeId.ToString();
}
else
{
//Use this line for server and comment the line written above
objMyTributes.TributeHomeUrl = "http://video." + WebConfig.TopLevelDomain + "/video/videotribute.aspx?tributeId=" + tributeId.ToString();
}
}
else
{
if (WebConfig.ApplicationMode.Equals("local"))
{
objMyTributes.TributeHomeUrl = WebConfig.AppBaseDomain.ToString() + dr["TributeUrl"].ToString() + "/?" + "TributeType=" + dr["TypeDescription"].ToString();
}
else
{
//Use this line for server and comment the line written above
objMyTributes.TributeHomeUrl = "http://" + dr["TypeDescription"].ToString().Replace("New Baby", "newbaby").ToLower() + "." + WebConfig.TopLevelDomain + "/" + dr["TributeUrl"].ToString() + "/";
}
}
lstTributes.Add(objMyTributes);
objMyTributes = null;
}
}
return lstTributes;
}
catch (System.Data.SqlClient.SqlException sqlEx)
{
if (sqlEx.Number >= 50000)
{
Errors objError = new Errors();
objError.ErrorMessage = sqlEx.Message;
GetMyTributes objMyTributes = new GetMyTributes();
objMyTributes.CustomError = objError;
lstTributes.Add(objMyTributes);
objMyTributes = null;
}
return lstTributes;
}
}
public List<GetMyTributes> GetMyTribute(object[] objValue)
{
int _packageId;
GetMyTributes objUserReg = (GetMyTributes)objValue[0];
List<GetMyTributes> lstTributes = new List<GetMyTributes>();
try
{
object[] objParam = { objUserReg.UserId, int.Parse(objValue[1].ToString()) };
DataSet _objDataSet = GetDataSet("usp_GetMyTribute", objParam);
if (_objDataSet.Tables[0].Rows.Count > 0)
{
foreach (DataRow dr in _objDataSet.Tables[0].Rows)
{
GetMyTributes objMyTributes = new GetMyTributes();
objMyTributes.TributeId = int.Parse(dr["TributeId"].ToString());
objMyTributes.TributeName = dr["TributeName"].ToString();
objMyTributes.TypeDescription = dr["TypeDescription"].ToString();
objMyTributes.StartDate = DateTime.Parse(dr["StartDate"].ToString());
if (dr["Enddate"].ToString().Equals("Never"))
{
// objMyTributes.Enddate = dr["Enddate"].ToString(); By Mohit Gupta
objMyTributes.Enddate = "Celebrate" + " (" + dr["Enddate"].ToString() + ")";
}
else
{
string[] date = dr["Enddate"].ToString().Split('/');
DateTime date2 = new DateTime(int.Parse(date[2]), int.Parse(date[0]), int.Parse(date[1]));
if (date2 < DateTime.Now)
{
objMyTributes.Enddate = "Obituary (Lifetime)";// "Announce (Free)"; updated in yt phase 1
objMyTributes.ExpiredOn = date2.ToString("MMMM dd, yyyy");
}
else
{
objMyTributes.Enddate = "Celebrate Trial" + " (" + dr["Enddate"].ToString() + ")";
objMyTributes.ExpiredOn = date2.ToString("MMMM dd, yyyy");
}
}
objMyTributes.Visit = int.Parse(dr["Visit"].ToString());
objMyTributes.EmailAlert = bool.Parse(dr["EmailAlert"].ToString());
objMyTributes.Renewaldate = DateTime.Parse(dr["Renewaldate"].ToString());
objMyTributes.TributeUrl = dr["TributeUrl"].ToString();
lstTributes.Add(objMyTributes);
objMyTributes = null;
}
}
return lstTributes;
}
catch (System.Data.SqlClient.SqlException sqlEx)
{
if (sqlEx.Number >= 50000)
{
Errors objError = new Errors();
objError.ErrorMessage = sqlEx.Message;
GetMyTributes objMyTributes = new GetMyTributes();
objMyTributes.CustomError = objError;
lstTributes.Add(objMyTributes);
objMyTributes = null;
}
return lstTributes;
}
}
public List<GetMyTributes> GetMyFavourites(object[] objValue)
{
GetMyTributes objUserReg = (GetMyTributes)objValue[0];
List<GetMyTributes> lstTributes = new List<GetMyTributes>();
try
{
object[] objParam = { objUserReg.UserId, int.Parse(objValue[1].ToString()), int.Parse(objValue[2].ToString()), int.Parse(objValue[3].ToString()) };
DataSet _objDataSet = GetDataSet("usp_GetMyFavourites", objParam);
if (_objDataSet.Tables[0].Rows.Count > 0)
{
foreach (DataRow dr in _objDataSet.Tables[0].Rows)
{
GetMyTributes objMyTributes = new GetMyTributes();
objMyTributes.TributeId = int.Parse(dr["TributeId"].ToString());
objMyTributes.TributeName = dr["TributeName"].ToString();
objMyTributes.TypeDescription = dr["TypeDescription"].ToString();
objMyTributes.Enddate = dr["CreatedBy"].ToString();
objMyTributes.EmailAlert = bool.Parse(dr["EmailAlert"].ToString());
objMyTributes.UserId = int.Parse(dr["UserId"].ToString());
objMyTributes.TributeUrl = dr["TributeUrl"].ToString();
lstTributes.Add(objMyTributes);
objMyTributes = null;
}
}
return lstTributes;
}
catch (System.Data.SqlClient.SqlException sqlEx)
{
if (sqlEx.Number >= 50000)
{
Errors objError = new Errors();
objError.ErrorMessage = sqlEx.Message;
GetMyTributes objMyTributes = new GetMyTributes();
objMyTributes.CustomError = objError;
lstTributes.Add(objMyTributes);
objMyTributes = null;
}
return lstTributes;
}
}
