public ActionResult Create([Bind(Exclude = "Id")] User userToAdd) { if (!ModelState.IsValid) { return(View()); } _db.Users.Add(userToAdd); _db.SaveChanges(); return(RedirectToAction("Index")); }
public ActionResult Create([Bind(Include = "Id,ItemName,StoreIDFk,Price")] StoreItem storeItem) { if (ModelState.IsValid) { db.StoreItems.Add(storeItem); db.SaveChanges(); return(RedirectToAction("Index")); } ViewBag.StoreIDFk = new SelectList(db.Stores, "Id", "StoreName", storeItem.StoreIDFk); return(View(storeItem)); }
public bool SaveUser(data user) { try { db.Users.Add(user); db.SaveChanges(); return(true); } catch (Exception ex) { return(false); } }
public ActionResult Edit([Bind(Include = "Id,FirstName,LastName,CompanyName,BirthDate,Gender,Position,Department,EmployedFrom,EmployedTo,LeaveReason,AddressLine1,AddressLine2,ZIP,Place,CountryCode")] UsersInfo userInfo) { if (ModelState.IsValid) { db.Entry(userInfo).State = EntityState.Modified; db.SaveChanges(); return(RedirectToAction("Index")); } return(View(userInfo)); }
public ActionResult Create([Bind(Include = "Id,UserName,Email,ContactNo,Password,CompanyName")] User user) { if (ModelState.IsValid) { db.Users.Add(user); db.SaveChanges(); MailHelper.GetMailHelper.Setup(); return(Redirect("Home/Index")); } return(View(user)); }
public bool AddUserTokenIntoDb(UserTokenMaster userTokenMaster) { var tokenMaster = context.UserTokenMasters.FirstOrDefault(x => x.UserName == userTokenMaster.UserName && x.UserPassword == userTokenMaster.UserPassword); if (tokenMaster != null) { context.UserTokenMasters.Remove(tokenMaster); } context.UserTokenMasters.Add(userTokenMaster); bool isAdded = context.SaveChanges() > 0; return(isAdded); }
public RedirectResult ScriptApply(string text) { StringBuilder sb = new StringBuilder(); sb.Append(text); int index = sb.ToString().IndexOf(_tableName); sb.Remove(index, _tableName.Length); sb.Insert(index, testDBName); text = sb.ToString(); db.Database.ExecuteSqlCommand("TRUNCATE TABLE " + testDBName); db.Database.ExecuteSqlCommand(text); db.SaveChanges(); return(Redirect("ListOfUsers")); }
public ActionResult Registration(UserCredential obj) { if (ModelState.IsValid) { try { UsersDBEntities db = new UsersDBEntities(); db.UserCredentials.Add(obj); db.SaveChanges(); } catch (Exception err) { ViewBag.Message = "The email address is already been taken."; return(View(obj)); } } return(View()); }
public ActionResult Import(HttpPostedFileBase postedFile) { if (postedFile != null) { try { string fileExtension = Path.GetExtension(postedFile.FileName); //Validate uploaded file and return error. if (fileExtension != ".xls" && fileExtension != ".xlsx") { ViewBag.Message = "Please select the excel file with .xls or .xlsx extension"; return(View()); } string folderPath = Server.MapPath("~/UploadedFiles/"); //Check Directory exists else create one if (!Directory.Exists(folderPath)) { Directory.CreateDirectory(folderPath); } //Save file to folder var filePath = folderPath + Path.GetFileName(postedFile.FileName); postedFile.SaveAs(filePath); //Get file extension string excelConString = ""; //Get connection string using extension switch (fileExtension) { //If uploaded file is Excel 1997-2007. case ".xls": excelConString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source={0};Extended Properties='Excel 8.0;HDR=YES'"; break; //If uploaded file is Excel 2007 and above case ".xlsx": excelConString = "Provider=Microsoft.ACE.OLEDB.12.0;Data Source={0};Extended Properties='Excel 8.0;HDR=YES'"; break; } //Read data from first sheet of excel into datatable DataTable dt = new DataTable(); excelConString = string.Format(excelConString, filePath); using (OleDbConnection excelOledbConnection = new OleDbConnection(excelConString)) { using (OleDbCommand excelDbCommand = new OleDbCommand()) { using (OleDbDataAdapter excelDataAdapter = new OleDbDataAdapter()) { excelDbCommand.Connection = excelOledbConnection; excelOledbConnection.Open(); //Get schema from excel sheet DataTable excelSchema = GetSchemaFromExcel(excelOledbConnection); //Get sheet name string sheetName = excelSchema.Rows[0]["TABLE_NAME"].ToString(); excelOledbConnection.Close(); //Read Data from First Sheet. excelOledbConnection.Open(); excelDbCommand.CommandText = "SELECT * From [" + sheetName + "]"; excelDataAdapter.SelectCommand = excelDbCommand; //Fill datatable from adapter excelDataAdapter.Fill(dt); excelOledbConnection.Close(); } } } //Insert records to Employee table. using (var context = new UsersDBEntities()); { //Loop through datatable and add employee data to employee table. foreach (DataRow row in dt.Rows) { db.StoreItems.Add(GetItem(row)); } db.SaveChanges(); } ViewBag.Message = "Data Imported Successfully."; } catch (Exception ex) { ViewBag.Message = ex.Message; } } else { ViewBag.Message = "Please select the file first to upload."; } return(View()); }