public void DeleteEmployee(int id)
{
EmpDetails e = _context.EmpDetails.Find(id);
_context.Remove(e);
_context.SaveChanges();
}
public ActionResult PersonalDetails(EmpDetails empDetails)
{
SqlHelper obj = new SqlHelper();
connection();
//db.EmployeeDetails.Add(empDetails);
//db.SaveChanges();
//string date = DateTime.Now.ToString();
//string date = DateTime.Now.ToString();
//DateTime dateTime = Convert.ToDateTime(date);
string entryDate = DateTime.Now.ToString("MM/dd/yyyy hh:mm:ss");
string dob = empDetails.dob.ToString("MM/dd/yyyy hh:mm:ss");
SqlCommand sqlcmd = new SqlCommand("Insert into emp_details (emp_code, emp_name, emp_fname, dob, gender, religion, category, subcategory, pan, aadhar, entry_date, emp_height, emp_idy, emp_martial, cat_sel, office_Code, blood_Group, voterCard_No) values('"
+ empDetails.emp_code + "','" + empDetails.emp_name + "','" + empDetails.emp_fname + "','" + dob + "','" + empDetails.gender + "','" + empDetails.religion + "'," + "'" + empDetails.category + "','"
+ empDetails.subcategoryName + "','" + empDetails.pan + "','" + empDetails.aadhar.ToString() + "','" + entryDate + "','" + empDetails.emp_height + "','" + empDetails.emp_idy + "','" + empDetails.emp_martial +
"','" + empDetails.cat_sel + "','" + empDetails.office_code + "','" + empDetails.blood_Group + "','" + empDetails.voterCard_No + "')", con);
sqlcmd.CommandType = CommandType.Text;
con.Open();
sqlcmd.ExecuteNonQuery();
Session["empCode"] = empDetails.emp_code;
con.Close();
//lstemp = GetDatas();
//return View("Index", lstemp);
//return View("EmpHomeDistrict","Employee",new {id=TempData["mydata"]});
// RedirectToAction("); return RedirectToAction("Details","Student",new { id = StudentId });
return(RedirectToAction("EmpHomeDistrict"));
}
public EmpDetails GetEmpByEmail(string email)
{
try
{
using (IDbConnection con = Connection)
{
con.Open();
var param = new DynamicParameters();
param.Add("@EmpEMail", email);
//return con.Query<UserDetails>("dbo.usp_EmployeeDetails", param, null, true, 0, CommandType.StoredProcedure).FirstOrDefault();
EmpDetails empDetails = new EmpDetails();
using (var multi = con.QueryMultiple("dbo.usp_EmployeeDetails", param, commandType: CommandType.StoredProcedure))
{
//empDetails = multi.Read<EmpDetails>().First();
//empDetails.Roles = multi.Read<EmpRoles>().ToList();
empDetails = multi.Read <EmpDetails>().SingleOrDefault();
if (empDetails != null)
{
empDetails.Roles = multi.Read <EmpRoles>().ToList();
}
}
return(empDetails);
}
}
catch (Exception)
{
throw;
}
}
public async Task Put(int id, [FromBody] EmpDetails value)
{
var entry = await _db.Entries.FindAsync(id);
entry = value;
await _db.SaveChangesAsync();
}
public HttpResponseMessage CheckEmpExists(string EmpMobile)
{
EmpDetails resEmpDet = null;
try
{
DBConnection dbConn = new DBConnection();
resEmpDet = dbConn.GetUserDetails(EmpMobile);
if (resEmpDet.IsAuthorized)
{
return(new HttpResponseMessage()
{
Content = new StringContent(JsonConvert.SerializeObject("Success"), Encoding.UTF8, "application/json")
});
}
else
{
return(new HttpResponseMessage()
{
Content = new StringContent(JsonConvert.SerializeObject("Error"), Encoding.UTF8, "application/json")
});
}
}
catch
{
throw new HttpResponseException(Request.CreateResponse(HttpStatusCode.NotFound));
}
}
public async Task <string> Post([FromBody] EmpDetails value)
{
await _db.Entries.AddAsync(value);
await _db.SaveChangesAsync();
return(value.EmployeeId + " - " + value.Name + " : " + value.Surname);
}
public async Task <IActionResult> Edit(EmpDetails emp)
{
if (ModelState.IsValid)
{
_db.Update(emp);
await _db.SaveChangesAsync();
return(RedirectToAction("Index"));
}
return(View(emp));
}
public ActionResult Index(EmpDetails model)
{
if (!string.IsNullOrWhiteSpace(model.Name))
{
ViewBag.WordsNo = model.Name + " " + NumberToWords.ConvertAmount(model.Number)?.ToUpper();
}
else
{
ViewBag.WordsNo = "";
}
return(View(model));
}
public ActionResult Edit(EmpDetails empDetail)
{
var empDetails = employeeContext.EmpDetailss.Find(empDetail.EmployeeId);
empDetails.Name = empDetail.Name;
empDetails.MobileNo = empDetail.MobileNo;
empDetails.Email = empDetail.Email;
empDetails.Address = empDetail.Address;
employeeContext.SaveChanges();
return(RedirectToAction("EmpDetailsList"));
}
public IActionResult AddEmployee(EmpDetails emp)
{
try
{
_repo.AddEmployee(emp);
return(Ok());
}
catch (Exception e)
{
return(Ok(e.InnerException.Message));
}
}
protected void AddUserInfo(object sender, EventArgs e)
{
try
{
DBConnection dbConn = new DBConnection();
EmpDetails empDetails = new EmpDetails();
empDetails.EmpFirstName = empFirstName.Text;
empDetails.EmpLastName = empLastName.Text;
empDetails.EmpEmail = empEmail.Text;
empDetails.EmpMobile = Session["mobileNo"].ToString();
//if (!resEmpDet.IsAuthorized)
//{
try
{
HttpClient client = new HttpClient();
client.BaseAddress = new Uri("http://localhost:52668//Employee");
client.DefaultRequestHeaders.Accept.Add(new MediaTypeWithQualityHeaderValue("application/pdf"));
string reqUrl = "api/AddEmployee";
var param = Newtonsoft.Json.JsonConvert.SerializeObject(empDetails);
HttpContent contentPost = new StringContent(param, Encoding.UTF8, "application/json");
HttpResponseMessage response = client.PostAsync(reqUrl, contentPost).Result;
if (response.IsSuccessStatusCode)
{
EmpDetails newEmpDet = response.Content.ReadAsAsync <EmpDetails>().Result;
if (newEmpDet.messageType == "success")
{
successMessage.InnerText = newEmpDet.message;
empDet.Visible = false;
}
else
{
errorMessage.InnerText = newEmpDet.message;
empDet.Visible = true;
}
}
}
catch (Exception ex)
{
errorMessage.InnerText = ex.Message;
Console.WriteLine(ex.Message);
}
//}
}
catch (Exception ex)
{
Console.WriteLine(ex.Message);
}
}
public EmpDetails Add(EmpDetails emp)
{
var Result = _db.Add(emp);
_db.SaveChanges();
if (Result != null)
{
return(emp);
}
else
{
return(null);
}
}
public EmpDetails GetUserDetails(string EmpMobile)
{
EmpDetails empDet = new EmpDetails();
SqlCommand cmd = null;
try
{
cmd = new SqlCommand("GetUserInfo", conn);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add(new SqlParameter("@EmpMobile", SqlDbType.VarChar)).Value = EmpMobile;
if (conn.State == ConnectionState.Closed)
{
conn.Open();
}
SqlDataReader reader = cmd.ExecuteReader();
if (reader.HasRows)
{
while (reader.Read())
{
empDet.IsAuthorized = true;
}
}
else
{
empDet.IsAuthorized = false;
}
}
catch (Exception ex)
{
empDet.IsAuthorized = false;
Console.WriteLine(ex.Message);
}
finally
{
cmd.Dispose();
if (conn.State == ConnectionState.Open)
{
conn.Close();
}
}
return(empDet);
}
public IActionResult Add(EmpDetails emp)
{
try
{
EmpDetails data = _IUser.Add(emp);
if (!data.Equals(null))
{
return(Ok(new { success = true, Message = "Added successfully", Data = emp }));
}
else
{
return(Ok(new { success = false, Message = "failed to add", Data = emp }));
}
}
catch (Exception ex)
{
return(BadRequest(new { success = false, Message = ex.Message }));
}
}
public EmpResponse GetEmpByEmail(string email)
{
EmpResponse response = new EmpResponse();
try
{
EmpDetails empDetails = this._employeeDetailServices.GetEmpByEmail(email);
if (empDetails != null)
{
response.Result = true;
response.Data = empDetails;
}
else
{
response.Result = false;
}
}
catch (Exception)
{
throw;
}
return(response);
}
public IHttpActionResult AddEmployee(EmpDetails empDetails)
{
EmpDetails resEmpDet = empDetails;
try
{
DBConnection dbConn = new DBConnection();
string status = dbConn.AddEmployeeDetails(empDetails);
if (status == "Successfully Uploaded")
{
resEmpDet.messageType = "success";
resEmpDet.message = "Successfully added user's info";
return(Ok(resEmpDet));
}
}
catch (Exception ex)
{
resEmpDet = new EmpDetails();
resEmpDet.messageType = "error";
resEmpDet.message = ex.Message;
return(Ok(resEmpDet));
}
return(Ok(resEmpDet));
}
public string AddEmployeeDetails(EmpDetails empDetails)
{
string status = "";
SqlCommand cmd = null;
try
{
cmd = new SqlCommand("AddEmployeeDet", conn);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add("@FirstName", SqlDbType.VarChar).Value = empDetails.EmpFirstName;
cmd.Parameters.Add("@LastName", SqlDbType.VarChar).Value = empDetails.EmpLastName;
cmd.Parameters.Add("@Mobile", SqlDbType.VarChar).Value = empDetails.EmpMobile;
cmd.Parameters.Add("@Email", SqlDbType.VarChar).Value = empDetails.EmpEmail;
cmd.Parameters.Add("@returnVal", SqlDbType.VarChar, 500).Direction = ParameterDirection.Output;
if (conn.State == ConnectionState.Closed)
{
conn.Open();
}
cmd.ExecuteNonQuery();
status = cmd.Parameters["@returnVal"].Value.ToString();
}
catch (Exception ex)
{
Console.WriteLine(ex.Message);
}
finally
{
cmd.Dispose();
if (conn.State == ConnectionState.Open)
{
conn.Close();
}
}
return(status);
}
public ActionResult AddEmployee(EmpDetails empDetails)
{
employeeContext.EmpDetailss.Add(empDetails);
employeeContext.SaveChanges();
return(RedirectToAction("EmpDetailsList"));
}
public void UpdateEmployee(EmpDetails emp)
{
_context.Update(emp);
}
public void UpdateEmployee(EmpDetails emp)
{
_repo.UpdateEmployee(emp);
}
public void AddEmployee(EmpDetails emp)
{
_context.EmpDetails.Add(emp);
_context.SaveChanges();
}
static void Main(string[] args)
{
var datacontext = new EmpDetails();
var emp = new BaseRepository <EmpDetails>(data);
}