public List <VisitObjectInfo> selectVisitObjectList(String a)
{
log.Debug("=================START selectVisitObjectList=================");
List <VisitObjectInfo> list = new List <VisitObjectInfo>();
StringBuilder sql_select = new StringBuilder();
sql_select.Append("SELECT * FROM VisitObject WHERE STATUS = 'Y' ORDER BY visitObjectName");
//Execute the query against the database
using (SqlDataReader rdr = SqlHelper.ExecuteReader(SqlHelper.ConnectionStringLocalTransaction, CommandType.Text, sql_select.ToString(), null))
{
// Scroll through the results
while (rdr.Read())
{
VisitObjectInfo obj = new VisitObjectInfo();
obj = bindVisitObject(rdr, obj);
list.Add(obj);
}
}
log.Debug("=================END selectVisitObjectList=================");
return(list);
}
protected void Page_Load(object sender, EventArgs e)
{
// 관리자 체크
EmployeeInfo loginEmployee = new EmployeeInfo();
loginEmployee = (EmployeeInfo)Session["loginMember"];
if (loginEmployee == null)
{
Response.Redirect("~/login.aspx", true);
}
if (loginEmployee.ManagerLevel < 2)
{
Response.Redirect("~/login.aspx", true);
}
VisitObject bll = new VisitObject();
VisitObjectInfo visitObjectInfo = new VisitObjectInfo();
visitObjectInfo.VisitObjectCode = Convert.ToInt32(Request.QueryString["visitObjectCode"]);
int result = bll.deleteVisitObject(visitObjectInfo);
Response.Redirect("visitObjectList.aspx", true);
}
/// <summary>
///
/// </summary>
/// <param name="rdr"></param>
/// <param name="obj"></param>
/// <returns></returns>
private VisitObjectInfo bindVisitObject(SqlDataReader rdr, VisitObjectInfo obj)
{
obj.VisitObjectCode = rdr.GetInt32(0);
obj.VisitObjectName = rdr.GetString(1);
obj.RegDate = rdr.GetDateTime(2);
obj.Status = rdr.GetString(3);
return(obj);
}
protected void Page_Load(object sender, EventArgs e)
{
// 관리자 체크
EmployeeInfo loginEmployee = new EmployeeInfo();
loginEmployee = (EmployeeInfo)Session["loginMember"];
if (loginEmployee == null)
{
Response.Redirect("~/login.aspx", true);
}
if (loginEmployee.ManagerLevel < 2)
{
Response.Redirect("~/login.aspx", true);
}
if (Page.IsPostBack)
{
VisitObjectInfo visitObjectInfo = new VisitObjectInfo();
visitObjectInfo.VisitObjectCode = Convert.ToInt32(Request.QueryString["visitObjectCode"]);
visitObjectInfo.VisitObjectName = txtVisitObjectName.Text;
visitObjectInfo.Status = txtStatus.Text;
// 수정하기 sửa
if (mode.Value.Equals("modify"))
{
int result = bll.updateVisitObject(visitObjectInfo);
Response.Redirect("visitObjectList.aspx");
}
// 등록하기 đăng ký
else
{
int result = bll.insertVisitObject(visitObjectInfo);
Response.Redirect("visitObjectList.aspx");
}
}
else
{
if (Request.QueryString["mode"].Equals("modify"))
{
VisitObjectInfo visitObjectInfo = new VisitObjectInfo();
visitObjectInfo = bll.selectVisitObject(Request.QueryString["visitObjectCode"]);
txtVisitObjectName.Text = visitObjectInfo.VisitObjectName;
txtStatus.Text = visitObjectInfo.Status;
lableCodeName.Text = " Sửa thông tin (정보 수정하기) : " + visitObjectInfo.VisitObjectName;
mode.Value = Request.QueryString["mode"];
}
else
{
lableCodeName.Text = "Đăng ký mục đích thăm (방문 목적 등록하기)";
mode.Value = Request.QueryString["mode"];
}
}
}
/// <summary>
///
/// </summary>
/// <param name="visitObjectInfo"></param>
/// <returns></returns>
public int deleteVisitObject(VisitObjectInfo visitObjectInfo)
{
log.Debug("=================START deleteVisitObject=================");
log.Debug("visitObjectInfo = " + visitObjectInfo.ToString());
StringBuilder sql_delete = new StringBuilder();
sql_delete.Append("DELETE FROM VisitObject WHERE visitObjectCode=" + visitObjectInfo.VisitObjectCode);
int result = SqlHelper.ExecuteNonQuery(SqlHelper.ConnectionStringLocalTransaction, CommandType.Text, sql_delete.ToString(), null);
log.Debug("=================END deleteVisitObject=================");
return(result);
}
/// <summary>
///
/// </summary>
/// <param name="visitObjectInfo"></param>
/// <returns></returns>
public int updateVisitObject(VisitObjectInfo visitObjectInfo)
{
log.Debug("=================START updateVisitObject=================");
log.Debug("visitObjectInfo = " + visitObjectInfo.ToString());
StringBuilder sql_update = new StringBuilder();
sql_update.Append("UPDATE VisitObject SET visitObjectName=N'" + visitObjectInfo.VisitObjectName + "', status=N'" + visitObjectInfo.Status + "' WHERE visitObjectCode=" + visitObjectInfo.VisitObjectCode);
int result = SqlHelper.ExecuteNonQuery(SqlHelper.ConnectionStringLocalTransaction, CommandType.Text, sql_update.ToString(), null);
log.Debug("=================END updateVisitObject=================");
return(result);
}
protected void GridView1_RowDataBound(object sender, GridViewRowEventArgs e)
{
if (e.Row.RowType == DataControlRowType.DataRow)
{
VisitObjectInfo obj = (VisitObjectInfo)e.Row.DataItem;
HyperLink colModify = (HyperLink)e.Row.Cells[2].Controls[0];
colModify.NavigateUrl = "visitObjectEdit.aspx?visitObjectCode=" + obj.VisitObjectCode + "&mode=modify";
colModify.ImageUrl = "~/images/icon/edit.gif";
HyperLink colDelete = (HyperLink)e.Row.Cells[3].Controls[0];
colDelete.NavigateUrl = "#";
colDelete.Attributes.Add("onclick", "return confirmDelete('visitObjectDelete.aspx?visitObjectCode=" + obj.VisitObjectCode + "');");
colDelete.ImageUrl = "~/images/icon/delete.gif";
}
}
/// <summary>
///
/// </summary>
/// <param name="visitObjectInfo"></param>
/// <returns></returns>
public int insertVisitObject(VisitObjectInfo visitObjectInfo)
{
log.Debug("=================START insertVisitObject=================");
log.Debug("visitObjectInfo = " + visitObjectInfo.ToString());
StringBuilder sql_insert = new StringBuilder();
sql_insert.Append("INSERT INTO VisitObject");
sql_insert.Append(" (visitObjectName,regDate,status) ");
sql_insert.Append(" VALUES ");
sql_insert.Append(" (N'" + visitObjectInfo.VisitObjectName + "',GETDATE(), '" + visitObjectInfo.Status + "')");
int result = SqlHelper.ExecuteNonQuery(SqlHelper.ConnectionStringLocalTransaction, CommandType.Text, sql_insert.ToString(), null);
log.Debug("=================END insertVisitObject=================");
return(result);
}
/// <summary>
///
/// </summary>
/// <param name="visitObjectCode"></param>
/// <returns></returns>
public VisitObjectInfo selectVisitObject(string visitObjectCode)
{
log.Debug("=================START selectVisitObject=================");
log.Debug("visitObjectCode = " + visitObjectCode);
VisitObjectInfo obj = new VisitObjectInfo();
StringBuilder sql_select = new StringBuilder();
sql_select.Append("SELECT * FROM VisitObject WHERE visitObjectCode=" + visitObjectCode);
using (SqlDataReader rdr = SqlHelper.ExecuteReader(SqlHelper.ConnectionStringLocalTransaction, CommandType.Text, sql_select.ToString(), null))
{
if (rdr.Read())
{
obj = bindVisitObject(rdr, obj);
}
}
log.Debug("=================END selectVisitObject=================");
return(obj);
}
public int deleteVisitObject(VisitObjectInfo visitObjectInfo)
{
return(dal.deleteVisitObject(visitObjectInfo));
}
public int insertVisitObject(VisitObjectInfo visitObjectInfo)
{
return(dal.insertVisitObject(visitObjectInfo));
}
public int updateVisitObject(VisitObjectInfo visitObjectInfo)
{
return(dal.updateVisitObject(visitObjectInfo));
}
