public bool merge(InboxDTO entity)
{
try
{
var addObj = (from p in ctx.Inboxes
where p.userName == @entity.userName && p.messageId == @entity.messageId
select p).Single();
model.Inbox obj = (Inbox)addObj;
/*Update*/
obj.userName = entity.userName;
obj.messageId = entity.messageId;
obj.date = entity.date;
obj.unread = entity.unread;
obj.message = entity.message;
ctx.SubmitChanges();
return true;
}
catch (Exception e)
{
model.Log log = new Log();
log.message = "Inbox Merge: " + " ["+entity.userName+" , "+entity.messageId+"] " + e.Message;
ctx.SubmitChanges();
ctx.Dispose();
ctx = new ModelDataContext();
return false;
}
}
protected void vacRepeater_ItemCommand(object source, RepeaterCommandEventArgs e)
{
String element = e.CommandName.ToString();
string userName = (string)Session["username"];
ApplicationDAO app_ctx = new ApplicationDAO();
ApplicationDTO obj = new ApplicationDTO();
if(!app_ctx.isFound(userName,element) )
{
obj.userName = userName;
obj.vacancyNumber = element;
obj.status = ApplicationStatus.APPLIED.ToString();
obj.appDate = DateTime.Now;
app_ctx.presist(obj);
InboxDTO inbox = new InboxDTO();
inbox.date = DateTime.Now;
inbox.message = "You have successfully applied for vacancy " + element;
inbox.status = ApplicationStatus.APPLIED.ToString();
inbox.unread = "unread";
inbox.userName = userName;
inbox.vacancyNumber = element;
InboxDAO dao = new InboxDAO();
dao.presist(inbox);
Response.Redirect("~/Inbox/InboxMessage.aspx");
}
}
public InboxDTO find(string userName, string vacancyNumber)
{
InboxDTO info = new InboxDTO();
SqlConnection oConn = new SqlConnection();
SqlCommand sqlCmd = null;
try
{
oConn.ConnectionString = ConfigurationManager.AppSettings["conn"];
oConn.Open();
sqlCmd = oConn.CreateCommand();
sqlCmd.CommandType = CommandType.Text;
sqlCmd.CommandText = "select * from Inbox where userName = '******' AND vacancyNumber = " + vacancyNumber;
SqlDataReader rdr = sqlCmd.ExecuteReader();
if (rdr.HasRows)
{
while (rdr.Read())
{
info.userName = rdr["userName"].ToString();
info.vacancyNumber = rdr["vacancyNumber"].ToString();
info.date = DateTime.Parse(rdr["date"].ToString() );
info.unread = rdr["unread"].ToString();
info.message = rdr["message"].ToString();
info.status = rdr["status"].ToString();
}
}
}
catch
{ }
finally
{
if (sqlCmd != null)
{
sqlCmd = null;
}
if (oConn != null)
{
if (oConn.State.Equals(ConnectionState.Open))
{
oConn.Close();
}
oConn = null;
}
}
return info;
}
public InboxDTO find(string userName, int messageId)
{
var obj = (from p in ctx.Inboxes
where p.userName == @userName && p.messageId == @messageId
select p).Single();
InboxDTO add = new InboxDTO();
add.userName = obj.userName;
add.messageId = obj.messageId;
add.date = obj.date;
add.unread = obj.unread;
add.message = obj.message;
return add;
}
public IHttpActionResult Create([FromBody] InboxDTO inboxDTO)
{
try
{
var inboxBusiness = new InboxBusiness();
var inbox = inboxBusiness.Create(inboxDTO);
return(Ok(inbox));
}
catch (Exception e)
{
return(BadRequest(e.Message));
}
}
public void InboxDAOConstructorTest()
{
/*Context*/
InboxDAO inbox_context = new InboxDAO();
AccountDAO account_context = new AccountDAO();
/*Insert*/
AccountDTO account = new AccountDTO();
account.userName = "******";
account.status = "active";
account.password = "******";
account.accountType = "admin";
account_context.presist(account);
InboxDTO inbox = new InboxDTO();
inbox.date = new DateTime(2012, 9, 30);
inbox.message = "success";
inbox.vacancyNumber = "1";
inbox.unread = "read";
inbox.userName = "******";
inbox.status = "applied";
inbox_context.presist(inbox);
bool expected = true;
bool actual;
actual = inbox_context.isFound("john", "1");
Assert.AreEqual(expected, actual);
/*Update*/
inbox.unread = "not read";
inbox_context.merge(inbox);
string expectedUpdate = "not read";
InboxDTO contUpd = inbox_context.find("john", "1");
Assert.AreEqual(expectedUpdate, contUpd.unread);
/*Delete*/
inbox_context.removeByUserId("john", "1");
bool expectedDelete = false;
bool actualDelete = inbox_context.isFound("john", "1");
Assert.AreEqual(expectedDelete, actualDelete);
account_context.removeByUserId("john");
}
public List<InboxDTO> findAll()
{
var objs = (from p in ctx.Inboxes
select p);
InboxDTO add = null;
List<InboxDTO> addList = new List<InboxDTO>();
foreach (Inbox obj in objs)
{
add = new InboxDTO();
add.userName = obj.userName;
add.messageId = obj.messageId;
add.date = obj.date;
add.unread = obj.unread;
add.message = obj.message;
addList.Add(add);
}
return addList;
}
public bool remove(InboxDTO entity)
{
return this.removeByUserId(entity.userName, entity.vacancyNumber);
}
public bool presist(InboxDTO entity)
{
bool success = false;
SqlConnection oConn = new SqlConnection();
SqlCommand sqlCmd = null;
try
{
oConn.ConnectionString = ConfigurationManager.AppSettings["conn"];
oConn.Open();
sqlCmd = oConn.CreateCommand();
sqlCmd.CommandType = CommandType.StoredProcedure;
sqlCmd.CommandText = "insertInbox";
sqlCmd.Parameters.Add(new SqlParameter("userName", entity.userName));
sqlCmd.Parameters.Add(new SqlParameter("vacancyNumber", entity.vacancyNumber));
sqlCmd.Parameters.Add(new SqlParameter("date", entity.date));
sqlCmd.Parameters.Add(new SqlParameter("unread", entity.unread));
sqlCmd.Parameters.Add(new SqlParameter("message", entity.message));
sqlCmd.Parameters.Add(new SqlParameter("status", entity.status));
SqlDataReader rdr = sqlCmd.ExecuteReader();
if (rdr.HasRows)
{
while (rdr.Read())
{ } //Read all
}
rdr.Close();
if (rdr.RecordsAffected > 0)
success = true;
}
catch { }
finally
{
if (sqlCmd != null)
{
sqlCmd = null;
}
if (oConn != null)
{
if (oConn.State.Equals(ConnectionState.Open))
{
oConn.Close();
}
oConn = null;
}
}
return success;
}
public bool remove(InboxDTO entity)
{
return this.removeByUserId(entity.userName,entity.messageId);
}
public bool presist(InboxDTO entity)
{
try
{
model.Inbox obj = new Inbox();
obj.userName = entity.userName;
obj.messageId = entity.messageId;
obj.date = entity.date;
obj.unread = entity.unread;
obj.message = entity.message;
ctx.Inboxes.InsertOnSubmit(obj);
ctx.SubmitChanges();
return true;
}
catch (Exception)
{
ctx.Dispose();
ctx = new ModelDataContext();
return false;
}
}
public void inboxMessagesTest()
{
InboxService inboxService = new InboxServiceImpl();
/*Context*/
InboxDAO inbox_context = new InboxDAO();
AccountDAO account_context = new AccountDAO();
/*Insert*/
AccountDTO account = new AccountDTO();
account.userName = "******";
account.status = "active";
account.password = "******";
account.accountType = "admin";
account_context.presist(account);
InboxDTO inbox = new InboxDTO();
inbox.date = new DateTime(2012, 9, 30);
inbox.message = "success";
inbox.messageId = 1;
inbox.unread = "unread";
inbox.userName = "******";
inbox_context.presist(inbox);
bool expected = true;
bool actual;
actual = inbox_context.isFound("griddy", 1);
Assert.AreEqual(expected, actual);
//Test getInboxMessagesByDate method
Assert.AreEqual(true, inboxService.hasUnreadMessage("griddy"));
//Test getInboxMessagesByMessage method
int inboxMessageNumber = inboxService.getNumberOfInboxMessages("griddy");
Assert.AreEqual(1, inboxMessageNumber);
//Test setMessagesRead method
inboxService.setMessagesRead("griddy", 1);
InboxMessageSearchService inboxSearchService = new InboxMessageSearchServiceImpl();
List<InboxDTO> inboxDtoList = inboxSearchService.getInboxMessagesByUsername("griddy");
Assert.AreEqual("read", inboxDtoList[0].unread);
inboxDtoList.RemoveRange(0, inboxDtoList.Count);
inboxDtoList = null;
inbox = null;
/*Delete*/
inbox_context = new InboxDAO();
inbox_context.removeByUserId("griddy", 1);
bool expectedDelete = false;
bool actualDelete = inbox_context.isFound("griddy", 1);
Assert.AreEqual(expectedDelete, actualDelete);
account_context.removeByUserId("griddy");
}
