public string Deletemployee(EmployeeModel Items)
{
string ReturnValue = "";
SqlCommand cmd = new SqlCommand();
cmd.CommandType = CommandType.StoredProcedure;
cmd.CommandText = "DeleteEmployee";
cmd.Parameters.Add("@Id", SqlDbType.VarChar).Value = Items.Id;
try
{
SystemAdminSettings.SetAndOpenConnection(cmd);
int newId = Convert.ToInt32(cmd.ExecuteScalar());
ReturnValue = "Success";
}
catch (Exception ex)
{
throw ex;
}
finally
{
cmd.Connection.Close();
cmd.Connection.Dispose();
}
return(ReturnValue);
}
public override string Data()
{
SystemAdminSettings settings = _settingsProvider.GetSettings <SystemAdminSettings>("SystemAdmin");
if (!settings.ShowAppSettingsJson)
{
return("Viewing appsettings.json has been disabled");
}
using (StreamReader rdr = new StreamReader("appsettings.json"))
{
StringBuilder Result = new StringBuilder();
return(rdr.ReadToEnd());
}
}
public override string Data()
{
ISettingsProvider settingsProvider = (ISettingsProvider)PluginClass.GetServiceProvider.GetRequiredService <IPluginClassesService>();
SystemAdminSettings settings = settingsProvider.GetSettings <SystemAdminSettings>("SystemAdmin");
if (!settings.ShowAppSettingsJson)
{
return("Viewing appsettings.json has been disabled");
}
using (StreamReader rdr = new StreamReader("appsettings.json"))
{
StringBuilder Result = new StringBuilder();
return(rdr.ReadToEnd());
}
}
public List <EmployeeModel> GetEmployeeById(int Id)
{
List <EmployeeModel> Items = new List <EmployeeModel>();
DataTable dt = new DataTable();
SqlCommand cmd = new SqlCommand();
cmd.CommandType = CommandType.StoredProcedure;
cmd.CommandText = "GetEmployeeById";
cmd.Parameters.Add("@Id", SqlDbType.Int).Value = Id;
try
{
SystemAdminSettings.SetAndOpenConnection(cmd);
using (SqlDataAdapter sda = new SqlDataAdapter(cmd))
{
dt = new DataTable();
sda.Fill(dt);
if (dt.Rows.Count > 0)
{
foreach (DataRow row in dt.Rows)
{
EmployeeModel Item = new EmployeeModel();
Item.Id = Convert.ToInt32(row["Id"]);
Item.Name = row["Name"].ToString();
Item.Age = Convert.ToInt32(row["Age"]);
Item.Address = row["Address"].ToString();
Item.Department = row["Department"].ToString();
Item.PositionId = Convert.ToInt32(row["PositionId"]);
Items.Add(Item);
}
}
}
}
catch (Exception ex)
{
throw ex;
}
finally
{
cmd.Connection.Close();
cmd.Connection.Dispose();
}
return(Items);
}
public MapViewModel(SystemAdminSubMenu subMenu)
{
if (subMenu == null)
{
throw new ArgumentNullException(nameof(subMenu));
}
Title = subMenu.Name();
MapLocationData = subMenu.Data();
ISettingsProvider settingsProvider = (ISettingsProvider)Classes.PluginClass.GetServiceProvider.GetRequiredService <IPluginClassesService>();
SystemAdminSettings settings = settingsProvider.GetSettings <SystemAdminSettings>("SystemAdmin");
GoogleMapApiKey = settings.GoogleMapApiKey;
BreadCrumb = $"<ul><li><a href=\"/SystemAdmin/\">System Admin</a></li><li><a href=\"/SystemAdmin/Index/" +
$"{subMenu.ParentMenu.UniqueId}\">{subMenu.ParentMenu.Name()}</a></li><li>{Title}</li></ul>";
}
public TextExViewModel(SystemAdminSubMenu subMenu)
{
if (subMenu == null)
{
throw new ArgumentNullException(nameof(subMenu));
}
Title = subMenu.Name();
ISettingsProvider settingsProvider = (ISettingsProvider)Classes.PluginClass.GetServiceProvider.GetRequiredService <IPluginClassesService>();
SystemAdminSettings settings = settingsProvider.GetSettings <SystemAdminSettings>("SystemAdmin");
if (settings.DisableFormattedText)
{
Text = "Formatted Text is not enabed";
}
else
{
Text = subMenu.Data();
}
BreadCrumb = $"<ul><li><a href=\"/SystemAdmin/\">System Admin</a></li><li><a href=\"/SystemAdmin/Index/" +
$"{subMenu.ParentMenu.UniqueId}\">{subMenu.ParentMenu.Name()}</a></li><li>{Title}</li></ul>";
}
