- task_management.zip
- Task_Management
- 3LayerArchitecture11.JPG
- Database
- TaskManagementSystemDB.mdf
- TaskManagementSystemDB_log.ldf
- TaskManagementSystem
- App_Code
- BLL
- DataLayerClass
- DAO
- Gateway
- App_Data
- App_Themes
- Theme
- Bin
- AjaxControlToolkit.dll
- AjaxControlToolkit.dll.refresh
- AjaxControlToolkit.pdb
- Javascript
- Master
- TaskManagementSystem (4).sln
- TaskManagementSystem (4).suo
- TaskManagementSystem.suo
- UI
- Web.config
|
using System;
using System.Data;
using System.Configuration;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Web.UI.HtmlControls;
/// <summary>
/// Summary description for CommentGateWay
/// </summary>
public class CommentGateWay
{
DataExecuteClass DEC = null;
public CommentGateWay()
{
//
// TODO: Add constructor logic here
//
}
public bool InsertNewComment(Comment commentObj)
{
try
{
string insertSting = "INSERT INTO t_Comment (CommentBody, TaskId, ProjectId, CommentDate, CommentBy, Attachment) VALUES ('" + commentObj.CommentBody + "', '" + commentObj.CommentTaskId + "','" + commentObj.CommentProjectId + "','" + commentObj.CommentDate + "', '" + commentObj.CommentSenderId+"', '"+commentObj.CommentAttachmentAddress+"' )";
DEC = new DataExecuteClass();
DEC.ExecuteNonQuery(insertSting);
return true;
}
catch
{
return false;
}
}
public DataTable SelectAllCommentForSpecificTask(string taskId)
{
DEC = new DataExecuteClass();
string selectString = "select CommentBody, TaskId, ProjectId, CommentDate, CommentBy, Attachment from t_Comment where TaskId = '"+taskId+"'";
DataTable dt = DEC.getDataSet(selectString).Tables[0];
return dt;
}
}
|
By viewing downloads associated with this article you agree to the Terms of Service and the article's licence.
If a file you wish to view isn't highlighted, and is a text file (not binary), please
let us know and we'll add colourisation support for it.
This member has not yet provided a Biography. Assume it's interesting and varied, and probably something to do with programming.
This member has not yet provided a Biography. Assume it's interesting and varied, and probably something to do with programming.