public List <Company> Get()
{
List <Company> list = new List <Company>();
using (var db = new DWContext())
{
using (MySqlConnection conn = new MySqlConnection(db.ConnectionString))
{
conn.Open();
MySqlCommand cmd = new MySqlCommand("select * from company order by (case id when 2 then 0 else 1 end) asc, id asc", conn);
using (var reader = cmd.ExecuteReader())
{
while (reader.Read())
{
list.Add(new Company()
{
ID = Convert.ToInt32(reader["Id"]),
CompanyName = reader["CompanyName"].ToString(),
Logo = reader["Logo"].ToString(),
Code = Convert.ToInt32(reader["Code"]),
});
}
}
}
return(list);
}
}
public List <DWBIUser> GetUserByCompany(int companyID)
{
List <DWBIUser> list = new List <DWBIUser>();
using (var db = new DWContext())
{
using (MySqlConnection conn = new MySqlConnection(db.ConnectionString))
{
conn.Open();
MySqlCommand cmd = new MySqlCommand("select * from user where companyID=" + companyID, conn);
using (var reader = cmd.ExecuteReader())
{
while (reader.Read())
{
list.Add(new DWBIUser()
{
ID = Convert.ToInt32(reader["Id"]),
Name = reader["Name"].ToString(),
CompanyID = Convert.ToInt32(reader["CompanyID"]),
UserID = reader["UserID"].ToString()
});
}
}
}
return(list);
}
}
public bool Post([FromBody] KeyValuePair <string, string> item)
{
using (var db = new DWContext())
{
using (MySqlConnection conn = new MySqlConnection(db.ConnectionString))
{
conn.Open();
if (IsExist(item.Key, conn))
{
// MySqlCommand cmd = new MySqlCommand("update setting set value='"
//+ item.Value + "'"
//+ "' where KeyName='" + item.Key + "'", conn);
MySqlCommand cmd = new MySqlCommand("update setting set value='" + item.Value + "' where keyName='" + item.Key + "'", conn);
cmd.ExecuteNonQuery();
}
else
{
MySqlCommand cmd = new MySqlCommand("insert into setting(keyName, value) values('"
+ item.Key + "', '"
+ item.Value + "')", conn);
cmd.ExecuteNonQuery();
}
}
}
return(true);
}
private List <Company> GetCompanies(int id)
{
using (var db = new DWContext())
{
using (MySqlConnection conn = new MySqlConnection(db.ConnectionString))
{
conn.Open();
MySqlCommand cmd = new MySqlCommand("get_CompaniesByUserID", conn);
cmd.CommandType = System.Data.CommandType.StoredProcedure;
cmd.Parameters.Add(new MySqlParameter("@id", id));
List <Company> companies = new List <Company>();
using (var reader = cmd.ExecuteReader())
{
while (reader.Read())
{
companies.Add(new Company()
{
CompanyName = reader["companyName"].ToString(),
Code = Convert.ToInt32(reader["code"]),
});
}
}
return(companies);
}
}
}
public bool SaveUser(DWBIUser user)
{
try
{
using (var db = new DWContext())
{
using (MySqlConnection conn = new MySqlConnection(db.ConnectionString))
{
conn.Open();
MySqlCommand cmd = new MySqlCommand("insert into user(Name, CompanyID, UserRole, isAdmin, UserID) values('"
+ user.Name + "', '"
+ user.CompanyID + "', '"
+ (int)user.UserRole + "', '"
+ 0 + "', '"
+ user.UserID + "')", conn);
cmd.ExecuteNonQuery();
}
}
return(true);
}
catch (Exception ex)
{
return(true);
}
}
public List <Company> GetCompanyInScenario()
{
List <Company> list = new List <Company>();
using (var db = new DWContext())
{
using (MySqlConnection conn = new MySqlConnection(db.ConnectionString))
{
conn.Open();
MySqlCommand cmd = new MySqlCommand("select * from company where code in (1200, 1300, 1400, 1500) order by code asc", conn);
using (var reader = cmd.ExecuteReader())
{
while (reader.Read())
{
list.Add(new Company()
{
ID = Convert.ToInt32(reader["Id"]),
CompanyName = reader["CompanyName"].ToString(),
Logo = reader["Logo"].ToString(),
Code = Convert.ToInt32(reader["Code"]),
});
}
}
}
return(list);
}
}
//[Authorize]
public List <DWBIUser> Get()
{
List <DWBIUser> list = new List <DWBIUser>();
using (var db = new DWContext())
{
using (MySqlConnection conn = new MySqlConnection(db.ConnectionString))
{
conn.Open();
MySqlCommand cmd = new MySqlCommand("get_users", conn);
cmd.CommandType = System.Data.CommandType.StoredProcedure;
using (var reader = cmd.ExecuteReader())
{
while (reader.Read())
{
list.Add(new DWBIUser()
{
ID = Convert.ToInt32(reader["Id"]),
Name = reader["Name"].ToString(),
CompanyID = Convert.ToInt32(reader["CompanyID"]),
CompanyCode = Convert.ToInt32(reader["CompanyCode"]),
UserID = reader["UserID"].ToString(),
CompanyName = reader["CompanyName"].ToString()
});
}
}
}
return(list);
}
}
public List <Category> Get()
{
List <Category> list = new List <Category>();
using (var db = new DWContext())
{
using (MySqlConnection conn = new MySqlConnection(db.ConnectionString))
{
conn.Open();
MySqlCommand cmd = new MySqlCommand("select * from category", conn);
using (var reader = cmd.ExecuteReader())
{
while (reader.Read())
{
list.Add(new Category()
{
ID = Convert.ToInt32(reader["Id"]),
Title = reader["Title"].ToString(),
});
}
}
}
return(list);
}
}
public List <MenuSet> GetMenuList()
{
// 세션이 끊긴 상태
if (DWUserInfo == null || DWUserInfo.ID == 0)
{
Response.StatusCode = 600;
return(null);
}
using (var db = new DWContext())
{
List <Menu> list = new List <Menu>();
KPIController kpi = new KPIController();
using (MySqlConnection conn = new MySqlConnection(db.ConnectionString))
{
conn.Open();
MySqlCommand cmd = new MySqlCommand("get_menusByCompany", conn);
cmd.CommandType = System.Data.CommandType.StoredProcedure;
cmd.Parameters.Add(new MySqlParameter("@roleID", DWUserInfo.RoleID));
cmd.Parameters.Add(new MySqlParameter("@CompanyCode", DWUserInfo.CompanyCode));
using (var reader = cmd.ExecuteReader())
{
while (reader.Read())
{
if (DWUserInfo.UserID == "*****@*****.**" && reader["Category"].ToString() == "FineReport")
{
}
else
{
list.Add(new Menu()
{
ID = Convert.ToInt32(reader["Id"]),
Category = reader["Category"].ToString(),
Close = reader["Close"].ToString(),
CompanyCode = Convert.ToInt32(reader["Id"]),
Title = reader["Title"].ToString(),
URL = reader["Url"].ToString(),
Level = reader["Level"].ToString(),
ParentID = reader["ParentID"].ToString(),
});
}
}
}
}
var results = list.GroupBy(o => o.Category);
List <MenuSet> menuSet = new List <MenuSet>();
foreach (var item in results)
{
MenuSet set = new MenuSet();
set.Category = item.Key;
set.Menus = getMenu(item);
menuSet.Add(set);
}
return(menuSet);
}
}
protected virtual void Dispose(bool disposing)
{
if (disposing && RepositoryContext != null)
{
RepositoryContext.Dispose();
RepositoryContext = null;
}
}
public List <KPI> Get()
{
List <KPI> list = new List <KPI>();
var user = UserController.GetByKey(UserID, Request);
//2019-12-26 김태규 수정 배포
var id = HttpContext.Request.Headers["company"];
var company = "";
if (id.Count > 0)
{
company = id.FirstOrDefault();
}
using (var db = new DWContext())
{
using (MySqlConnection conn = new MySqlConnection(db.ConnectionString))
{
conn.Open();
MySqlCommand cmd = new MySqlCommand("get_AllKPIs", conn);
cmd.CommandType = System.Data.CommandType.StoredProcedure;
//2019-12-26 김태규 수정 배포
//cmd.Parameters.Add(new MySqlParameter("@companyCode", user.CompanyCode));
cmd.Parameters.Add(new MySqlParameter("@companyCode", company));
using (var reader = cmd.ExecuteReader())
{
while (reader.Read())
{
list.Add(new KPI()
{
ID = Convert.ToInt32(reader["Id"]),
Category = reader["Category"].ToString(),
URL = reader["URL"].ToString(),
DetailURL = reader["DetailURL"].ToString(),
Title = reader["Title"].ToString(),
KPIBankID = reader["Id"].ToString(),
CompanyCode = reader["code"].ToString(),
CompanyName = reader["CompanyName"].ToString(),
Close = reader["Close"].ToString(),
ChartType = reader["ChartType"].ToString()
});
}
}
}
if (user.UserRole == Role.Member)
{
//return list.Where(o => o.CompanyCode == user.CompanyCode.ToString()).ToList();
//2019-12-26 김태규 수정 배포
return(list.Where(o => o.CompanyCode == company).ToList());
}
else
{
return(list);
}
}
}
public List <MenuSet> Get(string companyID)
{
var user = UserController.GetByKey(UserID, Request);
using (var db = new DWContext())
{
List <Menu> list = new List <Menu>();
KPIController kpi = new KPIController();
using (MySqlConnection conn = new MySqlConnection(db.ConnectionString))
{
conn.Open();
MySqlCommand cmd = new MySqlCommand("get_menusByCompany", conn);
cmd.CommandType = System.Data.CommandType.StoredProcedure;
cmd.Parameters.Add(new MySqlParameter("@roleID", user.RoleID));
cmd.Parameters.Add(new MySqlParameter("@CompanyCode", companyID));
using (var reader = cmd.ExecuteReader())
{
while (reader.Read())
{
//2020-01-23 임병규 수정 배포 : 사장님 FineReport 메뉴 사용안함 처리
if (user.UserID == "*****@*****.**" && reader["Category"].ToString() == "FineReport")
{
}
else
{
list.Add(new Menu()
{
ID = Convert.ToInt32(reader["Id"]),
Category = reader["Category"].ToString(),
Close = reader["Close"].ToString(),
CompanyCode = Convert.ToInt32(reader["Id"]),
Title = reader["Title"].ToString(),
URL = reader["Url"].ToString(),
Level = reader["Level"].ToString(),
ParentID = reader["ParentID"].ToString(),
});
}
}
}
}
var results = list.GroupBy(o => o.Category);
List <MenuSet> menuSet = new List <MenuSet>();
foreach (var item in results)
{
MenuSet set = new MenuSet();
set.Category = item.Key;
set.Menus = getMenu(item);
menuSet.Add(set);
}
return(menuSet);
}
}
public List <Page> Get()
{
// 세션이 끊긴 상태
if (DWUserInfo == null || DWUserInfo.ID == 0)
{
Response.StatusCode = 600;
return(null);
}
try
{
using (var db = new DWContext())
{
List <Page> list = new List <Page>();
KPIController kpi = new KPIController();
using (MySqlConnection conn = new MySqlConnection(db.ConnectionString))
{
conn.Open();
MySqlCommand cmd = new MySqlCommand("select * from pages where userID = '" + DWUserInfo.UserID + "' and companyCode = '" + DWUserInfo.CompanyCode + "' order by seq asc", conn);
using (var reader = cmd.ExecuteReader())
{
while (reader.Read())
{
list.Add(new Page()
{
ID = Convert.ToInt32(reader["Id"]),
Seq = Convert.ToInt32(reader["Seq"]),
KPIs = kpi.GetKpiByPage(Convert.ToInt32(reader["Id"]), DWUserInfo.CompanyCode.ToString()),
Title = reader["Title"].ToString(),
Layout = reader["Layout"].ToString()
});
}
}
}
return(list);
}
}
catch (Exception ex)
{
List <Page> p = new List <Page>();
Page p1 = new Page();
p1.Title = ex.Message;
p.Add(p1);
Page p2 = new Page();
p2.Title = ex.InnerException.Message;
p.Add(p2);
return(p);
}
}
public List <KPI> Get()
{
// 세션이 끊긴 상태
if (DWUserInfo == null || DWUserInfo.ID == 0)
{
Response.StatusCode = 600;
return(null);
}
List <KPI> list = new List <KPI>();
int mainCompanyCode = DWUserInfo.CompanyCode;
using (var db = new DWContext())
{
using (MySqlConnection conn = new MySqlConnection(db.ConnectionString))
{
conn.Open();
MySqlCommand cmd = new MySqlCommand("get_AllKPIs", conn);
cmd.CommandType = System.Data.CommandType.StoredProcedure;
cmd.Parameters.Add(new MySqlParameter("@companyCode", mainCompanyCode));
using (var reader = cmd.ExecuteReader())
{
while (reader.Read())
{
list.Add(new KPI()
{
ID = Convert.ToInt32(reader["Id"]),
Category = reader["Category"].ToString(),
URL = reader["URL"].ToString(),
DetailURL = reader["DetailURL"].ToString(),
Title = reader["Title"].ToString(),
KPIBankID = reader["Id"].ToString(),
CompanyCode = reader["code"].ToString(),
CompanyName = reader["CompanyName"].ToString(),
Close = reader["Close"].ToString(),
ChartType = reader["ChartType"].ToString()
});
}
}
}
if (DWUserInfo.UserRole == Role.Member)
{
return(list.Where(o => o.CompanyCode == mainCompanyCode.ToString()).ToList());
}
else
{
return(list);
}
}
}
public bool Delete()
{
var id = HttpContext.Request.Query["id"];
using (var db = new DWContext())
{
using (MySqlConnection conn = new MySqlConnection(db.ConnectionString))
{
conn.Open();
MySqlCommand cmd = new MySqlCommand("delete from kpibank where id=" + id[0], conn);
cmd.ExecuteNonQuery();
}
}
return(true);
}
public bool Put([FromBody] Page page, string userID)
{
using (var db = new DWContext())
{
using (MySqlConnection conn = new MySqlConnection(db.ConnectionString))
{
conn.Open();
MySqlCommand cmd = new MySqlCommand("update pages set title= '" + page.Title + "', layout= '" + page.Layout + "', seq='" + page.Seq + "' where id='" + page.ID + "'", conn);
cmd.ExecuteNonQuery();
UpdateChildKPIs(page.KPIs, page.ID, userID, conn);
}
}
return(true);
}
public string ChangeUserPassword(string oldPassword, string newPassword)
{
// 세션이 끊긴 상태
if (DWUserInfo == null || DWUserInfo.ID == 0)
{
Response.StatusCode = 600;
return(null);
}
if (String.IsNullOrWhiteSpace(oldPassword) || String.IsNullOrWhiteSpace(newPassword))
{
return("fail:비밀번호 정보가 정상적으로 전달되지 않았습니다.");
}
Encryptor ec = new Encryptor(fineKey, fineIV);
string old_encrypt_password = ec.Encrypt(oldPassword);
string new_encrypt_password = ec.Encrypt(newPassword);
using (var db = new DWContext())
{
using (MySqlConnection conn = new MySqlConnection(db.ConnectionString))
{
conn.Open();
string read_sql = $"select * from user where userid = '{DWUserInfo.UserID}' and pw = '{old_encrypt_password}'";
MySqlCommand cmd = new MySqlCommand(read_sql, conn);
DataTable dt = new DataTable();
MySqlDataAdapter adapter = new MySqlDataAdapter(cmd);
adapter.Fill(dt);
if (dt == null || dt.Rows.Count != 1)
{
return("fail:이전 비밀번호가 일치하지 않습니다. 비밀번호를 다시 확인해 주세요.");
}
string update_sql = $"update user set pw = '{new_encrypt_password}' where userid = '{DWUserInfo.UserID}'";
cmd = new MySqlCommand(update_sql, conn);
cmd.ExecuteNonQuery();
}
}
return("success:비밀번호가 변경되었습니다. 다시 로그인해 주세요.");
}
private bool IsExist(string key, MySqlConnection conn)
{
using (var db = new DWContext())
{
MySqlCommand cmd = new MySqlCommand("select * from setting where keyName ='" + key + "'", conn);
using (var reader = cmd.ExecuteReader())
{
if (!reader.HasRows)
{
return(false);
}
return(true);
}
}
}
public bool Update([FromBody] KeyValuePair <string, string> item)
{
using (var db = new DWContext())
{
using (MySqlConnection conn = new MySqlConnection(db.ConnectionString))
{
conn.Open();
MySqlCommand cmd = new MySqlCommand("update setting set value='"
+ item.Value + "'"
+ "' where KeyName=" + item.Key, conn);
cmd.ExecuteNonQuery();
}
}
return(true);
}
public bool Update([FromBody] DWBIUser user)
{
// 세션이 끊긴 상태
if (DWUserInfo == null || DWUserInfo.ID == 0)
{
Response.StatusCode = 600;
return(false);
}
using (var db = new DWContext())
{
using (MySqlConnection conn = new MySqlConnection(db.ConnectionString))
{
conn.Open();
string update_sql = $@"
update user
set name = '{user.Name}'
, companyID = {user.CompanyID}
, UserID = '{user.UserID}'
, UserRole= {(int)user.UserRole}
where id = '{user.ID}'";
if (!String.IsNullOrWhiteSpace(user.Password))
{
Encryptor ec = new Encryptor(fineKey, fineIV);
string encrypt_password = ec.Encrypt(user.Password);
update_sql = $@"
update user
set name = '{user.Name}'
, companyID = {user.CompanyID}
, UserID = '{user.UserID}'
, UserRole= {(int)user.UserRole}
, PW = '{encrypt_password}'
where id = '{user.ID}'";
}
MySqlCommand cmd = new MySqlCommand(update_sql, conn);
cmd.ExecuteNonQuery();
}
}
return(true);
}
public List <MenuSet> GetMenuInScenario(string companyCode)
{
using (var db = new DWContext())
{
List <Menu> list = new List <Menu>();
using (MySqlConnection conn = new MySqlConnection(db.ConnectionString))
{
conn.Open();
MySqlCommand cmd = new MySqlCommand($"select Menu.ID, ifnull(Menu.Close, '') as Close, Menu.CompanyCode, Menu.Title as MenuTitle, Menu.Url, Menu.Level, Menu.ParentID, Category.Title as CategoryTitle from Menu inner join Category on Menu.categoryCode = Category.id where Menu.companyCode = '{companyCode}' and Menu.CategoryCode in (1, 2, 3)", conn);
using (var reader = cmd.ExecuteReader())
{
while (reader.Read())
{
list.Add(new Menu()
{
ID = Convert.ToInt32(reader["ID"]),
Category = reader["CategoryTitle"].ToString(),
Close = reader["Close"].ToString(),
CompanyCode = Convert.ToInt32(reader["CompanyCode"]),
Title = reader["MenuTitle"].ToString(),
URL = reader["Url"].ToString(),
Level = reader["Level"].ToString(),
ParentID = reader["ParentID"].ToString(),
});
}
}
}
var results = list.GroupBy(o => o.Category);
List <MenuSet> menuSet = new List <MenuSet>();
foreach (var item in results)
{
MenuSet set = new MenuSet();
set.Category = item.Key;
set.Menus = getMenu(item);
menuSet.Add(set);
}
return(menuSet);
}
}
public List <Page> Get(string companyCode)
{
try
{
using (var db = new DWContext())
{
var user = UserController.GetByKey(UserID, Request);
List <Page> list = new List <Page>();
KPIController kpi = new KPIController();
using (MySqlConnection conn = new MySqlConnection(db.ConnectionString))
{
conn.Open();
MySqlCommand cmd = new MySqlCommand("select * from pages where userID = '" + UserID + "' and companyCode = '" + companyCode + "' order by seq asc", conn);
using (var reader = cmd.ExecuteReader())
{
while (reader.Read())
{
list.Add(new Page()
{
ID = Convert.ToInt32(reader["Id"]),
Seq = Convert.ToInt32(reader["Seq"]),
KPIs = GetKPIs(Convert.ToInt32(reader["Id"]), kpi, user, companyCode),
Title = reader["Title"].ToString(),
Layout = reader["Layout"].ToString()
});
}
}
}
return(list);
}
}
catch (Exception ex)
{
List <Page> p = new List <Page>();
Page p1 = new Page();
p1.Title = ex.Message;
p.Add(p1);
Page p2 = new Page();
p2.Title = ex.InnerException.Message;
p.Add(p2);
return(p);
}
}
public bool Update([FromBody] DWBIUser user)
{
using (var db = new DWContext())
{
using (MySqlConnection conn = new MySqlConnection(db.ConnectionString))
{
conn.Open();
MySqlCommand cmd = new MySqlCommand("update user set name='"
+ user.Name + "', companyID= '" + user.CompanyID
+ "', UserID= '" + user.UserID
+ "', UserRole= '" + (int)user.UserRole
+ "' where id=" + user.ID, conn);
cmd.ExecuteNonQuery();
}
}
return(true);
}
public bool Post([FromBody] Page page, string userID)
{
using (var db = new DWContext())
{
using (MySqlConnection conn = new MySqlConnection(db.ConnectionString))
{
conn.Open();
MySqlCommand cmd = new MySqlCommand("insert into pages(title, layout, userID, seq) values('"
+ page.Title + "', '"
+ page.Layout + "', '"
+ userID + "', '"
+ page.Seq + "')", conn);
cmd.ExecuteNonQuery();
long id = cmd.LastInsertedId;
SaveChildKPIs(page.KPIs, id, userID, conn);
}
}
return(true);
}
public JsonResult OnGetCheckAnalysis(string business_ids)
{
if (String.IsNullOrWhiteSpace(business_ids))
{
return(new JsonResult("원인분석을 완료시킬 항목이 선택되지 않았습니다."));
}
using (var db = new DWContext())
{
using (MySqlConnection conn = new MySqlConnection(db.ConnectionString))
{
conn.Open();
MySqlCommand cmd = new MySqlCommand($"update business_base set isAnalysis = 'Y', analysis_date = now() where business_id in ({business_ids.TrimEnd(',')})", conn);
cmd.ExecuteNonQuery();
}
}
return(new JsonResult("정상적으로 처리되었습니다."));
}
public JsonResult OnGetUnCheckPublish(string business_ids)
{
if (String.IsNullOrWhiteSpace(business_ids))
{
return(new JsonResult("게시를 해제할 항목이 선택되지 않았습니다."));
}
using (var db = new DWContext())
{
using (MySqlConnection conn = new MySqlConnection(db.ConnectionString))
{
conn.Open();
MySqlCommand cmd = new MySqlCommand($"update business_base set isPublish = 'N', publish_date = null where business_id in ({business_ids.TrimEnd(',')});", conn);
cmd.ExecuteNonQuery();
}
}
return(new JsonResult("정상적으로 처리되었습니다."));
}
public bool Post([FromBody] KPI kpi)
{
using (var db = new DWContext())
{
using (MySqlConnection conn = new MySqlConnection(db.ConnectionString))
{
conn.Open();
MySqlCommand cmd = new MySqlCommand("insert into kpibank(category, url, detailURL, close, companyCode, chartType, title) values('"
+ kpi.Category + "', '"
+ kpi.URL + "', '"
+ kpi.DetailURL + "', '"
+ kpi.Close + "', '"
+ kpi.CompanyCode + "', '"
+ kpi.ChartType + "', '"
+ kpi.Title + "')", conn);
cmd.ExecuteNonQuery();
}
}
return(true);
}
public bool Update([FromBody] KPI kpi)
{
using (var db = new DWContext())
{
using (MySqlConnection conn = new MySqlConnection(db.ConnectionString))
{
conn.Open();
MySqlCommand cmd = new MySqlCommand("update kpibank set category='"
+ kpi.Category + "', url= '" + kpi.URL
+ "', title= '" + kpi.Title
+ "', category= '" + kpi.Category
+ "', close= '" + kpi.Close
+ "', companyCode= '" + kpi.CompanyCode
+ "', chartType= '" + int.Parse(kpi.ChartType)
+ "', detailURL= '" + kpi.DetailURL
+ "' where id=" + kpi.ID, conn);
cmd.ExecuteNonQuery();
}
}
return(true);
}
//20200109 김태규 수정 배포
//public bool Delete()
public bool DeleteUser([FromBody] DWBIUser user)
{
// 세션이 끊긴 상태
if (DWUserInfo == null || DWUserInfo.ID == 0)
{
Response.StatusCode = 600;
return(false);
}
using (var db = new DWContext())
{
using (MySqlConnection conn = new MySqlConnection(db.ConnectionString))
{
conn.Open();
MySqlCommand cmd = new MySqlCommand("delete from user where id=" + user.ID, conn);
cmd.ExecuteNonQuery();
}
}
return(true);
}
//20200109 김태규 수정 배포
//public bool Delete()
public async Task <bool> Delete()
{
var id = HttpContext.Request.Query["id"];
//20200109 김태규 수정 배포
var email = HttpContext.Request.Query["userid"];
using (var db = new DWContext())
{
using (MySqlConnection conn = new MySqlConnection(db.ConnectionString))
{
conn.Open();
MySqlCommand cmd = new MySqlCommand("delete from user where id=" + id[0], conn);
cmd.ExecuteNonQuery();
}
}
//user.Email = email[0];
IdentityUser user = await _userManager.FindByEmailAsync(email[0]);
user.UserName = email[0];
var result = await _userManager.DeleteAsync(user);
return(true);
}
