public void InsUserGroupManagerForm(UserGroupManagerVO user)
{
using (SqlCommand cmd = new SqlCommand())
{
cmd.Connection = new SqlConnection(ConnectionString);
cmd.CommandText = @"insert into UserGroup_Master (UserGroup_Code,UserGroup_Name,Admin,Use_YN,Ins_Date)
values (@UserGroup_Code,@UserGroup_Name,'N',@Use_YN,GETDATE())";
cmd.CommandType = CommandType.Text;
cmd.Parameters.AddWithValue("@UserGroup_Code", user.UserGroup_Code);
cmd.Parameters.AddWithValue("@UserGroup_Name", user.UserGroup_Name);
cmd.Parameters.AddWithValue("@Use_YN", user.Use_YN);
cmd.Connection.Open();
cmd.ExecuteScalar();
cmd.Connection.Close();
}
}
public void UpdateUserGroupManagerForm(UserGroupManagerVO user)
{
using (SqlCommand cmd = new SqlCommand())
{
cmd.Connection = new SqlConnection(ConnectionString);
cmd.CommandText = @"update UserGroup_Master
set UserGroup_Name = @UserGroup_Name,
Use_YN = @Use_YN
where UserGroup_Code = @UserGroup_Code";
cmd.CommandType = CommandType.Text;
cmd.Parameters.AddWithValue("@UserGroup_Code", user.UserGroup_Code);
cmd.Parameters.AddWithValue("@UserGroup_Name", user.UserGroup_Name);
cmd.Parameters.AddWithValue("@Use_YN", user.Use_YN);
cmd.Connection.Open();
cmd.ExecuteScalar();
cmd.Connection.Close();
}
}
public void UpdateUserGroupManagerForm(UserGroupManagerVO user)
{
UserDAC dac = new UserDAC();
dac.UpdateUserGroupManagerForm(user);
}
public void InsUserGroupManagerForm(UserGroupManagerVO user)
{
UserDAC dac = new UserDAC();
dac.InsUserGroupManagerForm(user);
}
