public int InsertStatus(Status objStatus)
{
int retVal = 0;
try
{
DbParam[] param = new DbParam[8];
param[0] = new DbParam("@StatusId", objStatus.StatusId, SqlDbType.UniqueIdentifier);
param[1] = new DbParam("@StatusName", objStatus.StatusName, SqlDbType.NVarChar);
param[2] = new DbParam("@StatusType", objStatus.StatusType, SqlDbType.VarChar);
param[3] = new DbParam("@StatusUrl", objStatus.StatusUrl, SqlDbType.NVarChar);
param[4] = new DbParam("@UserId", objStatus.UserId, SqlDbType.UniqueIdentifier);
param[5] = new DbParam("@PermissionId", objStatus.PermissionId, SqlDbType.Int);
param[6] = new DbParam("@IsHidden", objStatus.IsHidden, SqlDbType.Bit);
param[7] = new DbParam("@IsArchived", objStatus.ISArchived, SqlDbType.Bit);
retVal = Db.Insert("SP_tblStatus_Ins", param, true);
return retVal;
}
catch (Exception ex)
{
// CommonFunctions.LogError(ex, WINIT.ErrorLog.LogSeverity.Error);
throw ex;
}
}
Status GetStatusObject(DataRow dr)
{
try
{
Status objStatus = new Status();
objStatus.StatusId = Db.ToGuid(dr["StatusId"]);
objStatus.StatusName = Db.ToString(dr["StatusName"]);
objStatus.StatusType = Db.ToString(dr["StatusType"]);
objStatus.StatusUrl = Db.ToString(dr["StatusUrl"]);
objStatus.CreatedDate = Db.ToDateTime(dr["CreatedDate"]).ToString("MMMM d, yyyy HH:mm:ss");
objStatus.UserId = Db.ToGuid(dr["UserId"]);
objStatus.PermissionId = Db.ToInteger(dr["PermissionId"]);
objStatus.IsHidden = Db.ToBoolean(dr["IsHidden"]);
objStatus.ISArchived = Db.ToBoolean(dr["IsArchived"]);
if (dr.Table.Columns.Contains("UserName"))
objStatus.UserName = Db.ToString(dr["UserName"]);
if (dr.Table.Columns.Contains("UserImage"))
objStatus.UserImage = Db.ToString(dr["UserImage"]);
if (dr.Table.Columns.Contains("LikesCount"))
objStatus.LikesCount = Db.ToInteger(dr["LikesCount"]);
if (dr.Table.Columns.Contains("IsLiked"))
objStatus.IsLiked = Db.ToBoolean(dr["IsLiked"]);
if (dr.Table.Columns.Contains("LikeId"))
objStatus.LikeId = Db.ToGuid(dr["LikeId"]);
return objStatus;
}
catch (Exception ex)
{
throw ex;
}
}
/// <summary>
/// Function : SharePost
/// Description : Creates a Duplicate of selected post on the user wall
/// Inputs : Status(obj)
/// </summary>
/// <returns>int</returns>
public int SharePost(Status objStatus)
{
return new StatusDao().SharePost(objStatus);
}
public int InsertStatus(Status objStatus)
{
return new StatusDao().InsertStatus(objStatus);
}
public static int SharePost(string StatusId, string StatusName, string UserId, string Image)
{
Status objStatus = new Status();
objStatus.StatusName = StatusName;
objStatus.UserId = new Guid(UserId);
objStatus.StatusUrl = Image;
objStatus.PermissionId = 4;
objStatus.StatusType = "image";
objStatus.IsHidden = false;
objStatus.ISArchived = false;
objStatus.IsShared = true;
return new StatusFacade().SharePost(objStatus);
}
public static string InsertStatus(Status objStatus)
{
objStatus.StatusId = Guid.NewGuid();
objStatus.UserId = new Guid(UserId);
objStatus.PermissionId = 4;
if (new StatusFacade().InsertStatus(objStatus) > 0)
{
return objStatus.StatusId.ToString();
}
else
{
return "";
}
}
