public int InsertPhoto(Photo objPhoto)
{
int retVal = 0;
try
{
DbParam[] param = new DbParam[11];
param[0] = new DbParam("@PhotoId", objPhoto.PhotoId, SqlDbType.UniqueIdentifier);
param[1] = new DbParam("@PhotoUrl", objPhoto.PhotoUrl, SqlDbType.VarChar);
param[2] = new DbParam("@PhotoStatus", objPhoto.PhotoStatus, SqlDbType.VarChar);
param[3] = new DbParam("@PhotoType", objPhoto.PhotoType, SqlDbType.VarChar);
param[4] = new DbParam("@IsShared", objPhoto.IsShared, SqlDbType.Bit);
param[5] = new DbParam("@IsLiked", objPhoto.IsLiked, SqlDbType.Bit);
param[6] = new DbParam("@UserId", objPhoto.UserId, SqlDbType.UniqueIdentifier);
param[7] = new DbParam("@PermissionId", objPhoto.PermissionId, SqlDbType.Int);
param[8] = new DbParam("@IsHidden", objPhoto.IsHidden, SqlDbType.Bit);
param[9] = new DbParam("@IsArchived", objPhoto.IsArchived, SqlDbType.Bit);
param[10] = new DbParam("@IsShared1", objPhoto.IsShared1, SqlDbType.Bit);
retVal = Db.Insert("SP_tblPhoto_Ins", param, true);
return retVal;
}
catch (Exception ex)
{
// CommonFunctions.LogError(ex, WINIT.ErrorLog.LogSeverity.Error);
throw ex;
}
}
/// <summary>
/// Function : SharePost
/// Description : Creates a Duplicate of selected post on the user wall
/// Inputs : Photo(obj)
/// </summary>
/// <returns>int</returns>
public int SharePost(Photo objPhoto)
{
return new PhotoDao().SharePost(objPhoto);
}
Photo GetPhotoObject(DataRow dr)
{
try
{
Photo objPhoto = new Photo();
objPhoto.PhotoId = Db.ToGuid((dr["PhotoId"]));
objPhoto.PhotoUrl = Db.ToString(dr["PhotoUrl"]);
objPhoto.PhotoStatus = Db.ToString(dr["PhotoStatus"]);
objPhoto.PhotoType = Db.ToString(dr["PhotoType"]);
objPhoto.IsShared = Db.ToBoolean(dr["IsShared"]);
objPhoto.IsLiked = Db.ToBoolean(dr["IsLiked"]);
objPhoto.UserId = Db.ToGuid((dr["UserId"]));
objPhoto.PermissionId = Db.ToInteger(dr["PermissionId"]);
objPhoto.IsHidden = Db.ToBoolean(dr["IsHidden"]);
objPhoto.IsArchived = Db.ToBoolean(dr["IsArchived"]);
objPhoto.IsShared1 = Db.ToBoolean(dr["IsShared1"]);
objPhoto.CreatedDate = Db.ToDateTime(dr["CreatedDate"]);
objPhoto.ModifiedDate = Db.ToDateTime(dr["ModifiedDate"]);
if (dr.Table.Columns.Contains("UserName"))
objPhoto.UserName = Db.ToString(dr["UserName"]);
if (dr.Table.Columns.Contains("UserImage"))
objPhoto.UserImage = Db.ToString(dr["UserImage"]);
//if (dr.Table.Columns.Contains("LikesCount"))
// objPhoto.LikesCount = Db.ToInteger(dr["LikesCount"]);
//if (dr.Table.Columns.Contains("IsLiked"))
// objPhoto.IsLiked = Db.ToBoolean(dr["IsLiked"]);
//if (dr.Table.Columns.Contains("LikeId"))
// objPhoto.LikeId = Db.ToGuid(dr["LikeId"]);
return objPhoto;
}
catch (Exception ex)
{
throw ex;
}
}
public int InsertPhoto(Photo objPhoto)
{
return new PhotoDao().InsertPhoto(objPhoto);
}