private OuputModel DataAccessLogic(InputModel inputModel)
{
OuputModel ouputModel = null;
DepatmentModel depatmentModel = null;
using (SqlConnection sqlCon = new SqlConnection("Server=awsdatabase-1.cklc9dvnkg9x.ap-south-1.rds.amazonaws.com,1433;User Id=MainUser;pwd=V4wearefour;Database=Assignment"))
{
sqlCon.Open();
using (SqlCommand commad = new SqlCommand("usp_getDept", sqlCon))
{
commad.CommandType = System.Data.CommandType.StoredProcedure;
using (IDataReader reader = commad.ExecuteReader())
{
ouputModel = new OuputModel();
ouputModel.DepatmentList = new List <DepatmentModel>();
while (reader.Read())
{
depatmentModel = new DepatmentModel()
{
pkdeptid = reader.IsDBNull(reader.GetOrdinal("pkdeptid")) ? -1 : Convert.ToInt32(reader[reader.GetOrdinal("pkdeptid")]),
deptname = reader.IsDBNull(reader.GetOrdinal("deptname")) ? "" : reader[reader.GetOrdinal("deptname")].ToString(),
Isactive = reader.IsDBNull(reader.GetOrdinal("Isactive")) ? false : Convert.ToBoolean(reader[reader.GetOrdinal("Isactive")]),
};
ouputModel.DepatmentList.Add(depatmentModel);
}
}
}
}
return(ouputModel);
}
private OuputModel DataAccessLogic(InputModel inputModel)
{
OuputModel ouputModel = null;
using (SqlConnection sqlCon = new SqlConnection("Server=awsdatabase-1.cklc9dvnkg9x.ap-south-1.rds.amazonaws.com,1433;User Id=MainUser;pwd=V4wearefour;Database=Assignment"))
{
sqlCon.Open();
using (SqlCommand commad = new SqlCommand("usp_Login", sqlCon))
{
commad.CommandType = System.Data.CommandType.StoredProcedure;
commad.Parameters.Add(new SqlParameter("@Email", SqlDbType.VarChar));
commad.Parameters["@Email"].Value = inputModel.Login.UserName.ToString();
commad.Parameters.Add(new SqlParameter("@Password", SqlDbType.VarChar));
commad.Parameters["@Password"].Value = inputModel.Login.UserPassword.ToString();
using (IDataReader reader = commad.ExecuteReader())
{
if (reader.Read())
{
ouputModel = new OuputModel()
{
status = reader.IsDBNull(reader.GetOrdinal("Status")) ? false : Convert.ToBoolean(reader[reader.GetOrdinal("Status")]),
};
}
}
return(ouputModel);
}
}
}
public OuputModel Get(InputModel inputModel)
{
OuputModel ouputModel = null;
ouputModel = DataAccessLogic(inputModel);
return(ouputModel);
}
public async Task <IActionResult> Sample_Main(InputModel inputModel)
{
OuputModel outputModel = null;
try
{
if (inputModel == null)
{
return(BadRequest(outputModel));
}
ActionFlow actionFlow = new ActionFlow();
outputModel = await actionFlow.SampleActionFlow(inputModel);
}
catch (Exception ex)
{
throw ex;
}
return(Ok(outputModel));
}
private OuputModel DataAccessLogic(InputModel inputModel)
{
OuputModel ouputModel = null;
EmployeeModel employeeList = null;
using (SqlConnection sqlCon = new SqlConnection("Server=awsdatabase-1.cklc9dvnkg9x.ap-south-1.rds.amazonaws.com,1433;User Id=MainUser;pwd=V4wearefour;Database=Assignment"))
{
sqlCon.Open();
using (SqlCommand commad = new SqlCommand("usp_getEmployee", sqlCon))
{
commad.CommandType = System.Data.CommandType.StoredProcedure;
using (IDataReader reader = commad.ExecuteReader())
{
ouputModel = new OuputModel();
ouputModel.employeeList = new List <EmployeeModel>();
while (reader.Read())
{
employeeList = new EmployeeModel()
{
Pkempid = reader.IsDBNull(reader.GetOrdinal("Pkempid")) ? -1 : Convert.ToInt32(reader[reader.GetOrdinal("Pkempid")]),
Empname = reader.IsDBNull(reader.GetOrdinal("Empname")) ? "" : reader[reader.GetOrdinal("Empname")].ToString(),
Email = reader.IsDBNull(reader.GetOrdinal("Email")) ? "" : reader[reader.GetOrdinal("Email")].ToString(),
Password = reader.IsDBNull(reader.GetOrdinal("Password")) ? "" : reader[reader.GetOrdinal("Password")].ToString(),
Salary = reader.IsDBNull(reader.GetOrdinal("Salary")) ? -1 : Convert.ToDouble(reader[reader.GetOrdinal("Salary")]),
Isactive = reader.IsDBNull(reader.GetOrdinal("Isactive")) ? false : Convert.ToBoolean(reader[reader.GetOrdinal("Isactive")]),
Fkdeptid = reader.IsDBNull(reader.GetOrdinal("Fkdeptid")) ? -1 : Convert.ToInt32(reader[reader.GetOrdinal("Fkdeptid")]),
pkdeptid = reader.IsDBNull(reader.GetOrdinal("pkdeptid")) ? -1 : Convert.ToInt32(reader[reader.GetOrdinal("pkdeptid")]),
deptname = reader.IsDBNull(reader.GetOrdinal("deptname")) ? "" : reader[reader.GetOrdinal("deptname")].ToString(),
};
ouputModel.employeeList.Add(employeeList);
}
}
}
}
return(ouputModel);
}
public async Task <OuputModel> SampleActionFlow(InputModel inputModel)
{
OuputModel outputModel;
switch (inputModel.actionType)
{
case CommonModels.ActionType.AddEmployee:
AddEmployee addEmployee = new AddEmployee();
outputModel = addEmployee.Add(inputModel);
break;
case CommonModels.ActionType.EditEmployee:
EditEmployee editEmployee = new EditEmployee();
outputModel = editEmployee.Edit(inputModel);
break;
case CommonModels.ActionType.DeleteEmployee:
DeleteEmployee deleteEmployee = new DeleteEmployee();
outputModel = deleteEmployee.Delete(inputModel);
break;
case CommonModels.ActionType.GetEmployee:
GetEmployeeList getEmployeeList = new GetEmployeeList();
outputModel = getEmployeeList.Get(inputModel);
break;
case CommonModels.ActionType.AddDept:
AddDepatment addDepatment = new AddDepatment();
outputModel = addDepatment.Add(inputModel);
break;
case CommonModels.ActionType.EditDept:
EditDepatment editDepatment = new EditDepatment();
outputModel = editDepatment.Edit(inputModel);
break;
case CommonModels.ActionType.DeleteDept:
DeleteDepatment deleteDepatment = new DeleteDepatment();
outputModel = deleteDepatment.Delete(inputModel);
break;
case CommonModels.ActionType.GetDept:
GetDepatmentList GetDepatmentList = new GetDepatmentList();
outputModel = GetDepatmentList.Get(inputModel);
break;
case CommonModels.ActionType.Login:
LoginAction loginAction = new LoginAction();
outputModel = loginAction.login(inputModel);
break;
case CommonModels.ActionType.ForgotPassword:
LoginGet LoginGet = new LoginGet();
outputModel = LoginGet.Getlogin(inputModel);
break;
default:
outputModel = new OuputModel()
{
};
break;
}
return(await Task.FromResult(outputModel));
}
