public List <CateGoryEntity> GetCateGoryListByUserID(int UserID)
{
string strSql = @"SELECT [GID]
,[Title]
,[CreatedOn]
,[CreatedBy]
,[IsOnlyShowTody]
,[IsDelete]
FROM [CateGory]
WHERE [CreatedBy]=@UserID AND IsDelete = 0
Order by GID asc ";
List <CateGoryEntity> list = new List <CateGoryEntity>();
Database db = DatabaseFactory.CreateDatabase();
using (DbCommand dbCommand = db.GetSqlStringCommand(strSql))
{
try
{
db.AddInParameter(dbCommand, "UserID", DbType.Int32, UserID);
using (IDataReader dataReader = db.ExecuteReader(dbCommand))
while (dataReader.Read())
{
list.Add(CateGoryEntity.ReaderBind(dataReader));
}
}
catch (Exception ex)
{
WebLogAgent.Write(string.Format("[SQLText:{0},{1}Messages:\r\n{2}]"
, strSql.ToString(), base.FormatParameters(dbCommand.Parameters), ex.Message));
return(null);
}
}
return(list);
}
private void InitControl()
{
int category = QS("id", 0);
if (category == 0)
{
ShowArgumentErrorMessageToClient();
return;
}
CateGoryEntity model = cgApp.GetCateGory(category);
if (model == null || model.IsDelete == true)
{
ShowArgumentErrorMessageToClient();
Response.Redirect("/error.html?sourceurl=" + Request.Url.ToString());
}
SearchTicketsRequest request = new SearchTicketsRequest(SearchTicketsType.CateGory,
" OrderNum ASC ,Priority DESC,TicketTitle ASC ",
true);
request.SheetDate = request.SheetDate = ObjectFactory.GetInstance <ISystemDateTime>().Now.Date;
request.CateGoryID = category;
request.CurrentPage = anpTickets.CurrentPageIndex;
SearchTicketsResponse response = tickApp.SearchTickets(request);
rptTickets.DataSource = response.ResultList;
rptTickets.DataBind();
anpTickets.RecordCount = response.ResultCount;
}
/// <summary>
/// Get an object entity
/// </summary>
public CateGoryEntity Get(int GID)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select * from CateGory ");
strSql.Append(" where GID=@GID ");
Database db = DatabaseFactory.CreateDatabase();
using (DbCommand dbCommand = db.GetSqlStringCommand(strSql.ToString()))
{
db.AddInParameter(dbCommand, "GID", DbType.Int32, GID);
CateGoryEntity model = null;
using (IDataReader dataReader = db.ExecuteReader(dbCommand))
{
try
{
if (dataReader.Read())
{
model = CateGoryEntity.ReaderBind(dataReader);
}
return(model);
}
catch (Exception ex)
{
WebLogAgent.Write(string.Format("[SQLText:{0},{1}Messages:\r\n{2}]",
strSql.ToString(), base.FormatParameters(dbCommand.Parameters), ex.Message));
return(null);
}
}
}
}
private CateGoryEntity GetEntity()
{
CateGoryEntity model = CateGoryFactory.CreateCateGoryEntity(UserInfo.ID, ObjectFactory.GetInstance <ISystemDateTime>());
model.Title = txtTitle.Text;
return(model);
}
private void InitControl()
{
CateGoryEntity model = CurrentModel;
if (model == null || model.IsDelete == true)
{
Response.Redirect(ErrorPageUrl);
}
SetControlsStatus(model);
SearchTicketsRequest request = new SearchTicketsRequest(SearchTicketsType.CateGory,
" OrderNum ASC ,Priority DESC,TicketTitle ASC ", false);
request.OrderBy = string.Format("{0} {1}", OrderBy, OrderDirection);
request.SheetDate = request.SheetDate = ObjectFactory.GetInstance <ISystemDateTime>().Now.Date;
request.CateGoryID = model.GID;
request.CurrentPage = CurrentPageIndex;
SearchTicketsResponse response = tickApp.SearchTickets(request);
if (response.ResultList != null && response.ResultList.Count > 0)
{
rptTicketsList.DataSource = response.ResultList;
rptTicketsList.DataBind();
trNoTickets.Visible = false;
}
else
{
trNoTickets.Visible = true;
rptTicketsList.Visible = false;
}
}
private void SetControlsStatus(CateGoryEntity category)
{
if (category == null || category.IsProtected)
{
phlDelete.Visible = false;
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
cgApp.GetCateGroyListByUserID(UserInfo.ID)
.BindDropdown <CateGoryEntity>(ddlCategories, "Title", "GID", DefaulSelectText, "", QS("category"));
if (ddlCategories.Items.Count > 1 && string.IsNullOrEmpty(ddlCategories.SelectedValue))
{
ddlCategories.SelectedIndex = 1;
}
CurrentModel = GetEntity();
if (CurrentModel != null)
{
InitControl();
}
else
{
phlDelete.Visible = false;
phlEmpty.Visible = false;
CurrentModel = new CateGoryEntity();
}
}
else
{
CurrentModel = GetEntity();
}
}
public CateGoryEntity GetCateGory(int id)
{
this.ClearBrokenRuleMessages();
CateGoryEntity entity = mgr.GetCateGory(id);
this.AddBrokenRuleMessages(mgr.BrokenRuleMessages);
return(entity);
}
public int AddCateGory(CateGoryEntity entity)
{
this.ClearBrokenRuleMessages();
int id = mgr.AddCateGory(entity);
this.AddBrokenRuleMessages(mgr.BrokenRuleMessages);
return(id);
}
protected void btnSubmit_Click(object sender, EventArgs e)
{
if (!string.IsNullOrEmpty(txtTitle.Text))
{
CateGoryEntity model = GetEntity();
int id = ccApp.AddCateGory(model);
if (id > 0)
{
Redirect(EmptyPopPageUrl, false, true);
}
else
{
ShowFailMessageToClient(ccApp.BrokenRuleMessages);
}
}
}
protected void btnSave_Click(object sender, EventArgs e)
{
if (!string.IsNullOrEmpty(txtTitle.Text))
{
CateGoryEntity model = GetEntity();
int id = ccApp.AddCateGory(model);
if (id > 0)
{
ShowSuccessMessageToClient();
}
else
{
ShowFailMessageToClient(ccApp.BrokenRuleMessages);
}
}
}
protected void btnDelete_Click(object sender, EventArgs e)
{
CateGoryEntity model = GetEntity();
if (model == null || model.IsDelete == true)
{
Response.Redirect(ErrorPageUrl);
}
if (model.IsProtected || cgApp.DeleteCateGroy(model.GID))
{
Redirect(Request.RawUrl, true);
}
else
{
ShowFailMessageToClient(cgApp.BrokenRuleMessages);
}
}
/// <summary>
/// Update a record
/// </summary>
public bool Update(CateGoryEntity model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("update CateGory set ");
strSql.Append("Title=@Title,");
strSql.Append("CreatedOn=@CreatedOn,");
strSql.Append("CreatedBy=@CreatedBy,");
strSql.Append("IsOnlyShowTody=@IsOnlyShowTody,");
strSql.Append("IsDelete=@IsDelete");
strSql.Append(" where GID=@GID ");
Database db = DatabaseFactory.CreateDatabase();
using (DbCommand dbCommand = db.GetSqlStringCommand(strSql.ToString()))
{
try
{
db.AddInParameter(dbCommand, "GID", DbType.Int32, model.GID);
db.AddInParameter(dbCommand, "Title", DbType.String, model.Title);
db.AddInParameter(dbCommand, "CreatedOn", DbType.DateTime, model.CreatedOn);
db.AddInParameter(dbCommand, "CreatedBy", DbType.Int32, model.CreatedBy);
db.AddInParameter(dbCommand, "IsOnlyShowTody", DbType.Boolean, model.IsProtected);
db.AddInParameter(dbCommand, "IsDelete", DbType.Boolean, model.IsDelete);
int rows = db.ExecuteNonQuery(dbCommand);
if (rows > 0)
{
return(true);
}
else
{
return(false);
}
}
catch (Exception ex)
{
WebLogAgent.Write(string.Format("[SQLText:{0},{1}Messages:\r\n{2}]",
strSql.ToString(), base.FormatParameters(dbCommand.Parameters), ex.Message));
return(false);
}
}
}
/// <summary>
/// Add a record
/// </summary>
public int Insert(CateGoryEntity model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into CateGory(");
strSql.Append("Title,CreatedOn,CreatedBy,IsOnlyShowTody,IsDelete)");
strSql.Append(" values (");
strSql.Append("@Title,@CreatedOn,@CreatedBy,@IsOnlyShowTody,@IsDelete)");
strSql.Append(";select ISNULL( SCOPE_IDENTITY(),0);");
Database db = DatabaseFactory.CreateDatabase();
using (DbCommand dbCommand = db.GetSqlStringCommand(strSql.ToString()))
{
try
{
db.AddInParameter(dbCommand, "Title", DbType.String, model.Title);
db.AddInParameter(dbCommand, "CreatedOn", DbType.DateTime, model.CreatedOn);
db.AddInParameter(dbCommand, "CreatedBy", DbType.Int32, model.CreatedBy);
db.AddInParameter(dbCommand, "IsOnlyShowTody", DbType.Boolean, model.IsProtected);
db.AddInParameter(dbCommand, "IsDelete", DbType.Boolean, model.IsDelete);
int result;
object obj = db.ExecuteScalar(dbCommand);
if (!int.TryParse(obj.ToString(), out result))
{
return(0);
}
return(result);
}
catch (Exception ex)
{
WebLogAgent.Write(string.Format("[SQLText:{0},{1}Messages:\r\n{2}]",
strSql.ToString(), base.FormatParameters(dbCommand.Parameters), ex.Message));
return(0);
}
}
}
