public static int addEmployeeDetails(employeeDetails emp)
{
try
{
int i = employeeProvider.addEmployeeDetails(emp);
return(i);
}
catch (Exception ex)
{
throw ex;
}
}
public static int addEmployeeDetails(employeeDetails emp)
{
try
{
List <KeyValuePair <string, object> > parameter = new List <KeyValuePair <string, object> >();
parameter.Add(new KeyValuePair <string, object>("@employeeId", emp.employeeId));
parameter.Add(new KeyValuePair <string, object>("@employeeName", emp.employeeName));
parameter.Add(new KeyValuePair <string, object>("@employeeAddress", emp.employeeAddress));
parameter.Add(new KeyValuePair <string, object>("@DOB", emp.DOB));
parameter.Add(new KeyValuePair <string, object>("@genderId", emp.genderId));
parameter.Add(new KeyValuePair <string, object>("@employeeMobileNo", emp.employeeMobileNo));
parameter.Add(new KeyValuePair <string, object>("@emailId", emp.emailId));
parameter.Add(new KeyValuePair <string, object>("@isCreditDebit", emp.CreditDebit));
parameter.Add(new KeyValuePair <string, object>("@openigBalanace", emp.openigBalanace));
parameter.Add(new KeyValuePair <string, object>("@orjId", emp.orjId));
if (emp.CreditDebit == "जमा रक्कम")
{
emp.crAmount = emp.openigBalanace;
emp.drAmount = 0;
}
if (emp.CreditDebit == "नावे रक्कम")
{
emp.drAmount = emp.openigBalanace;
emp.crAmount = 0;
}
parameter.Add(new KeyValuePair <string, object>("@crAmount", emp.crAmount));
parameter.Add(new KeyValuePair <string, object>("@drAmount", emp.drAmount));
parameter.Add(new KeyValuePair <string, object>("@addedBy", emp.addedBy));
parameter.Add(new KeyValuePair <string, object>("@addedOn", emp.addedOn));
SqlHandler sqlH = new SqlHandler();
int i = sqlH.ExecuteNonQueryI("[dbo].[Usp_addEmployeeDetails]", parameter);
return(i);
}
catch (Exception ae)
{
throw ae;
}
}
public IActionResult Deleteemployee(employeeDetails employeeDetails)
{
if (ModelState.IsValid)
{
try
{
var employeesList = employees.Getemployees().ToList();
int flag = 0;
foreach (var employeeListObject in employeesList)
{
if (employeeListObject.employeeName == employeeDetails.employeeName)
{
int index = employeesList.FindIndex(employees => employees.employeeName == employeeListObject.employeeName);
employees.Getemployees().Remove(employeesList[index]);
flag = 0;
break;
}
else
{
flag = 1;
}
}
if (flag == 1)
{
ViewBag.Message = "employee not Found";
}
else
{
return(RedirectToAction("Viewemployees", "employee"));
}
}
catch (Exception e)
{
ViewBag.Message = e.Message;
}
}
return(View());
}
public static List <employeeDetails> GetChartData()
{
DataTable dt = new DataTable();
using (SqlConnection con = new SqlConnection(@"Data Source=DS-8CG9074361\SQLEXPRESS;Initial Catalog=OTC;Integrated Security=True"))
{
con.Open();
SqlCommand cmd = new SqlCommand("SELECT Tags, COUNT(Id) AS Total FROM Infractio GROUP BY Tags", con);
SqlDataAdapter da = new SqlDataAdapter(cmd);
da.Fill(dt);
con.Close();
}
List <employeeDetails> dataList = new List <employeeDetails>();
foreach (DataRow dtrow in dt.Rows)
{
employeeDetails details = new employeeDetails();
details.EmployeeCity = dtrow[0].ToString();
details.Total = Convert.ToInt32(dtrow[1]);
dataList.Add(details);
}
return(dataList);
}
