public DataTable GetEmployeeDetails(Employees obj)
{
QueryParameterCollection coll = new QueryParameterCollection();
coll.Add("email", obj.email, DbType.String);
return(DbActions.GetTable(coll, "vom_employee_getdetails", dp));
}
public DataTable ListEmployeeCount(Guid company_uuid)
{
QueryParameterCollection coll = new QueryParameterCollection();
coll.Add("@company_uuid", company_uuid, DbType.String);
return(DbActions.GetTable(coll, "vom_employee_count", dp));
}
public DataTable GetEmployee(Guid user_uuid)
{
QueryParameterCollection coll = new QueryParameterCollection();
coll.Add("@user_uuid", user_uuid, DbType.Guid);
return(DbActions.GetTable(coll, "vom_employee_get", dp));
}
public DataTable GetEmployeeUUID(Employees obj)
{
QueryParameterCollection coll = new QueryParameterCollection();
coll.Add("emp_name", obj.emp_name, DbType.String);
return(DbActions.GetTable(coll, "vom_employee_getuuid", dp));
}
//public DataTable EditEmployee(Employees obj)
//{
// QueryParameterCollection coll = new QueryParameterCollection();
// coll.Add("uuid", obj.uuid, DbType.Guid);
// coll.Add("emp_name", obj.emp_name, DbType.String);
// coll.Add("emp_salary", obj.emp_salary, DbType.Int64);
// coll.Add("email", obj.email, DbType.String);
// coll.Add("password", obj.password, DbType.String);
// coll.Add("emp_department", obj.emp_department, DbType.String);
// coll.Add("emp_phone_number", obj.emp_phone_number, DbType.Int64);
// coll.Add("emp_address", obj.emp_address, DbType.String);
// DataTable dt = DbActions.GetTable(coll, "vom_employee_editprofile", dp);
// return dt;
//}
public DataTable ListEmployee(Employees obj)
{
QueryParameterCollection coll = new QueryParameterCollection();
coll.Add("company_uuid", obj.company_uuid, DbType.String);
return(DbActions.GetTable(coll, "vom_employee_list", dp));
}
public ActionResult Delete(int id)
{
DbActions dbacc = new DbActions();
dbacc.Delete(id);
return(RedirectToAction("Index"));
}
public ActionResult Edit(int Id)
{
DbActions dbacc = new DbActions();
Post po = dbacc.getPost(Id);
return(View(po));
}
public AddRecipeViewModel(DbActions dbActions, ObservableCollection <Recipe> recipeItems)
{
this.dbActions = dbActions;
_recipeItems = recipeItems;
AddRecipeToDBCommand = new RelayCommand(AddRecipe);
}
public ViewResult RsvpForm(GuestResponseModel guestResponse)
{
string c = guestResponse.RSVpType;
if (c == ("none") | c == ("null"))
{
ViewBag.Error = "Please select your room type";
return(View());
}
else
{
ViewBag.Greeting = "Good Evening, " + guestResponse.Name +
"\n Your Reservation was completed We will call you to confirm. \nThank you";
int res = DbActions.CustomerRVSP(guestResponse);
if (res > 0)
{
ViewData["Message"] = "Reservation Successfully";
}
else
{
ViewData["Message"] = "Something Went Wrong";
}
return(View("Index"));
}
//TODO: SubscribeUser(model.Email);
// TODO: Email response to the party organizer
}
public DataTable GetAssignedTask(Guid emp_uuid)
{
QueryParameterCollection coll = new QueryParameterCollection();
coll.Add("@emp_uuid", emp_uuid, DbType.Guid);
return(DbActions.GetTable(coll, "vom_employee_getassignedtask", dp));
}
public DataTable GetCategoryUUID(Category obj)
{
QueryParameterCollection coll = new QueryParameterCollection();
coll.Add("category_name", obj.category_name, DbType.String);
return(DbActions.GetTable(coll, "vom_category_getuuid", dp));
}
public DataTable GetTask(Guid task_uuid)
{
QueryParameterCollection coll = new QueryParameterCollection();
coll.Add("@task_uuid", task_uuid, DbType.Guid);
return(DbActions.GetTable(coll, "vom_task_get", dp));
}
public DataTable ListCategory(Category obj)
{
QueryParameterCollection coll = new QueryParameterCollection();
coll.Add("company_uuid", obj.company_uuid, DbType.String);
return(DbActions.GetTable(coll, "vom_category_list", dp));
}
public DataTable GetCompanyUser(Guid user_uuid)
{
QueryParameterCollection coll = new QueryParameterCollection();
coll.Add("@user_uuid", user_uuid, DbType.Guid);
return(DbActions.GetTable(coll, "vom_company_getuser", dp));
}
public DataTable GetProjectUUID(Project obj)
{
QueryParameterCollection coll = new QueryParameterCollection();
coll.Add("project_name", obj.project_name, DbType.String);
return(DbActions.GetTable(coll, "vom_project_getuuid", dp));
}
public DataTable RemoveCategory(string uuid)
{
QueryParameterCollection coll = new QueryParameterCollection();
coll.Add("uuid", uuid, DbType.String);
return(DbActions.GetTable(coll, "vom_category_remove", dp));
}
public DataTable GetCategory(Guid category_uuid)
{
QueryParameterCollection coll = new QueryParameterCollection();
coll.Add("@category_uuid", category_uuid, DbType.Guid);
return(DbActions.GetTable(coll, "vom_category_get", dp));
}
public DataTable GetProject(Guid project_uuid)
{
QueryParameterCollection coll = new QueryParameterCollection();
coll.Add("@project_uuid", project_uuid, DbType.Guid);
return(DbActions.GetTable(coll, "vom_project_get", dp));
}
public MainWindow()
{
InitializeComponent();
DbActions dbActions = new DbActions();
DataContext = new MainWindowViewModel(dbActions);
}
private void btnAggiornaDB_Click(object sender, EventArgs e)
{
DbActions.CreateListCars();
timer1.Start();
lblEvent.Text = "Dati aggiornati!!";
}
public DataTable GetVerification(string verify_code)
{
QueryParameterCollection coll = new QueryParameterCollection();
coll.Add("@verify_code", verify_code, DbType.String);
return(DbActions.GetTable(coll, "vom_company_get_verification", dp));
}
public ActionResult <List <CClassTerm> > GetClassTermList(int teacherId)
{
if (DbActions.ValidateRequest(Request))
{
return(DbActions.GetClassTermsForRec(teacherId));
}
return(StatusCode(401));
}
public ActionResult <CTeacher> GetTeacher(int teacherId, int userId)
{
if (DbActions.ValidateRequest(Request))
{
return(DbActions.GetTeacher(teacherId, userId));
}
return(StatusCode(401));
}
public ActionResult <int> GetIdOfNearestSession(int teacherId)
{
if (DbActions.ValidateRequest(Request))
{
return(DbActions.GetClosestSessionId(teacherId));
}
return(StatusCode(401));
}
public ActionResult <CSession> GetAttendance(int sessionId)
{
if (DbActions.ValidateRequest(Request))
{
return(DbActions.GetSession(sessionId));
}
return(StatusCode(401));
}
private void FormMain_Load(object sender, EventArgs e)
{
if (DbActions.bindingListVeicoli.Count == 0)
{
DbActions.CreateListCars();
}
loadVehicles();
}
public DataTable GetTaskByFlag(string flag, Guid emp_uuid)
{
QueryParameterCollection coll = new QueryParameterCollection();
coll.Add("@emp_uuid", emp_uuid, DbType.Guid);
coll.Add("@flag", flag, DbType.String);
return(DbActions.GetTable(coll, "vom_task_getbyflag", dp));
}
public DataTable SearchTask(string search_text, Guid emp_uuid)
{
QueryParameterCollection coll = new QueryParameterCollection();
coll.Add("@search_text", search_text, DbType.String);
coll.Add("@emp_uuid", emp_uuid, DbType.Guid);
return(DbActions.GetTable(coll, "vom_task_search", dp));
}
public ActionResult <bool> CheckDuplicateEmail(String emailAddress)
{
if (DbActions.ValidateRequest(Request))
{
return(DbActions.CheckIfEmailIsDuplicate(emailAddress));
}
return(StatusCode(401));
}
public AddIngredientsViewModel(DbActions dbActions, ObservableCollection <Ingredient> ingredientItems)
{
this.dbActions = dbActions;
_ingredientItems = ingredientItems;
AddIngredientToDBCommand = new RelayCommand(AddIngredient);
}
