public ActionResult Create([Bind(Include = "CodeP,NomP")] Projet projet)
{
if (ModelState.IsValid)
{
db.Projets.Add(projet);
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(projet));
}
public ActionResult Create([Bind(Include = "NumDep,NomDep,Lieu")] Departement departement)
{
if (ModelState.IsValid)
{
db.Departements.Add(departement);
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(departement));
}
public ActionResult Create([Bind(Include = "UserID,UserName,UserEmail,UserPassowrd,UserAddress,UserBalance,UserType")] UserInfo userInfo)
{
if (ModelState.IsValid)
{
db.UserInfoes.Add(userInfo);
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(userInfo));
}
public ActionResult Edit([Bind(Include = "Cedula,SiglaExam,Descripcion")] Aplica_Transacciones aplica_Transacciones)
{
if (ModelState.IsValid)
{
db.Entry(aplica_Transacciones).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
ViewBag.Cedula = new SelectList(db.Profesor_Transacciones, "Cedula", "Cedula", aplica_Transacciones.Cedula);
ViewBag.SiglaExam = new SelectList(db.Examen_Transacciones, "SiglaExam", "SiglaExam", aplica_Transacciones.SiglaExam);
return(View(aplica_Transacciones));
}
public ActionResult Create([Bind(Include = "Matr,NomE,Post,DateEmb,Sup,Salaire,Comm,NumDep")] Employe employe)
{
if (ModelState.IsValid)
{
db.Employes.Add(employe);
db.SaveChanges();
return(RedirectToAction("Index"));
}
ViewBag.NumDep = new SelectList(db.Departements, "NumDep", "NomDep", employe.NumDep);
return(View(employe));
}
public ActionResult Create([Bind(Include = "Matr,CodeP,Fonction")] Participation participation)
{
if (ModelState.IsValid)
{
db.Participations.Add(participation);
db.SaveChanges();
return(RedirectToAction("Index"));
}
ViewBag.Matr = new SelectList(db.Employes, "Matr", "NomE", participation.Matr);
ViewBag.CodeP = new SelectList(db.Projets, "CodeP", "NomP", participation.CodeP);
return(View(participation));
}
public void Delete(object obj)
{
if (obj is Author)
{
_context.Author.Remove((Author)obj);
}
if (obj is Post)
{
_context.Post.Remove((Post)obj);
}
_context.SaveChanges();
}
public void RegisterUser(RegisterUserRequest req)
{
string userId = UserIdFactory.GetUserId();
db.User.Add(new User()
{
Id = userId,
LoginId = req.LoginId,
Name = req.Name,
MailAddress = req.MailAddress
});
db.SaveChanges();
}
private void Delete_client()
{
if (MessageBox.Show("Вы дейтсвительно хотите удалить запись?", "Удаление",
MessageBoxButtons.YesNo, MessageBoxIcon.Asterisk) == DialogResult.Yes)
{
using (DataBaseEntities db = new DataBaseEntities())
{
int ID = (int)dgv_client[0, dgv_client.SelectedRows[0].Index].Value;
var client = db.Client.FirstOrDefault(c => c.ID == ID);
if (client.VisitInfo.Count > 0)
{
MessageBox.Show("Невозможно удалить запись, так как есть данные о посещении.");
}
else
{
db.Client.Remove(client);
if (client.TagOfClient.Select(t => t.Tag).ToList().Count > 0)
{
foreach (var tag in client.TagOfClient.Select(t => t.Tag).ToList())
{
db.Tag.Remove(tag);
}
}
db.SaveChanges();
UpdateData();
}
}
}
}
void IDeviceService.Delete(int DeviceId)
{
using (var context = new DataBaseEntities(DBManager.EntityConnectionString))
{
Device oldDevice = context.Devices.Where(i => i.DeviceID == DeviceId).First();
context.DeleteObject(oldDevice);
context.SaveChanges();
}
}
void IDeviceService.Update(Device Device)
{
using (var context = new DataBaseEntities(DBManager.EntityConnectionString))
{
Device oldDevice = context.Devices.Where(i => i.DeviceID == Device.DeviceID).First();
oldDevice = Device;
context.SaveChanges();
}
}
int IDeviceService.Add(Device Device)
{
using (var context = new DataBaseEntities(DBManager.EntityConnectionString))
{
context.Devices.AddObject(Device);
context.SaveChanges();
return(Device.DeviceID);
}
}
void IInvoiceService.Update(Invoice Invoice)
{
using (var context = new DataBaseEntities(DBManager.EntityConnectionString))
{
Invoice oldInvoice = context.Invoices.Where(i => i.InvoiceID == Invoice.InvoiceID).First();
oldInvoice = Invoice;
context.SaveChanges();
}
}
void IOrderService.Delete(int OrderID)
{
using (var context = new DataBaseEntities(DBManager.EntityConnectionString))
{
Order oldOrder = context.Orders.Where(i => i.OrderID == OrderID).First();
context.DeleteObject(oldOrder);
context.SaveChanges();
}
}
int IProductService.Add(Product Product)
{
using (var context = new DataBaseEntities(DBManager.EntityConnectionString))
{
context.Products.AddObject(Product);
context.SaveChanges();
return(Product.ProductID);
}
}
int IOrderService.Add(Order Order)
{
using (var context = new DataBaseEntities(DBManager.EntityConnectionString))
{
context.Orders.AddObject(Order);
context.SaveChanges();
return(Order.OrderID);
}
}
void IProductService.Delete(int ProductID)
{
using (var context = new DataBaseEntities(DBManager.EntityConnectionString))
{
Product oldProduct = context.Products.Where(i => i.ProductID == ProductID).First();
context.DeleteObject(oldProduct);
context.SaveChanges();
}
}
void IOrderService.Update(Order Order)
{
using (var context = new DataBaseEntities(DBManager.EntityConnectionString))
{
Order oldOrder = context.Orders.Where(i => i.OrderID == Order.OrderID).First();
oldOrder = Order;
context.SaveChanges();
}
}
public void SaveText(RegisterTextRequest req)
{
var target = db.Text.FirstOrDefault(x => x.UserId == req.UserId);
target.Title = req.Title;
target.Description = req.Description;
target.Profile_1 = req.Profile_1;
db.SaveChanges();
}
public ActionResult Create([Bind(Include = "Code,ItemName,ItemDescription,ItemPrice,Department,logo")] Item item, HttpPostedFileBase imgFile)
{
string path = "";
if (imgFile.FileName.Length > 0)
{
path = "~/images/" + Path.GetFileName(imgFile.FileName);
imgFile.SaveAs(Server.MapPath(path));
}
item.logo = path;
if (ModelState.IsValid)
{
db.Items.Add(item);
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(item));
}
void IProductService.Update(Product Product)
{
using (var context = new DataBaseEntities(DBManager.EntityConnectionString))
{
Product oldProduct = context.Products.Where(i => i.ProductID == Product.ProductID).First();
oldProduct.isDiscontinued = Product.isDiscontinued;
oldProduct.ProductCode = Product.ProductCode;
oldProduct.ProductGroup = Product.ProductGroup;
oldProduct.ProductName = Product.ProductName;
oldProduct.ProductPrice = Product.ProductPrice;
context.SaveChanges();
}
}
void ICustomerService.Update(Customer Customer)
{
using (var context = new DataBaseEntities())
{
try
{
context.Customers.Attach(Customer);
context.ObjectStateManager.ChangeObjectState(Customer, EntityState.Modified);
context.SaveChanges();
}
catch (Exception)
{
throw new FaultException("Error updating customer id#" + Customer.CustomerID);
}
}
}
public async Task <IHttpActionResult> ProfilePortraitChange([FromBody] TD_Portrait model)
{
DataBaseEntities db = new DataBaseEntities();
var UserId = User.Identity.GetUserId();
var user = db.AspNetUsers.Single(u => u.Id == UserId);
user.Portrait = model.image;
db.SaveChanges();
user = db.AspNetUsers.Single(u => u.Id == UserId);
return(Json(new
{
Code = 10000,
Detail = new
{
Portrait = user.Portrait
}
}));
}
int ICustomerService.Add(Customer Customer)
{
using (var context = new DataBaseEntities())
{
try
{
context.Customers.AddObject(Customer);
context.ObjectStateManager.ChangeObjectState(Customer, EntityState.Added);
context.SaveChanges();
}
catch (Exception)
{
throw new FaultException("Could not create Customer");
}
return(Customer.CustomerID);
}
}
void ICustomerService.Delete(int CustomerID)
{
using (var context = new DataBaseEntities())
{
try
{
Customer cust = context.Customers
.Where(c => c.CustomerID == CustomerID)
.FirstOrDefault();
context.DeleteObject(cust);
context.SaveChanges();
}
catch (Exception)
{
throw new FaultException("Error deleting customer id#" + CustomerID);
}
}
}
private void deleteTag_Click(object sender, EventArgs e)
{
if (listTags.SelectedItems.Count > 0)
{
using (DataBaseEntities db = new DataBaseEntities())
{
Tag tag = (Tag)listTags.SelectedItems[0].Tag;
TagOfClient tagOfClient = db.TagOfClient.FirstOrDefault(t => t.TagID == tag.ID && t.ClientID == client.ID);
if (db.TagOfClient.ToList().Exists(t => t.ID == tagOfClient.ID &&
t.ClientID == tagOfClient.ClientID))
{
listTags.Items.Remove(listTags.SelectedItems[0]);
db.TagOfClient.Remove(tagOfClient);
}
db.SaveChanges();
}
}
}
private void Save()
{
var results = new List <ValidationResult>();
var context = new ValidationContext(bindingSourceClient[0]);
if (!Validator.TryValidateObject(client, context, results, true))
{
foreach (var error in results)
{
MessageBox.Show(error.ErrorMessage, "Ошибка", MessageBoxButtons.OK, MessageBoxIcon.Error);
return;
}
}
if (MessageBox.Show("Сохранить?", "Сохранение", MessageBoxButtons.YesNo, MessageBoxIcon.Question) == DialogResult.Yes)
{
using (DataBaseEntities db = new DataBaseEntities())
{
if (!db.Client.ToList().Exists(c => c.ID == client.ID))
{
client.RegistrationDate = DateTime.Now;
db.Client.Add((ModelDB.Client)bindingSourceClient[0]);
}
var tagOfClients = db.TagOfClient.ToList();
foreach (ListViewItem item in listTags.Items)
{
Tag tag = (Tag)item.Tag;
TagOfClient tagOfClient = new TagOfClient {
ClientID = client.ID, TagID = tag.ID
};
if (tagOfClients.Exists(t => t.TagID == tagOfClient.TagID && t.ClientID == client.ID) == false)
{
db.Tag.Add(tag);
db.TagOfClient.Add(tagOfClient);
}
}
db.SaveChanges();
}
}
}
/// <summary>
/// 判断该电话号码和验证码是否合法
/// </summary>
/// <param name="Mobile">手机号码</param>
/// <param name="Code">验证码</param>
/// <param name="NeedDelete">是否需要删除</param>
/// <returns></returns>
public static bool VerifyMobileCode(string Mobile, int Code, bool NeedDelete)
{
if (UtilityHelper.ConstVar.testAccount.Contains(Mobile))
{
return(true);
}
DataBaseEntities db = new DataBaseEntities();
DateTime dt = UtilityHelper.getNow().AddMinutes(-5); //延迟5分钟
if (db.cm_SMS_Verify.Any(u => (u.Mobile == Mobile && u.Code == Code && u.CreateDate > dt)))
{
if (NeedDelete)
{
var obj = db.cm_SMS_Verify.Where(u => u.Mobile == Mobile);
db.cm_SMS_Verify.RemoveRange(obj);
db.SaveChanges();
}
return(true);
}
else
{
return(false);
}
}
public ActionResult Register(RegisterViewModel model)
{
_currentUser = (User)Session["CurrentUser"];
if (_currentUser != null)
{
return(RedirectToAction("Index"));
}
if (!ModelState.IsValid)
{
return(View(model));
}
_currentUser = new User();
_currentUser.Username = model.Username;
_currentUser.Password = model.Password;
_currentUser.FirstName = model.FirstName;
_currentUser.LastName = model.LastName;
_currentUser.RegisterDate = System.DateTime.Now;
db.Users.Add(_currentUser);
db.SaveChanges();
Session.Add("CurrentUser", _currentUser);
return(RedirectToAction("Index"));
}
public async Task <IHttpActionResult> VcodeSendSMS(string m)
{
if (UtilityHelper.ConstVar.testAccount.Any(u => u == m))
{
return(Json(new
{
Code = 10000,
Detail = new { }
}));
}
if (!UtilityHelper.IsMobilePhone(m))
{
return(Json(new
{
Code = 1,
Message = "手机格式不正确"
}));
}
Random ran = new Random();
int RandKey = ran.Next(1000, 9999);
try
{
string mobile = m,
message = "验证码：" + RandKey.ToString() + " ，两分钟内有效【活动邮】",
username = ConfigurationManager.AppSettings["SMSUsername"],
password = ConfigurationManager.AppSettings["SMSKey"],
url = ConfigurationManager.AppSettings["SMSUrl"];
byte[] byteArray = Encoding.UTF8.GetBytes("mobile=" + mobile + "&message=" + message);
HttpWebRequest webRequest = (HttpWebRequest)WebRequest.Create(new Uri(url));
string auth = "Basic " + Convert.ToBase64String(System.Text.Encoding.Default.GetBytes(username + ":" + password));
webRequest.Headers.Add("Authorization", auth);
webRequest.Method = "POST";
webRequest.ContentType = "application/x-www-form-urlencoded";
webRequest.ContentLength = byteArray.Length;
Stream newStream = webRequest.GetRequestStream();
newStream.Write(byteArray, 0, byteArray.Length);
newStream.Close();
HttpWebResponse response = (HttpWebResponse)webRequest.GetResponse();
StreamReader php = new StreamReader(response.GetResponseStream(), Encoding.Default);
string Message = php.ReadToEnd();
}
catch
{
return(Json(new
{
Code = 1,
Message = "验证码服务器有误"
}));
}
DataBaseEntities db = new DataBaseEntities();
var verify = new cm_SMS_Verify
{
Id = Guid.NewGuid().ToString(),
Code = RandKey,
CreateDate = DateTime.Now,
Mobile = m
};
db.cm_SMS_Verify.Add(verify);
db.SaveChanges();
return(Json(new
{
Code = 10000,
Detail = new
{
}
}));
}