public MessageObjectAll getMessages(int userId, int otherId, Int64 messageId)
{
MessageObjectAll allObjects = new MessageObjectAll();
if (messageId == 0)
{
messageId = 999999999;
}
DataTable dt = new DataTable();
DataSet ds = new DataSet();
SqlConnection sqlConn = new SqlConnection(ConfigurationManager.ConnectionStrings["AppConnectionString"].ConnectionString);
SqlDataAdapter sda1 = new SqlDataAdapter("sp_messages", sqlConn);
sda1.SelectCommand.CommandType = CommandType.StoredProcedure;
sda1.SelectCommand.Parameters.Add("@OwnerId", SqlDbType.Int).Value = userId;
sda1.SelectCommand.Parameters.Add("@OtherId", SqlDbType.Int).Value = otherId;
sda1.SelectCommand.Parameters.Add("@MessageId", SqlDbType.Int).Value = messageId;
//try
//{
sda1.Fill(ds);
dt = ds.Tables[0];
//}
//catch (Exception ex)
//{
//}
//finally
//{
sqlConn.Close();
sda1.Dispose();
sqlConn.Dispose();
//}
if (dt.Rows.Count == 0)
{
return(allObjects);
}
else
{
MessageObject object1 = new MessageObject();
MessageObject object2 = new MessageObject();
MessageObject object3 = new MessageObject();
MessageObject object4 = new MessageObject();
MessageObject object5 = new MessageObject();
MessageObject object6 = new MessageObject();
MessageObject object7 = new MessageObject();
MessageObject object8 = new MessageObject();
MessageObject object9 = new MessageObject();
MessageObject object10 = new MessageObject();
// profile pic url
int userIdString = 0;
Classes.Date d = new Classes.Date();
for (int i = 0; i < dt.Rows.Count; i++)
{
if (Convert.ToBoolean(dt.Rows[i]["Sender"].ToString()))
{
userIdString = Convert.ToInt32(dt.Rows[i]["OwnerId"].ToString());
}
else
{
userIdString = Convert.ToInt32(dt.Rows[i]["OtherId"].ToString());
}
MessageObject myMessageObject = new MessageObject(
Convert.ToInt32(dt.Rows[i]["MessageId"].ToString()),
Convert.ToBoolean(dt.Rows[i]["Sender"].ToString()),
dt.Rows[i]["Message"].ToString(),
d.FormatPassedDate(dt.Rows[i]["SubmitDate"].ToString()),
Convert.ToBoolean(dt.Rows[i]["Unread"].ToString()),
userIdString);
switch (i)
{
case 0:
{
object10 = myMessageObject;
break;
}
case 1:
{
object9 = myMessageObject;
break;
}
case 2:
{
object8 = myMessageObject;
break;
}
case 3:
{
object7 = myMessageObject;
break;
}
case 4:
{
object6 = myMessageObject;
break;
}
case 5:
{
object5 = myMessageObject;
break;
}
case 6:
{
object4 = myMessageObject;
break;
}
case 7:
{
object3 = myMessageObject;
break;
}
case 8:
{
object2 = myMessageObject;
break;
}
case 9:
{
object1 = myMessageObject;
break;
}
}
allObjects = new MessageObjectAll(
object1,
object2,
object3,
object4,
object5,
object6,
object7,
object8,
object9,
object10);
}
return(allObjects);
}
}
public MessageObjectAll getMessages(int userId, int otherId, Int64 messageId)
{
MessageObjectAll allObjects = new MessageObjectAll();
if (messageId == 0)
{
messageId = 999999999;
}
DataTable dt = new DataTable();
DataSet ds = new DataSet();
SqlConnection sqlConn = new SqlConnection(ConfigurationManager.ConnectionStrings["AppConnectionString"].ConnectionString);
SqlDataAdapter sda1 = new SqlDataAdapter("sp_messages", sqlConn);
sda1.SelectCommand.CommandType = CommandType.StoredProcedure;
sda1.SelectCommand.Parameters.Add("@OwnerId", SqlDbType.Int).Value = userId;
sda1.SelectCommand.Parameters.Add("@OtherId", SqlDbType.Int).Value = otherId;
sda1.SelectCommand.Parameters.Add("@MessageId", SqlDbType.Int).Value = messageId;
//try
//{
sda1.Fill(ds);
dt = ds.Tables[0];
//}
//catch (Exception ex)
//{
//}
//finally
//{
sqlConn.Close();
sda1.Dispose();
sqlConn.Dispose();
//}
if (dt.Rows.Count == 0)
{
return allObjects;
}
else
{
MessageObject object1 = new MessageObject();
MessageObject object2 = new MessageObject();
MessageObject object3 = new MessageObject();
MessageObject object4 = new MessageObject();
MessageObject object5 = new MessageObject();
MessageObject object6 = new MessageObject();
MessageObject object7 = new MessageObject();
MessageObject object8 = new MessageObject();
MessageObject object9 = new MessageObject();
MessageObject object10 = new MessageObject();
// profile pic url
int userIdString = 0;
Classes.Date d = new Classes.Date();
for (int i = 0; i < dt.Rows.Count; i++)
{
if (Convert.ToBoolean(dt.Rows[i]["Sender"].ToString()))
{
userIdString = Convert.ToInt32(dt.Rows[i]["OwnerId"].ToString());
}
else
{
userIdString = Convert.ToInt32(dt.Rows[i]["OtherId"].ToString());
}
MessageObject myMessageObject = new MessageObject(
Convert.ToInt32(dt.Rows[i]["MessageId"].ToString()),
Convert.ToBoolean(dt.Rows[i]["Sender"].ToString()),
dt.Rows[i]["Message"].ToString(),
d.FormatPassedDate(dt.Rows[i]["SubmitDate"].ToString()),
Convert.ToBoolean(dt.Rows[i]["Unread"].ToString()),
userIdString);
switch (i)
{
case 0:
{
object10 = myMessageObject;
break;
}
case 1:
{
object9 = myMessageObject;
break;
}
case 2:
{
object8 = myMessageObject;
break;
}
case 3:
{
object7 = myMessageObject;
break;
}
case 4:
{
object6 = myMessageObject;
break;
}
case 5:
{
object5 = myMessageObject;
break;
}
case 6:
{
object4 = myMessageObject;
break;
}
case 7:
{
object3 = myMessageObject;
break;
}
case 8:
{
object2 = myMessageObject;
break;
}
case 9:
{
object1 = myMessageObject;
break;
}
}
allObjects = new MessageObjectAll(
object1,
object2,
object3,
object4,
object5,
object6,
object7,
object8,
object9,
object10);
}
return allObjects;
}
}
