public static ResultEN Delete_Type(EquiptmentEN en)
{
ResultEN res = new ResultEN();
SqlCommand sqlCmd = new SqlCommand();
sqlCmd.CommandText = "Delete From " + tb_name_master + " WHERE ID = " + en.ID;
sqlCmd.CommandType = CommandType.Text;
res.result = ClassMain.ExecuteComand(sqlCmd);
return(res);
}
public static ResultEN CreateUser(string username, string password, int role_id, int branch_id)
{
ResultEN res = new ResultEN();
username = username.Trim().ToLower();
SqlCommand sqlCmd = new SqlCommand();
sqlCmd.CommandText = "select username from Users where username ='******'";
// check duplicate username
int count = ClassMain.intExecuteComand(sqlCmd);
if (count > 0)
{
res.result = false;
res.returnValue = "Duplicate Username";
return(res);
}
string strEnCrypt = SHA256.EcryptPassword(password, salt);
StringBuilder Sql = new StringBuilder();
Sql.AppendLine("INSERT INTO [dbo].[Users]");
Sql.AppendLine(" ([Username]");
Sql.AppendLine(" ,[Password]");
Sql.AppendLine(" ,[Role_id]");
Sql.AppendLine(" ,[CreatedDate]");
Sql.AppendLine(" ,[CreatedBy]");
Sql.AppendLine(")");
Sql.AppendLine(" VALUES");
Sql.AppendLine(" ('" + username + "'");
Sql.AppendLine(" ,'" + strEnCrypt + "'");
Sql.AppendLine(" ," + role_id);
Sql.AppendLine(" ,getdate()");
Sql.AppendLine(" ,'" + HttpContext.Current.User.Identity.Name + "')");
sqlCmd = new SqlCommand();
sqlCmd.CommandText = Sql.ToString();
res.result = ClassMain.ExecuteComand(sqlCmd);
if (res.result)
{
res.returnValue = "Create Username Success.";
}
return(res);
}
public static ResultEN Delete_Type(EquipmentTypeEN en)
{
ResultEN res = new ResultEN();
SqlCommand sqlCmd = new SqlCommand();
sqlCmd.CommandText = "Delete From " + tb_name_type + " WHERE ParentID = " + en.ID;
sqlCmd.CommandType = CommandType.Text;
// delete child
res.result = ClassMain.ExecuteComand(sqlCmd);
// delete parent
sqlCmd.CommandText = "Delete From " + tb_name_type + " WHERE ID = " + en.ID;
res.result = ClassMain.ExecuteComand(sqlCmd);
return(res);
}
public static ResultEN ChangeUsername(int id, string username_old, string username_new, string password)
{
ResultEN res = new ResultEN();
SqlCommand sqlCmd = new SqlCommand();
username_old = username_old.Trim().ToLower();
username_new = username_new.Trim().ToLower();
sqlCmd.CommandText = "select username from Users where username ='******' and username <> '" + username_old + "'";
// check duplicate username not self
int count = ClassMain.intExecuteComand(sqlCmd);
if (count > 0)
{
res.result = false;
res.returnValue = "Duplicate Username";
return(res);
}
string strEnCrypt = SHA256.EcryptPassword(password, salt);
sqlCmd = new SqlCommand();
StringBuilder Sql = new StringBuilder();
Sql.AppendLine("UPDATE [dbo].[Users]");
Sql.AppendLine(" SET [Username] = '" + username_new + "'");
Sql.AppendLine(" ,[Password] = '" + strEnCrypt + "'");
Sql.AppendLine(" ,[UpdDate] = getdate()");
Sql.AppendLine(" ,[UpdTime] = getdate()");
Sql.AppendLine(" ,[UpdBy] = '" + HttpContext.Current.User.Identity.Name + "'");
Sql.AppendLine(" WHERE id = " + id);
sqlCmd.CommandText = sqlCmd.ToString();
res.result = ClassMain.ExecuteComand(sqlCmd);
return(res);
}
