public static int CreateRoommate(string firstName, string lastName, decimal payment)
{
RoommateModel data = new RoommateModel
{
FirstName = firstName,
LastName = lastName,
MonthlyPayment = (decimal)CalculatePayment()
};
//string sql = @"insert into dbo.Roommates (FirstName, LastName)
// Values(@FirstName, @LastName);";
string sql = $"sp_AddRoommate '{data.FirstName}','{data.LastName}', '{data.MonthlyPayment}'";
return(SqlDataAccess.SaveData <RoommateModel>(sql, data));
}
public static int UpdateManuscript(int id, string type, string value)
{
var sql = @"UPDATE library_item " +
$"SET {type} = @Value " +
"WHERE id = @Id " +
"AND Category = 'manuscript'";
var data = new DynamicUpdateModel
{
Id = id,
Type = type,
Value = value
};
return(SqlDataAccess.SaveData(sql, data));
}
public static int PutInCompany(string id, string businessName, string phoneNumber, string description, int zipcode)
{
Company data = new Company
{
AccountId = id,
BusinessName = businessName,
PhoneNumber = phoneNumber,
Description = description,
Zipcode = zipcode
};
string sql = @"INSERT INTO dbo.Companies (AccountId, BusinessName, PhoneNumber, Description, Zipcode)
VALUES (@AccountId, @BusinessName, @PhoneNumber, @Description, @Zipcode);";
return(SqlDataAccess.SaveData(sql, data)); //goes to the Sql DataAccess class
}
public static int CreateOrder(int id, string name, string description, string ingredients, float price)
{
OrderModel data = new OrderModel
{
Id = id,
Name = name,
Description = description,
Ingredients = ingredients,
Price = price
};
string sql = @"insert into dbo.OrderQueue (Id, Name, Description, Ingredients, Price)
values (@Id, @Name, @Description, @Ingredients, @Price);";
return(SqlDataAccess.SaveData(sql, data));
}
public static int CreateOrganization(int organizationId, string organizationName, string organizationEmail)
{
OrganizationModel data = new OrganizationModel
{
OrganizationId = organizationId,
OrganizationName = organizationName,
OrganizationEmail = organizationEmail
};
// @ tells it it's a variable. it's teh data you're paassign with the statment.
// e.g @ModuleId's value is going to be stored in moduleId
string sql = @"insert into dbo.Organization (OrganizationId, OrganizationName, OrganizationEmail)
values (@OrganizationId, @OrganizationName, @OrganizationEmail);";
return(SqlDataAccess.SaveData(sql, data));
}
public static int WriteAuthenticationToken(int userId, string token)
{
var date = DateTime.Now.AddHours(24);
const string sql = @"INSERT INTO authentication_token(UserId, Token, ExpireDateTime) VALUES(@UserId, @Token, @ExpireDateTime);";
var data = new TokenModel
{
Token = token,
UserId = userId,
ExpireDateTime = date.ToString("yyyy-MM-dd hh:mm:ss")
};
SqlDataAccess.SaveData(sql, data);
return(UserProcessor.GetUserRole(token));
}
public static int CreateItem(int drinkId, string name, string description, string ingredients, float price)
{
ItemModel data = new ItemModel
{
DrinkId = drinkId,
Name = name,
Description = description,
Ingredients = ingredients,
Price = price
};
string sql = @"insert into dbo.MenuTable (DrinkId, Name, Description, Ingredients, Price)
values (@DrinkId, @Name, @Description, @Ingredients, @Price);";
return(SqlDataAccess.SaveData(sql, data));
}
public static int CreateBill(string billName, decimal amount, DateTime duedate)
{
BillModel data = new BillModel
{
BillName = billName,
AmountDue = amount,
DueDate = duedate,
IsCurrent = true
};
string sql = $"sp_AddNewBill '{data.BillName}', '{data.AmountDue}', '{data.DueDate}'";
UpdatePayments(data.AmountDue);
//TODO (CAN I REMOVE THIS YET)impliment this AssignedBillProcessor.AssignBill(data, roommate);
return(SqlDataAccess.SaveData(sql, data));
}
public static int EditEmployee(int employeeId, string firstName, string lastName, string emailAddress)
{
EmployeeModel data = new EmployeeModel
{
EmployeeId = employeeId,
FirstName = firstName,
LastName = lastName,
EmailAddress = emailAddress
};
string sql = @"UPDATE dbo.Employees
SET FirstName = @FirstName, LastName = @LastName, EmailAddress = @EmailAddress
WHERE EmployeeId = @EmployeeId";
return(SqlDataAccess.SaveData(sql, data));
}
public static int RegisterUser(UserModel userModel)
{
var sql = @"INSERT INTO user(UserName, Email, Pass) " +
$"VALUES(@Username, @Email, @Pass)";
var model = new UserModel
{
UserName = userModel.UserName,
Email = userModel.Email,
Pass = Hashing.HashPassword(userModel.Pass),
UserType = userModel.UserType
};
return(SqlDataAccess.SaveData(sql, model));
}
public static int CreateEmployee(int employeeId, string firstName, string lastName,
string emailAddress)
{
EmployeeModel data = new EmployeeModel
{
EmployeeId = employeeId,
FirstName = firstName,
LastName = lastName,
EmailAddress = emailAddress
};
string sql = @"insert into dbo.Employee (EmployeeId, FirstName, LastName, EmailAddress)
values (@EmployeeId, @FirstName, @LastName, @EmailAddress);";
return(SqlDataAccess.SaveData(sql, data));
}
public static int CreateEmployee(int employeeId, string firstName, string lastName, string emailId, string password)
{
Employee data = new Employee
{
EmployeeId = employeeId,
FirstName = firstName,
LastName = lastName,
Email_Id = emailId,
Password = password
};
string sql = @"insert into dbo.Employee(EmployeeId, FirstName, LastName, Email_Id, Password)
values (@EmployeeId, @FirstName, @LastName, @Email_Id, @Password);";
return(SqlDataAccess.SaveData(sql, data));
}
public static int CreateEmployee(string firstName, string lastName, DateTime?dob, string email, string address,
string phoneNumber)
{
EmployeeModel data = new EmployeeModel
{
FirstName = firstName,
LastName = lastName,
DateofBirth = dob,
EmailAddress = email,
Address = address,
PhoneNumber = phoneNumber
};
string sql = @"insert into dbo.Employee(FirstName, LastName, DateofBirth, EmailAddress, Address, PhoneNumber )
values (@FirstName,@LastName,@DateofBirth,@EmailAddress,@Address,@PhoneNumber);";
return(SqlDataAccess.SaveData(sql, data));
}
public static int CreateEmployee(int employeeId, string firstName, string lastName, string emailAddress)
{
EmployeeModel data = new EmployeeModel
{
EmployeeId = employeeId,
FirstName = firstName,
LastName = lastName,
EmailAddress = emailAddress
};
string sql = @"INSERT INTO [dbo].[Employee]
([EmployeeId], [FirstName], [LastName], [EmailAddress])
VALUES
(@EmployeeId, @FirstName, @LastName, @EmailAddress)";
return(SqlDataAccess.SaveData(sql, data));
}
//method to create Users
public static int CreateUsers(string userName, string firstName, string lastName)
{
//organize the data that will be added
UserModel data = new UserModel
{
UserName = userName,
FirstName = firstName,
LastName = lastName
};
//create an sql query to create the new User
string sql = @"insert into dbo.[User] (UserName, FirstName, LastName)
values (@UserName, @FirstName, @LastName)";
//call the sqlDataAccess to create the new User
return(SqlDataAccess.SaveData(sql, data));
}
public static int updateOrder(int orderId, int partId, string projectName, DateTime lastMaterialDate, DateTime shipDate, int quantity, string status, int priority)
{
orderModel data = new orderModel
{
orderId = orderId,
partId = partId,
projectName = projectName,
lastMaterialDate = lastMaterialDate,
shipDate = shipDate,
quantity = quantity,
status = status,
priority = priority
};
string sql = @"update [Order] set partId=@partId,projectName=@projectName,lastMaterialDate=@lastMaterialDate,shipDate=@shipDate,quantity=@quantity, status=@status,priority=@priority where orderId=@orderId ;";
return(SqlDataAccess.SaveData(sql, data));
}
public static int CreateOrder(int orderId, int partId, string projectName, DateTime lastMaterialDate,
DateTime shipDate, int quantity)
{
orderModel data = new orderModel
{
orderId = orderId,
partId = partId,
projectName = projectName,
lastMaterialDate = lastMaterialDate,
shipDate = shipDate,
quantity = quantity
};
string sql = @"insert into [Order] (orderId,partId,projectName,lastMaterialDate,shipDate,quantity)
values (@orderId,@partId,@projectName,CONVERT(datetime,@lastMaterialDate,104),CONVERT(datetime,@shipDate,104),@quantity);";
return(SqlDataAccess.SaveData(sql, data));
}
public static int UpdateElementCard(string elementType, string elementName, int inSan, int deSan, string isForce, string isInter, string elementDes)
{
ElementModels data = new ElementModels
{
ElementType = elementType,
InSan = inSan,
DeSan = deSan,
IsForce = isForce,
IsInter = isInter,
ElementDes = elementDes,
};
string sql = @"UPDATE dbo.CardTBL SET ElementType = @ElementType,InSan=@InSan,DeSan=@DeSan,IsForce=@IsForce,IsInter=@IsInter,ElementDes=@ElementDes WHERE ElementName= '" + elementName + "'";
return(SqlDataAccess.SaveData(sql, data));
}
public static int CreateUser(string firstName, string lastName, string emailAddress, string password, DateTime birthday, string gender)
{
UserModels data = new UserModels
{
FirstName = firstName,
LastName = lastName,
EmailAddress = emailAddress,
Password = password,
BirthDay = birthday,
Gender = gender
};
string sql = @"INSERT INTO dbo.[User] (FirstName, LastName, EmailAddress, Password, BirthDay, Gender)
VALUES (@FirstName, @LastName, @EmailAddress, @Password, @BirthDay, @Gender)";
return(SqlDataAccess.SaveData(sql, data));
}
public static int CreateComenzi(string town, string address, int number, string phoneNumber, DateTime date, int customerId)
{
OrderModel data = new OrderModel
{
Town = town,
Address = address,
Number = number,
PhoneNumber = phoneNumber,
Date = date,
CustomerId = customerId
};
string sql = @"insert into dbo.Comanda (Town, Address, Number, PhoneNumber, Date, CustomerId)
values (@Town, @Address, @Number, @PhoneNumber, @Date, @CustomerId);";
return(SqlDataAccess.SaveData(sql, data));
}
public static int AddProduct(string name, float calories, float proteins,
float carbohydrates, float fats)
{
ProductsModel data = new ProductsModel
{
Name = name,
Calories = calories,
Proteins = proteins,
Carbohydrates = carbohydrates,
Fats = fats
};
string sql = @"INSERT INTO Products (name, calories, proteins, carbohydrates, fats)
values(@Name, @Calories, @Proteins, @Carbohydrates, @Fats);";
return(SqlDataAccess.SaveData(sql, data));
}
public static int CreateCourse(int courseId, string courseName,
string courseQualification, int courseResult, int courseLength)
{
CourseModel data = new CourseModel
{
CourseId = courseId,
CourseName = courseName,
CourseQualification = courseQualification,
CourseResult = courseResult,
CourseLength = courseLength
};
string sql = @"insert into dbo.Course (CourseId, CourseName, CourseQualification, CourseResult, CourseLength)
values (@CourseId, @CourseName, @CourseQualification, @CourseResult, @CourseLength);";
return(SqlDataAccess.SaveData(sql, data));
}
public static int CreateEmployee(int employeeId, string role, string lastName, string firstName, string city, string country, string email)
{
EmployeeModel data = new EmployeeModel
{
EmployeeId = employeeId,
Role = role,
LastName = lastName,
FirstName = firstName,
City = city,
Country = country,
Email = email
};
string sql = @"insert into dbo.Employee (EmployeeId, Role, LastName, FirstName, City, Country, Email) values (@EmployeeId, @Role, @LastName, @FirstName, @City, @Country, @Email);";
return(SqlDataAccess.SaveData(sql, data));
}
//create new Store
public static int CreateStore(int storeId, string storeName, string storeAddress, string phoneNumber,
string hoursOfOperation)
{
StoreModel data = new StoreModel
{
StoreId = storeId,
StoreName = storeName,
StoreAddress = storeAddress,
PhoneNumber = phoneNumber,
HoursOfOperation = hoursOfOperation
};
string sql = @"Insert into dbo.[Store]( StoreName, StoreAddress, PhoneNumber, HoursOfOperation)
Values ( @StoreName, @StoreAddress, @PhoneNumber, @HoursOfOperation);";
return(SqlDataAccess.SaveData(sql, data));
}
public static int SaveEditedProduct(int?id, string productName, int categoryId, string description, int price, string urlLink)
{
ProductModel data = new ProductModel
{
ProductId = id,
ProductName = productName,
CategoryId = categoryId,
Description = description,
ProductPrice = price,
UrlLink = urlLink
};
string sql = @"update dbo.Products set ProductName=@ProductName,CategoryId=@CategoryId, Description=@Description,
ProductPrice=@ProductPrice, UrlLink=@UrlLink where Id_Product=@ProductId ";
return(SqlDataAccess.SaveData(sql, data));
}
public static int SetBook(ItemModel itemModel)
{
var sql = $@"INSERT INTO library_item(Title, Description, Author, PublishYear, Category, Access) " +
"VALUES(@Title, @Description, @Author, @PublishYear, @Category, @Access)";
var model = new ItemModel
{
Title = itemModel.Title,
Description = itemModel.Description,
Author = itemModel.Author,
PublishYear = itemModel.PublishYear,
Category = itemModel.Category,
Access = itemModel.Access
};
return(SqlDataAccess.SaveData(sql, model));
}
public static int CreateReview(string Category, string BookName, string ReviewType, string BookSubject, string BookAnalysis, string AuthorName, string OtherBooks)
{
ReviewModel data = new ReviewModel
{
Category = Category,
BookName = BookName,
ReviewType = ReviewType,
BookSubject = BookSubject,
BookAnalysis = BookAnalysis,
AuthorName = AuthorName,
OtherBooks = OtherBooks
};
string sql = @"INSERT INTO dbo.Review(Category, BookName, ReviewType, BookSubject, BookAnalysis, AuthorName, OtherBooks)
VALUES(@Category, @BookName, @ReviewType, @BookSubject, @BookAnalysis, @AuthorName, @OtherBooks);" ;
return(SqlDataAccess.SaveData(sql, data));
}
public static int CreateUpload(string creatorName, string taskName, string fileName, string mimeType,
string base64String, DateTime dateCreated)
{
UploadModel data = new UploadModel
{
CreatorName = creatorName,
TaskName = taskName,
FileName = fileName,
MimeType = mimeType,
Base64String = base64String,
DateCreated = dateCreated
};
string sql = @"insert into dbo.FileTable(CreatorName, TaskName, FileName, MimeType, Base64String, DateCreated)
values (@CreatorName, @TaskName, @FileName, @MimeType, @Base64String, @DateCreated);";
return(SqlDataAccess.SaveData(sql, data));
}
public static int CreateAuction(string title, string description, string startTime, string endTime, int totalProducts, string status, string mainPic)
{
AuctionEventModel data = new AuctionEventModel
{
auctionTitle = title,
auctionDescription = description,
StartTime = startTime,
EndTime = endTime,
totalProduct = totalProducts,
auctionStatus = status,
auctionMainPicture = mainPic
};
string sql = @"INSERT INTO dbo.AuctionEvent (AuctionTitle, Description, StartTime, EndTime, TotalProducts, AuctionStatus, AuctionMainPicture)
VALUES(@title, @description, @startTime, @endTime, @totalProducts, @status, @mainPic)";
return(SqlDataAccess.SaveData(sql, data));
}
public static int CreateUsers(int user_ID, string userName, string firstName,
string lastName, string middleName, string emailAddress, string userPassword)
{
UsersModel data = new UsersModel
{
User_ID = user_ID,
UserName = userName,
FirstName = firstName,
LastName = lastName,
MiddleName = middleName,
EmailAddress = emailAddress,
UserPassword = userPassword
};
string sql = @"insert into dbo.UserInfo (User_ID, UserName, FirstName, LastName, MiddleName, EmailAddress, UserPassword) values (@User_ID, @UserName, @FirstName, @LastName, @MiddleName, @EmailAddress, @UserPassword);";
return(SqlDataAccess.SaveData(sql, data));
}
