public HttpResponseMessage Delete(int id)
{
try
{
using (sampleEntities entities = new sampleEntities())
{
var entity = (entities.Employees.FirstOrDefault(e => e.ID == id));
if (entity != null)
{
entities.Employees.Remove(entity);
entities.SaveChanges();
var message = Request.CreateResponse(HttpStatusCode.OK, "deleted");
return(message);
}
else
{
var message = Request.CreateResponse(HttpStatusCode.NotFound, "cannot be found");
return(message);
}
}
}
catch (Exception ex)
{
return(Request.CreateErrorResponse(HttpStatusCode.BadRequest, ex.Message));
}
}
public HttpResponseMessage Get(string gender = "All")
{
String username = Thread.CurrentPrincipal.Identity.Name;
try {
using (sampleEntities entities = new sampleEntities())
{
switch (username.ToLower())
{
case "all":
return(Request.CreateResponse(HttpStatusCode.OK, entities.Employees.ToList()));
case "male":
return(Request.CreateResponse(HttpStatusCode.OK, entities.Employees.Where(e => e.Gender == "male").ToList()));
case "female":
return(Request.CreateResponse(HttpStatusCode.OK, entities.Employees.Where(e => e.Gender == "female").ToList()));
default:
return(Request.CreateResponse(HttpStatusCode.BadRequest));
}
}
}
catch (Exception ex)
{
return(Request.CreateErrorResponse(HttpStatusCode.BadRequest, ex.Message));
}
}
public IEnumerable <Employee> Get()
{
using (sampleEntities entities = new sampleEntities())
{
return(entities.Employees.ToList());
}
}
public HttpResponseMessage Put(int id, Employee employee)
{
try
{
using (sampleEntities entities = new sampleEntities())
{
var entity = entities.Employees.FirstOrDefault(e => e.ID == id);
if (entity != null)
{
entity.FirstName = employee.FirstName;
entity.LastName = employee.LastName;
entity.Gender = employee.Gender;
entity.Salary = employee.Salary;
entities.SaveChanges();
return(Request.CreateResponse(HttpStatusCode.OK, entity));
}
else
{
return(Request.CreateErrorResponse(HttpStatusCode.NotFound, "not found"));
}
}
}
catch (Exception ex)
{
return(Request.CreateErrorResponse(HttpStatusCode.BadRequest, ex.Message));
}
}
public HttpResponseMessage GetEmployees(string gender = "All")
{
using (sampleEntities entity = new sampleEntities())
{
return(Request.CreateResponse(HttpStatusCode.OK, entity.Employees.ToList()));
}
}
public JsonResult getAll()
{
using (sampleEntities dataContext = new sampleEntities())
{
var employeeList = dataContext.employee1.ToList();
return(Json(employeeList, JsonRequestBehavior.AllowGet));
}
}
private bool IsEmailExist(string emailID)
{
using (sampleEntities dc = new sampleEntities())
{
var v = dc.UserDetails.Where(a => a.EmailID == emailID).FirstOrDefault();
return(v != null);
}
}
public static bool Login(string UserName, string Password)
{
using (sampleEntities entities = new sampleEntities())
{
return(entities.Users.Any(u => u.Username.Equals(UserName, StringComparison.OrdinalIgnoreCase) &&
(u.Password.Equals(Password))));
}
}
public JsonResult getEmployeeByNo(string EmpNo)
{
using (sampleEntities dataContext = new sampleEntities())
{
int no = Convert.ToInt32(EmpNo);
var employeeList = dataContext.employee1.Find(no);
return(Json(employeeList, JsonRequestBehavior.AllowGet));
}
}
public static DataTable GetData(string tableName)
{
DataTable rows;
using (var db = new sampleEntities())
{
rows = db.Database.SqlQuery <DataTable>(string.Format("SELECT * FROM {0}", tableName)).FirstOrDefault();
}
return(rows);
}
public static List <string> GetTables()
{
List <string> tables;
using (var db = new sampleEntities())
{
tables = db.Database.SqlQuery <string>("SELECT TABLE_NAME FROM INFORMATION_SCHEMA.TABLES").ToList();
}
return(tables);
}
public static void Removefromdb(Employee Selectedemp)
{
if (Selectedemp == null)
{
return;
}
using (sampleEntities db = new sampleEntities())
{
db.employee.RemoveRange(db.employee.Where(c => c.emp_no == Selectedemp.Emp_no));
db.SaveChanges();
}
}
public static DataTable GetColumns(string tableName)
{
DataTable columns;
using (var db = new sampleEntities())
{
columns = db.Database.SqlQuery <DataTable>("SELECT * FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME=@tableName",
new SqlParameter("@tableName", tableName)).FirstOrDefault();
}
return(columns);
}
public HttpResponseMessage Get(int id)
{
using (sampleEntities entities = new sampleEntities())
{
var entity = entities.Employees.FirstOrDefault(e => e.ID == id);
if (entity != null)
{
return(Request.CreateResponse(HttpStatusCode.OK, entity));
}
else
{
return(Request.CreateErrorResponse(HttpStatusCode.NotFound, "not found"));
}
}
}
public static void Addtodb(Employee e)
{
/// <param name="Int2">Used to indicate status.</param>
using (sampleEntities db = new sampleEntities())
{
db.employee.Add(new employee
{
emp_no = e.Emp_no,
emp_fname = e.Emp_fname,
emp_lname = e.Emp_lname,
salary = e.Salary,
dept_no = e.Dept_no
});
db.SaveChanges();
}
}
public static ObservableCollection <Employee> EmpsConstruct()
{
using (var db = new sampleEntities())
{
var res = (db.employee.Select(c => new Employee
{
Emp_no = c.emp_no,
Emp_fname = c.emp_fname,
Emp_lname = c.emp_lname,
Salary = c.salary,
Dept_no = c.dept_no
})).ToList();
ObservableCollection <Employee> emptable = new ObservableCollection <Employee>(res);
return(emptable);
}
}
public string AddEmployee(employee1 Emp)
{
if (Emp != null)
{
using (sampleEntities dataContext = new sampleEntities())
{
dataContext.employee1.Add(Emp);
dataContext.SaveChanges();
return("Employee Updated");
}
}
else
{
return("Invalid Employee");
}
}
public HttpResponseMessage Post(Employee employee)
{
try
{
using (sampleEntities entities = new sampleEntities())
{
entities.Employees.Add(employee);
entities.SaveChanges();
}
var message = Request.CreateResponse(HttpStatusCode.Created, employee);
message.Headers.Location = new Uri(Request.RequestUri + "/" + employee.ID.ToString());
return(message);
}
catch (Exception ex)
{
return(Request.CreateErrorResponse(HttpStatusCode.BadRequest, ex.Message));
}
}
public HttpResponseMessage GetAllMembersByIdentifiers(string[] ids) {
// CHECK THE ARRAY NOT EMPTY
if(!ids.Any() || ids.All(xx=> string.isNullOrEmpty(xx)) return BadRequest();
using (sampleEntities entities = new sampleEntities()){
var numbers = entities.tblmembers
.Where(p => ids.Contains(p.identify) ).ToList();
if (numbers != null)
{
return Request.CreateResponse(HttpStatusCode.OK, numbers);
}
else
{
return Request.CreateErrorResponse(HttpStatusCode.NotFound, "Member with id: " + ids + " not found");
}
}
}
public string DeleteEmployee(employee1 Emp)
{
if (Emp != null)
{
using (sampleEntities dataContext = new sampleEntities())
{
int no = Convert.ToInt32(Emp.id);
var employeeList = dataContext.employee1.Where(x => x.id == no).FirstOrDefault();
dataContext.employee1.Remove(employeeList);
dataContext.SaveChanges();
return("Employee Deleted");
}
}
else
{
return("Invalid Employee");
}
}
public ActionResult Registration([Bind(Exclude = "IsEmailVerified,ActivationCode")] UserDetail user)
{
bool status = false;
string message = "";
//Model Validation
if (ModelState.IsValid)
{
//Email is already exists
var isExist = IsEmailExist(user.EmailID);
if (isExist)
{
ModelState.AddModelError("EmailExist", "Email already exist");
return(View(user));
}
//Generate Activation Code
user.ActivtionCode = Guid.NewGuid();
//password Hashing
user.Password = Crypto.Hash(user.Password);
user.ConfirmPassword = Crypto.Hash(user.ConfirmPassword);
user.IsEmailVerified = false;
//Save to database
using (sampleEntities dc = new sampleEntities())
{
dc.UserDetails.Add(user);
dc.SaveChanges();
//Send Email to User
/* SendVerificationLinkEmail(user.EmailID, user.ActivtionCode.ToString());*/
message = "Registration successfully done. ";
status = true;
}
}
else
{
message = "Invalid Request";
}
ViewBag.Message = message;
ViewBag.Status = status;
return(View(user));
}
public string UpdateEmployee(employee1 Emp)
{
if (Emp != null)
{
using (sampleEntities dataContext = new sampleEntities())
{
int no = Convert.ToInt32(Emp.id);
var employeeList = dataContext.employee1.Where(x => x.id == no).FirstOrDefault();
employeeList.name = Emp.name;
employeeList.mobile_no = Emp.mobile_no;
employeeList.email = Emp.email;
dataContext.SaveChanges();
return("Employee Updated");
}
}
else
{
return("Invalid Employee");
}
}
public ActionResult Login(UserLogin login, string ReturnURL = "")
{
string message = "";
using (sampleEntities se = new sampleEntities())
{
var v = se.UserDetails.Where(a => a.EmailID == login.EmailID).FirstOrDefault();
if (v != null)
{
if (string.Compare(Crypto.Hash(login.Password), v.Password) == 0)
{
int timeout = login.RememberMe ? 525600 : 20; // 525600 min = 1 year
var ticket = new FormsAuthenticationTicket(login.EmailID, login.RememberMe, timeout);
string encrypted = FormsAuthentication.Encrypt(ticket);
var cookie = new HttpCookie(FormsAuthentication.FormsCookieName, encrypted);
cookie.Expires = DateTime.Now.AddMinutes(timeout);
cookie.HttpOnly = true;
Response.Cookies.Add(cookie);
if (Url.IsLocalUrl(ReturnURL))
{
return(Redirect(ReturnURL));
}
else
{
return(RedirectToAction("Index", "Home"));
}
}
else
{
message = "Invalid Credential provided";
}
}
else
{
message = "Invalid credential provided";
}
}
ViewBag.Message = message;
return(View());
}//End of hhtppost login
public static int InsertData(string tableName, List <Data> row)
{
int returnValue;
using (var db = new sampleEntities())
{
var parameters = new List <SqlParameter>();
var columns = new List <string>();
var values = new List <string>();
foreach (var column in row)
{
columns.Add(column.Key);
values.Add("@" + column.Key);
parameters.Add(new SqlParameter("@" + column.Key, column.Value));
}
var sql = string.Format("INSERT INTO {0} ({1}) VALUES ({2})", tableName, string.Join(",", columns), string.Join(",", values));
returnValue = db.Database.ExecuteSqlCommand(sql, parameters);
}
return(returnValue);
}
public SupplierRepository(sampleEntities sampleEntities)
{
_sampleEntities = sampleEntities;
}
public SampleBaseUnitOfWork(sampleEntities context)
{
Context = context;
}
public RegionUnitOfWork(sampleEntities cartContext)
: base(cartContext)
{
}
