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());
}