public IActionResult Create(Contact contact)
{
if (ModelState.IsValid)
{
_context.Contacts.Add(contact);
_context.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(contact));
}
public ActionResult Create([Bind(Include = "PersonId,LastName,FirstName,BirthDate")] Person person)
{
if (ModelState.IsValid)
{
db.Persons.Add(person);
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(person));
}
public ActionResult Create([Bind(Include = "ArticleId,ColumnId,Hits,Title,Keywords,Author,Pictures,Content,Authorized,PublishTime,ReviseTime")] Article article)
{
if (ModelState.IsValid)
{
db.Articles.Add(article);
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(article));
}
public ActionResult Create([Bind(Include = "Id,CodeName,Name")] Permission permission)
{
if (ModelState.IsValid)
{
db.Permissions.Add(permission);
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(permission));
}
public ActionResult Create([Bind(Include = "Id,Name")] Role role)// tao moi 1 role
{
if (ModelState.IsValid)
{
db.Roles.Add(role);
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(role));
}
public ActionResult Create([Bind(Include = "Id,Name,UserId")] Product product)
{
if (ModelState.IsValid)
{
db.Products.Add(product);
db.SaveChanges();
return(RedirectToAction("Index"));
}
ViewBag.UserId = new SelectList(db.Users, "Id", "Username", product.UserId);
return(View(product));
}
public ActionResult Create([Bind(Include = "Id,Username,Password,Email,SecurityPassword,ActivationCode,TimeGetCode,CountLogin,TimeCountLogin,ConfirmActivity")] User user)
{
if (ModelState.IsValid)
{
db.Users.Add(user);
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(user));
}
public ActionResult Register([Bind(Include = "Username,Password,RPassword,Email")] User account)
{
try
{
//var vali = valid.ValidUserName(account.Username);
//if (vali != "")
// ModelState.AddModelError("UserName", vali);
//vali = valid.ValidEmail(account.Email);
//if (vali != "")
// ModelState.AddModelError("Email", vali);
//vali = valid.ValidatePassword(account.Password);
//if (vali != "")
// ModelState.AddModelError("Password", vali);
//vali = valid.ValidatePassword(account.RPassword);
//if (vali != "")
// ModelState.AddModelError("RPassword", vali);
if (account.Password != null && !account.Password.Equals(account.RPassword))
{
ModelState.AddModelError("RPassword", "Xác nhận mật khẩu không đúng.");
}
if (ModelState.IsValid)
{
//Gui mail xac nhan email dang ky
Guid activationCode = Guid.NewGuid();
if (email.SendMailAccount(account.Username, account.Email, activationCode.ToString()))
{
account.ActivationCode = activationCode.ToString();
account.TimeGetCode = DateTime.UtcNow;
account.Password = encode.EncodeMd(account.Password);
db.Users.Add(account);
db.SaveChanges();
account.Password = null;
account.RPassword = null;
ViewBag.Message = "Đăng ký thành công. Mã xác nhận đã được gửi đến email của bạn.";
}
}
}
catch (DbEntityValidationException dbEx)
{
foreach (var validationErrors in dbEx.EntityValidationErrors)
{
foreach (var validationError in validationErrors.ValidationErrors)
{
System.Console.WriteLine("Property: {0} Error: {1}", validationError.PropertyName, validationError.ErrorMessage);
}
}
}
return(View(account));
}
private void btnSave_Click(object sender, EventArgs e)
{
try
{
expenseItem.ExpenseCategoryId = (int)cmbCategory.SelectedValue;
expenseItem.Name = txtName.Text;
if (txtCodeManual.Text.Trim() != String.Empty)
{
expenseItem.Code = txtCodeManual.Text;
}
else
{
expenseItem.Code = txtCode.Text;
}
expenseItem.Description = txtDescription.Text;
db.ExpenseItems.Add(expenseItem);
int count = db.SaveChanges();
if (count > 0)
{
MessageBox.Show("Successfully Item Saved");
}
else
{
MessageBox.Show("Failed Insertion");
}
ClearAllTextBox();
LoadDataGridViewItem();
}
catch (Exception ex)
{
MessageBox.Show(ex.Message + "\n" + "Please fill text box!");
}
}
public IActionResult SignUp(UserDTO user)
{
//check if username exists
if (_ctx.Credentials.Find(user.Username) != null)
{
return(new BadRequestObjectResult("Username already exists"));
}
//check if email formatted right
if (!ValidMail(user.Email))
{
return(new BadRequestObjectResult("That's not an email"));
}
//check if mail exists
if (_ctx.Users.SingleOrDefault(u => u.Email == user.Email) != null)
{
return(new BadRequestObjectResult("Email already exists"));
}
var newUser = CreateUser(user);
_ctx.Users.Add(newUser);
_ctx.SaveChanges();
var jwtToken = GenerateAccessToken(user.Email, user.Username);
Response.Headers.Add("Authentication", jwtToken);
user.Password = "";
return(Ok(user));
}
private void EditManager()
{
using (ManagerContext context = new ManagerContext())
{
//фиксируем менеджера
context.Managers.Attach(manager);
manager.Credential = credential;
manager.Person.Info = info;
if (radioButtonMan.Checked)
{
manager.Person.Sex = true;
}
else
{
manager.Person.Sex = false;
}
manager.Person.ICNumber = textBoxICNumber.Text.Trim();
manager.Person.ICGettingPlace = textBoxICGettingPlace.Text.Trim();
manager.Person.PassportGettingPlace = textBoxPassportGettingPlace.Text.Trim();
manager.Person.PassportNumber = textBoxPassportNumber.Text.Trim();
manager.Person.IIN = textBoxIIN.Text.Trim();
manager.Person.LastName = textBoxLastName.Text.Trim();
manager.Person.SecondName = textBoxSecondName.Text.Trim();
manager.Person.FirstName = textBoxFirstName.Text.Trim();
//manager info date
manager.Person.Birthday = dateTimePickerBirthDay.Value;
manager.Person.ICGettingDay = dateTimePickerICGettingDate.Value;
manager.Person.PassportGettingDay = dateTimePickerPassportGettingDate.Value;
//сохраняем данные
context.Entry(manager).State = System.Data.Entity.EntityState.Modified;
context.SaveChanges();
}
}
private void AddManager()
{
using (ManagerContext context = new ManagerContext())
{
manager.Credential = credential;
manager.Person.Info = info;
if (radioButtonMan.Checked)
{
manager.Person.Sex = true;
}
else
{
manager.Person.Sex = false;
}
manager.Person.ICNumber = textBoxICNumber.Text.Trim();
manager.Person.ICGettingPlace = textBoxICGettingPlace.Text.Trim();
manager.Person.PassportGettingPlace = textBoxPassportGettingPlace.Text.Trim();
manager.Person.PassportNumber = textBoxPassportNumber.Text.Trim();
manager.Person.IIN = textBoxIIN.Text.Trim();
manager.Person.LastName = textBoxLastName.Text.Trim();
manager.Person.SecondName = textBoxSecondName.Text.Trim();
manager.Person.FirstName = textBoxFirstName.Text.Trim();
//manager info date
manager.Person.Birthday = dateTimePickerBirthDay.Value;
manager.Person.ICGettingDay = dateTimePickerICGettingDate.Value;
manager.Person.PassportGettingDay = dateTimePickerPassportGettingDate.Value;
//сохраняем данные
context.Managers.Add(manager);
context.SaveChanges();
}
}
private void dgvPurchaseReport_CellClick(object sender, DataGridViewCellEventArgs e)
{
if (dgvPurchaseReport.CurrentCell.ColumnIndex.Equals(7))
{
if (dgvPurchaseReport.CurrentCell != null && dgvPurchaseReport.CurrentCell.Value != null)
{
if (dgvPurchaseReport.CurrentRow != null)
{
int id = (int)dgvPurchaseReport.CurrentRow.Cells[0].Value;
using (ManagerContext db = new ManagerContext())
{
var purchaseId = db.Purchases.FirstOrDefault(c => c.Id == id);;
if (purchaseId != null)
{
purchaseId.IsDelete = true;
int count = db.SaveChanges();
if (count > 0)
{
MessageBox.Show("Successfully Deleted");
}
else
{
MessageBox.Show("Operation Failed");
}
}
}
}
}
}
}
private void AddMITCast(ManagerContext aContext)
{
List <Person> vPersonList = new List <Person>
{
new Person {
FirstName = "Cary", LastName = "Elwes", BirthDate = new DateTime(1962, 10, 26)
},
new Person {
FirstName = "Richard", LastName = "Lewis", BirthDate = new DateTime(1947, 6, 29)
},
new Person {
FirstName = "Roger", LastName = "Rees", BirthDate = new DateTime(1944, 5, 5)
},
new Person {
FirstName = "Amy", LastName = "Yasbeck", BirthDate = new DateTime(1962, 9, 12)
},
new Person {
FirstName = "Mark", LastName = "Blankfield", BirthDate = new DateTime(1950, 5, 8)
},
new Person {
FirstName = "Dave", LastName = "Chappelle", BirthDate = new DateTime(1973, 8, 24)
},
new Person {
FirstName = "Megan", LastName = "Cavanagh", BirthDate = new DateTime(1960, 11, 8)
},
new Person {
FirstName = "Eric", LastName = "Kramer", BirthDate = new DateTime(1962, 3, 26)
},
new Person {
FirstName = "Matthew", LastName = "Porrette", BirthDate = new DateTime(1965, 5, 29)
},
new Person {
FirstName = "Tracey", LastName = "Ullman", BirthDate = new DateTime(1959, 12, 30)
},
};
List <Employee> vEmployeeList = new List <Employee>();
foreach (Person vPerson in vPersonList)
{
aContext.Persons.AddOrUpdate(
person => person.LastName,
vPerson
);
vEmployeeList.Add(
new Employee {
EmployeeNum = (vPersonList.IndexOf(vPerson) + 1).ToString(), EmployedDate = new DateTime(1993, 1, 1), TerminatedDate = new DateTime(1999, 1, 1), Person = vPerson
}
);
}
foreach (Employee vEmployee in vEmployeeList)
{
aContext.Employees.AddOrUpdate(
emp => emp.PersonId,
vEmployee
);
}
aContext.SaveChanges();
}
private void btnSave_Click(object sender, EventArgs e)
{
try
{
DialogResult result = MessageBox.Show("Do you want to Save", "Confirmation",
MessageBoxButtons.YesNo, MessageBoxIcon.Information);
if (result == DialogResult.Yes)
{
expense.ExpenseList = expenseLists;
expense.InvoiceNo = SetInvioceNo();
expense.Remarks = txtRemark.Text;
expense.TotalAmount = Convert.ToDecimal(txtTotalShow.Text);
expense.OrganizationId = (int)cmbOrganization.SelectedValue;
expense.OutletId = (int)cmbOutlet.SelectedValue;
expense.EmployeeId = (int)cmbEmployee.SelectedValue;
expense.Date = dateTimePicker.Value;
db.Expenses.Add(expense);
int count = db.SaveChanges();
MessageBox.Show(count > 0 ? "Expense save successfully!" : "Save failed");
}
else if (result == DialogResult.No)
{
MessageBox.Show("You have clicked Cancel Button");
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
ClearTextBoxAll();
}
private void SaveStock()
{
try
{
using (ManagerContext db = new ManagerContext())
{
foreach (Stock itemId in listofstock)
{
List <TempPurchase> listofTemp = db.TempPurchases.Where(a => a.ItemId == itemId.ItemId).ToList();
decimal avg = listofTemp.Sum(a => a.TotalPrice) / listofTemp.Sum(a => a.Quantity);
var isAvailableItem = db.Stocks.FirstOrDefault(a => a.ItemId == itemId.ItemId);
var quantity = itemId.AvailableQuantity;
if (isAvailableItem != null)
{
isAvailableItem.AvailableQuantity += itemId.AvailableQuantity;
isAvailableItem.AveragePrice = avg;
}
else
{
db.Stocks.AddRange(listofstock);
}
}
db.SaveChanges();
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}
private void btnSave_Click_1(object sender, EventArgs e)
{
try
{
if (!isUpdateMode)
{
GetTextBoxValue();
db.CustomerAndSuppliers.Add(customerAndSupplier);
int count = db.SaveChanges();
if (count > 0)
{
MessageBox.Show("Successfully Saved");
}
else
{
MessageBox.Show("Save failed");
}
}
if (isUpdateMode)
{
GetTextBoxValue();
db.CustomerAndSuppliers.Attach(customerAndSupplier);
db.Entry(customerAndSupplier).State = System.Data.Entity.EntityState.Modified;
int count = db.SaveChanges();
if (count > 0)
{
MessageBox.Show("Successfully Updated");
}
else
{
MessageBox.Show("Update failed");
}
}
LoadDataGridView();
ClearAllTextBox();
}
catch (Exception ex)
{
MessageBox.Show(ex.Message + "\n" + "Please fill text box!");
}
}
public IActionResult Create(WebManageUsers user)
{
user.AddTime = DateTime.Now;
user.Mobile = string.Empty;
_context.WebManageUsers.Add(user);
_context.SaveChanges();
return(RedirectToAction("Index"));
}
public ActionResult DeleteConfirmed(int id)
{
Employee employee = db.Employees.Find(id);
db.Employees.Remove(employee);
db.SaveChanges();
return(RedirectToAction("Index"));
}
/* Добавление студента с первоначальными данными */
public void AddPotentialStudent(Student student)
{
using (var db = new ManagerContext())
{
db.Students.Add(student);
db.SaveChanges();
}
}
public static void AddEmployee(
ManagerContext aDbContext,
Employee aNewEmployee
)
{
aDbContext.Employees.Add(aNewEmployee);
aDbContext.SaveChanges();
}
public static Employee EditEmployee(
ManagerContext aDbContext,
Employee aNewEmployee
)
{
aDbContext.Entry(aNewEmployee).State = EntityState.Modified;
aDbContext.SaveChanges();
return(aNewEmployee);
}
private void AddTNGCast(ManagerContext aContext)
{
List <Person> vPersonList = new List <Person>
{
new Person {
FirstName = "Patrick", LastName = "Stewart", BirthDate = new DateTime(1940, 7, 13)
},
new Person {
FirstName = "Jonathan", LastName = "Frakes", BirthDate = new DateTime(1952, 8, 19)
},
new Person {
FirstName = "LeVar", LastName = "Burton", BirthDate = new DateTime(1957, 2, 16)
},
new Person {
FirstName = "Marina", LastName = "Sirtis", BirthDate = new DateTime(1955, 3, 29)
},
new Person {
FirstName = "Brent", LastName = "Spiner", BirthDate = new DateTime(1949, 2, 2)
},
new Person {
FirstName = "Michael", LastName = "Dorn", BirthDate = new DateTime(1952, 12, 9)
},
new Person {
FirstName = "Gates", LastName = "McFadden", BirthDate = new DateTime(1949, 3, 2)
},
new Person {
FirstName = "Majel", LastName = "Barrett", BirthDate = new DateTime(1949, 3, 2)
},
};
List <Employee> vEmployeeList = new List <Employee>();
foreach (Person vPerson in vPersonList)
{
aContext.Persons.AddOrUpdate(
person => person.LastName,
vPerson
);
vEmployeeList.Add(
new Employee {
EmployeeNum = (vPersonList.IndexOf(vPerson) + 1).ToString(), EmployedDate = new DateTime(1987, 1, 1), TerminatedDate = new DateTime(1994, 1, 1), Person = vPerson
}
);
}
foreach (Employee vEmployee in vEmployeeList)
{
aContext.Employees.AddOrUpdate(
emp => emp.PersonId,
vEmployee
);
}
aContext.SaveChanges();
}
/// <summary>
/// Saves the changes made to the database.
/// </summary>
/// <returns>An integer that represents whether the changes saved successfully.</returns>
public int Complete()
{
try
{
return(context.SaveChanges());
}
catch (Exception ex)
{
throw ex;
}
}
private void AddDS9Cast(ManagerContext aContext)
{
List <Person> vPersonList = new List <Person>
{
new Person {
FirstName = "Avery", LastName = "Brooks", BirthDate = new DateTime(1948, 10, 2)
},
new Person {
FirstName = "Rene", LastName = "Auberjonois", BirthDate = new DateTime(1940, 6, 1)
},
new Person {
FirstName = "Cirroc", LastName = "Lofton", BirthDate = new DateTime(1978, 8, 7)
},
new Person {
FirstName = "Alexander", LastName = "Siddig", BirthDate = new DateTime(1965, 11, 21)
},
new Person {
FirstName = "Colm", LastName = "Meaney", BirthDate = new DateTime(1953, 5, 30)
},
new Person {
FirstName = "Nana", LastName = "Visitor", BirthDate = new DateTime(1957, 7, 26)
},
new Person {
FirstName = "Armin", LastName = "Shimerman", BirthDate = new DateTime(1949, 11, 5)
},
new Person {
FirstName = "Terry", LastName = "Farrell", BirthDate = new DateTime(1963, 11, 19)
},
};
List <Employee> vEmployeeList = new List <Employee>();
foreach (Person vPerson in vPersonList)
{
aContext.Persons.AddOrUpdate(
person => person.LastName,
vPerson
);
vEmployeeList.Add(
new Employee {
EmployeeNum = (vPersonList.IndexOf(vPerson) + 1).ToString(), EmployedDate = new DateTime(1993, 1, 1), TerminatedDate = new DateTime(1999, 1, 1), Person = vPerson
}
);
}
foreach (Employee vEmployee in vEmployeeList)
{
aContext.Employees.AddOrUpdate(
emp => emp.PersonId,
vEmployee
);
}
aContext.SaveChanges();
}
private void AddOriginalSeriesCast(ManagerContext aContext)
{
List <Person> vPersonList = new List <Person>
{
new Person {
FirstName = "Leonard", LastName = "Nimoy", BirthDate = new DateTime(1932, 4, 26)
},
new Person {
FirstName = "William", LastName = "Shatner", BirthDate = new DateTime(1931, 3, 22)
},
new Person {
FirstName = "DeForest", LastName = "Kelley", BirthDate = new DateTime(1920, 1, 20)
},
new Person {
FirstName = "Nichelle", LastName = "Nichols", BirthDate = new DateTime(1932, 12, 28)
},
new Person {
FirstName = "James", LastName = "Doohan", BirthDate = new DateTime(1920, 3, 3)
},
new Person {
FirstName = "George", LastName = "Takei", BirthDate = new DateTime(1937, 4, 20)
},
new Person {
FirstName = "Walter", LastName = "Koenig", BirthDate = new DateTime(1936, 9, 14)
},
};
List <Employee> vEmployeeList = new List <Employee>();
foreach (Person vPerson in vPersonList)
{
aContext.Persons.AddOrUpdate(
person => person.LastName,
vPerson
);
vEmployeeList.Add(
new Employee {
EmployeeNum = (vPersonList.IndexOf(vPerson) + 1).ToString(), EmployedDate = new DateTime(1966, 1, 1), TerminatedDate = new DateTime(1969, 1, 1), Person = vPerson
}
);
}
foreach (Employee vEmployee in vEmployeeList)
{
aContext.Employees.AddOrUpdate(
emp => emp.PersonId,
vEmployee
);
}
aContext.SaveChanges();
}
protected override void OnStartup(StartupEventArgs e)
{
try
{
if (!_context.Passwords.Any())
{
_context.Passwords.Add(new Models.RootPassword
{
Password = DbManager.Properties.Settings.Default.defaultPassword
});
_context.SaveChanges();
}
}
catch (System.Exception)
{
OnStartup(e);
}
}
private void UpdateStock()
{
try
{
Stock stock = new Stock();
stock.ItemId = (int)listOfSalesItem[0].ItemId;
stock.AvailableQuantity = listOfSalesItem[0].Quantity;
using (ManagerContext db = new ManagerContext())
{
db.Stocks.Attach(stock);
db.Entry(stock).Property(X => X.AvailableQuantity).IsModified = true;
db.SaveChanges();
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}
public IActionResult CreateTask(int id, SharedTasks task)
{
string username = HttpContext.User.Identity.Name;
var group = _ctx.Groups
.Include(g => g.SharedTasks)
.FirstOrDefault(g => g.GroupId == id);
if (group == null || group.AdminUsername != username)
{
return(Unauthorized());
}
task.GroupId = id;
_ctx.SharedTasks.Add(task);
_ctx.SaveChanges();
return(Ok(task));
}
public IActionResult DeleteMember(int groupId, string memberUsername)
{
string username = HttpContext.User.Identity.Name;
if (!AdminIsValid(username, groupId))
{
return(Unauthorized());
}
var member = _ctx.Memberships.Find(memberUsername, groupId);
if (member == null)
{
return(NotFound());
}
_ctx.Memberships.Remove(member);
_ctx.SaveChanges();
return(NoContent());
}