private static decimal CalculateIncomeForTheGiveLastTwoYears(SelfEmployment selfEmployment)
{
var averageIncome = (selfEmployment.NetProfitSecondLastYear + selfEmployment.NetProfitLastYear) / 2m;
return(GetExpectedNetProfitCurrentYearIfGraterThanAverageIncome(selfEmployment.ExpectedNetProfitCurrentYear,
averageIncome));
}
public IHttpActionResult GetApplication(string District, string Status)
{
List <SelfEmployment> CWList = new List <SelfEmployment>();
using (SqlConnection kvdConn = new SqlConnection(ConfigurationManager.ConnectionStrings["myConnStr"].ConnectionString))
{
using (SqlCommand cmd = new SqlCommand("spGetDataToApprovalProcess", kvdConn))
{
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@status", Status); //"SESELECTCW"
cmd.Parameters.AddWithValue("@District", District); //"Bengaluru Dakshina"
cmd.Connection = kvdConn;
kvdConn.Open();
using (SqlDataReader sdr = cmd.ExecuteReader())
{
while (sdr.Read())
{
SelfEmployment CW = new SelfEmployment();
CW.ApplicationNumber = sdr["ApplicationNumber"].ToString();
CW.ApplicantName = sdr["ApplicantName"].ToString();
CW.FinancialYear = sdr["Gender"].ToString();
CWList.Add(CW);
}
}
kvdConn.Close();
}
}
return(Ok(CWList));
}
public void Create(SelfEmployment selfEmpl)
{
Guard.WhenArgument(selfEmpl, "selfEmpl").IsNull().Throw();
this.selfEmployments.Add(selfEmpl);
this.selfEmployments.SaveChanges();
}
public void ConstructorWhenIsInvoked_ShouldNotSet_EmployeeIdProperty()
{
// Arrange & Act
var selfEmpl = new SelfEmployment();
// Assert
Assert.AreEqual(0, selfEmpl.EmployeeId);
}
public void ConstructorWhenIsInvoked_ShouldSetPropertyRemunerationBillsAsEmptyHashSet()
{
// Arrange & Act
var selfEmpl = new SelfEmployment();
// Assert
Assert.IsAssignableFrom(typeof(DateTime), selfEmpl.CreatedDate);
}
public void WhenConstructorIsInvoked_ShouldSetInstanceOfSelfEmploymentCorrectly()
{
// Arrange & Act
var selfEmpl = new SelfEmployment();
// Assert
Assert.IsInstanceOf(typeof(SelfEmployment), selfEmpl);
}
public void ConstructorWhenIsInvoked_ShouldNotSet_SocialSecurityIncomeProperty()
{
// Arrange & Act
var selfEmpl = new SelfEmployment();
// Assert
Assert.AreEqual(0m, selfEmpl.SocialSecurityIncome);
}
public void ConstructorWhenIsInvoked_ShouldNotSet_PersonalInsuranceProperty()
{
// Arrange & Act
var selfEmpl = new SelfEmployment();
// Assert
Assert.AreEqual(0m, selfEmpl.PersonalInsurance);
}
public void ConstructorWhenIsInvoked_ShouldNotSet_NetWageProperty()
{
// Arrange & Act
var selfEmpl = new SelfEmployment();
// Assert
Assert.AreEqual(0m, selfEmpl.NetWage);
}
private static decimal CalculateIncomeForTheGiveLastThreeYears(SelfEmployment selfEmployment)
{
var averageIncome = (selfEmployment.NetProfitThirdLastYear +
selfEmployment.NetProfitSecondLastYear +
selfEmployment.NetProfitLastYear) / 3m;
return(selfEmployment.NetProfitLastYear < averageIncome
? selfEmployment.NetProfitLastYear
: averageIncome);
}
public void WhenParameterGrossSalary_IsSetWithValidValue_ShouldSetUpCorrectly(decimal num)
{
// Arrange
var selfEmpl = new SelfEmployment();
// Act
selfEmpl.GrossSalary = num;
// Assert
Assert.AreEqual(num, selfEmpl.GrossSalary);
}
public ActionResult CreateFreelanceContract(int id, SelfEmployment selfEmployment)
{
var employee = this.employeeService.GetById(id);
selfEmployment.EmployeeId = id;
selfEmployment.Employee = employee;
var freelanceContractModel = this.mapService.Map <CreateSelfEmploymentViewModel>(selfEmployment);
freelanceContractModel.CreatedDate = DateTime.Now;
return(View(freelanceContractModel));
}
public ActionResult Delete(int id, SelfEmployment selfEmployment)
{
selfEmployment = this.selfEmploymentService.GetById(id);
if (selfEmployment == null)
{
return(HttpNotFound());
}
var freelanceContractModel = this.mapService.Map <PreviewSelfEmploymentViewModel>(selfEmployment);
return(View(freelanceContractModel));
}
public ActionResult Edit(int id, SelfEmployment selfEmployment)
{
selfEmployment = this.selfEmploymentService.GetById(id);
if (selfEmployment == null)
{
return(HttpNotFound());
}
var freelanceContractModel = this.mapService.Map <PreviewSelfEmploymentViewModel>(selfEmployment);
var employee = this.employeeService.GetById(selfEmployment.EmployeeId);
freelanceContractModel.EmployeeId = employee.Id;
freelanceContractModel.EmployeeFullName = employee.FirstName + " " + employee.MiddleName + " " + employee.LastName;
return(View(freelanceContractModel));
}
public void PropertiesWithRequiredAttribute_ShouldReturnTrue(string propertyName)
{
// Arrange
var selfEmpl = new SelfEmployment();
// Act
var result = selfEmpl.GetType()
.GetProperty(propertyName)
.GetCustomAttributes(false)
.Where(x => x.GetType() == typeof(RequiredAttribute))
.Any();
// Assert
Assert.IsTrue(result);
}
public void GetSelfEmployment()
{
string SQL = @"select ApplicationNumber,ApplicantName,Gender,RDNumber,MobileNumber,Quota,ParmanentAddress,ParDistrict,ParConstituency,ParPincode,AadharNum,AnualIncome,PhysicallyChallenged,EmailID
,CONVERT(VARCHAR(20),DoB,110) as DoB
,CASE WHEN CWApprove = 'REJECTED' THEN CWApprove+' : '+RejectReason else CWApprove END CWStatus
,CASE WHEN DMApprove = 'REJECTED' THEN DMApprove+' : '+DMRejectReason else DMApprove END DMStatus
,CASE WHEN DMCEOApprove = 'REJECTED' THEN DMCEOApprove+' : '+DMCEORejectReason WHEN DMCEOApprove = 'APPROVED' THEN DMCEOApprove+' : '+LoanAmount else DMCEOApprove END CEOStatus
,CASE WHEN DMDocApprove = 'REJECTED' THEN DMDocApprove+' : '+DMDocRejectReason else DMDocApprove END DOCStatus
,CASE WHEN ZMApprove = 'REJECTED' THEN ZMApprove+' : '+ZMRejectReason else ZMApprove END ZMStatus
,datediff(year,DoB,getdate()) as Age
from SelfEmpLoan" ;
List <SelfEmployment> SEApplication = new List <SelfEmployment>();
using (SqlConnection kvdConn = new SqlConnection(ConfigurationManager.ConnectionStrings["myConnStr"].ConnectionString))
{
SqlCommand cmd = new SqlCommand(SQL, kvdConn);
cmd.CommandType = CommandType.Text;
kvdConn.Open();
SqlDataReader rdr = cmd.ExecuteReader();
while (rdr.Read())
{
SelfEmployment SE = new SelfEmployment();
SE.ApplicationNumber = rdr["ApplicationNumber"].ToString();
SE.ApplicantName = rdr["ApplicantName"].ToString() + "<br />" + rdr["Gender"].ToString() + "<br /> PH : " + rdr["PhysicallyChallenged"].ToString();
SE.RDNumber = rdr["RDNumber"].ToString() + "<br />" + rdr["AadharNum"].ToString();
SE.MobileNumber = rdr["MobileNumber"].ToString() + "<br />" + rdr["EmailID"].ToString();
SE.IncomeDoB = rdr["AnualIncome"].ToString() + "<br />" + rdr["DoB"].ToString() + " (" + rdr["Age"].ToString() + ")";
SE.Quota = rdr["Quota"].ToString();
SE.CWStatus = rdr["CWStatus"].ToString();
SE.Status = "CW : " + rdr["CWStatus"].ToString() + "<br />DM : " + rdr["DMStatus"].ToString() + "<br />CEO : " + rdr["CEOStatus"].ToString() + "<br />DOC : " + rdr["DOCStatus"].ToString() + "<br />ZM : " + rdr["ZMStatus"].ToString();
SE.DMStatus = rdr["DMStatus"].ToString() + "\n" + rdr["DMStatus"].ToString();
SE.CEOStatus = rdr["CEOStatus"].ToString();
SE.DOCStatus = rdr["DOCStatus"].ToString();
SE.ZMStatus = rdr["ZMStatus"].ToString();
SE.ParmanentAddress = rdr["ParmanentAddress"].ToString() + "<br />" + rdr["ParConstituency"].ToString() + "(C)" + "<br />" + rdr["ParDistrict"].ToString() + "(D)" + "<br />" + rdr["ParPincode"].ToString();
//SE.NullColumn = "<input type=\"checkbox\" name=\"SelfEmploymentSelectApplication\" />";
SEApplication.Add(SE);
}
}
JavaScriptSerializer js = new JavaScriptSerializer();
Context.Response.Write(js.Serialize(SEApplication));
}
public void ReturnHttpNotFoundResult_WhenEmployeeIsNull()
{
// Arrange
var mapService = new Mock <IMapService>();
var employeeService = new Mock <IEmployeeService>();
var selfEmploymentService = new Mock <ISelfEmploymentService>();
var payrollCalculations = new Mock <Payroll>();
var id = 5;
SelfEmployment freelanceContractModel = null;
selfEmploymentService.Setup(x => x.GetById(id)).Returns(freelanceContractModel).Verifiable();
// Act
var freelanceController = new FreelanceContractController(mapService.Object, employeeService.Object, selfEmploymentService.Object, payrollCalculations.Object);
// Assert
Assert.IsInstanceOf <HttpNotFoundResult>(freelanceController.Delete(id, freelanceContractModel));
}
public void HttpGet_ReturnHttpNotFoundResult_WhenPaycheckIsNull()
{
// Arrange
var mapService = new Mock <IMapService>();
var employeeService = new Mock <IEmployeeService>();
var selfEmploymentService = new Mock <ISelfEmploymentService>();
var payrollCalculations = new Mock <Payroll>();
var id = 5;
var freelanceContractModel = new Mock <PreviewSelfEmploymentViewModel>();
SelfEmployment mockedBill = null;
selfEmploymentService.Setup(x => x.GetById(id)).Returns(mockedBill).Verifiable();
// Act & Assert
var nonLaborController = new FreelanceContractController(mapService.Object, employeeService.Object, selfEmploymentService.Object, payrollCalculations.Object);
Assert.IsInstanceOf <HttpNotFoundResult>(nonLaborController.Edit(id, mockedBill));
}
public void UpdateById(int id, SelfEmployment updatePaycheck)
{
this.selfEmployments.Update(updatePaycheck);
this.selfEmployments.SaveChanges();
}
private static decimal CalculateIncomeForTheGiveLastYear(SelfEmployment selfEmployment)
{
return(GetExpectedNetProfitCurrentYearIfGraterThanAverageIncome(selfEmployment.ExpectedNetProfitCurrentYear, selfEmployment.NetProfitLastYear));
}
