public string MemberDetailsByMemberID(int memberID)
{
try
{
using (MemberEligibilityEntities _db = new MemberEligibilityEntities())
{
var memberObj = (from memberDetails in _db.MemberEntities
where memberDetails.MemberID == memberID
select new MemberEntityModel
{
MemberID = memberDetails.MemberID,
TechnologyID = memberDetails.TechnologyID,
MemberName = memberDetails.MemberName,
DateOfBirth = memberDetails.DateOfBirth,
Qualification = memberDetails.Qualification,
YearsOfExperience = memberDetails.YearsOfExperience,
Technology = memberDetails.TechnologyEntity.TechnologyName
}).FirstOrDefault();
var jsonobj = JsonConvert.SerializeObject(memberObj);
return(jsonobj);
}
}
catch (Exception ex)
{
throw ex;
}
}
public dynamic DeleteMemberRecordByID(int memberId)
{
List <MemberEntityModel> memberDetails = new List <MemberEntityModel>();
try
{
using (MemberEligibilityEntities _db = new MemberEligibilityEntities())
{
var memberAddEntity = _db.MemberEntities.Where(x => x.MemberID == memberId).FirstOrDefault();
_db.MemberEntities.Remove(memberAddEntity);
int iResult = _db.SaveChanges();
if (iResult > 0)
{
return(new
{
Valid = true,
Message = "Member removed successfully"
});
}
return(memberDetails);
}
}
catch (Exception ex)
{
throw ex;
}
}
public List <TechnologyEntityModel> GetAllTechnologies()
{
List <TechnologyEntityModel> technologiesObj = new List <TechnologyEntityModel>();
try
{
using (MemberEligibilityEntities _db = new MemberEligibilityEntities())
{
technologiesObj = (from technologies in _db.TechnologyEntities
select new TechnologyEntityModel
{
TechnologyID = technologies.TechnologyID,
TechnologyName = technologies.TechnologyName
}).ToList();
return(technologiesObj);
}
}
catch (Exception ex)
{
throw ex;
}
}
public List <MemberEntityModel> GetAllMemberDetails()
{
List <MemberEntityModel> memberDetails = new List <MemberEntityModel>();
try
{
using (MemberEligibilityEntities _db = new MemberEligibilityEntities())
{
memberDetails = (from memberSearchValue in _db.MemberEntities
select new MemberEntityModel
{
MemberID = memberSearchValue.MemberID,
TechnologyID = memberSearchValue.TechnologyID,
MemberName = memberSearchValue.MemberName,
DateOfBirth = memberSearchValue.DateOfBirth,
Qualification = memberSearchValue.Qualification,
YearsOfExperience = memberSearchValue.YearsOfExperience,
Technology = memberSearchValue.TechnologyEntity.TechnologyName
}).ToList();
if (memberDetails != null)
{
foreach (var item in memberDetails)
{
string dateOFBirthd = item.DateOfBirth != null?item.DateOfBirth.Value.ToString("dd/MM/yyyy") : " ";
item.DOB = dateOFBirthd;
}
}
return(memberDetails);
}
}
catch (Exception ex)
{
throw ex;
}
}
public string MemberSearchByTechnologyID(int technologyID)
{
try
{
List <MemberModelClass> objList = new List <MemberModelClass>();
using (MemberEligibilityEntities _db = new MemberEligibilityEntities())
{
objList = (from memberSearchValue in _db.MemberEntities
where memberSearchValue.TechnologyID == technologyID
select new MemberModelClass
{
MemberID = memberSearchValue.MemberID,
MemberName = memberSearchValue.MemberName
}).ToList();
var jsonobj = JsonConvert.SerializeObject(objList);
return(jsonobj);
}
}
catch (Exception ex)
{
throw ex;
}
}
public dynamic SaveMethod(MemberEntityModel MemberEntityModel)
{
List <TechnologyEntityModel> memberDetails = new List <TechnologyEntityModel>();
try
{
using (MemberEligibilityEntities _db = new MemberEligibilityEntities())
{
//Time compare
int compareDates = DateTime.Compare(DateTime.Now, MemberEntityModel.DateOfBirth.Value);
if (compareDates < 0)
{
return(new
{
Valid = false,
Message = "Selected date must be greater than today's date."
});
}
int ageDiff = new DateTime((DateTime.Now - MemberEntityModel.DateOfBirth.Value).Ticks).Year;
if (ageDiff < 25)
{
return(new
{
Valid = false,
Message = "Date of birth greater than or equal to 25 years is valid."
});
}
if (MemberEntityModel.YearsOfExperience < 3)
{
return(new
{
Valid = false,
Message = "Years Of Experience must be greater than or equal to 3."
});
}
//Check result is valid or not
var memberAddEntity = _db.MemberEntities.Where(x => x.MemberID == MemberEntityModel.MemberID).FirstOrDefault();
if (memberAddEntity == null)
{
MemberEntity newMemberEntity = new MemberEntity();
newMemberEntity.MemberName = MemberEntityModel.MemberName;
newMemberEntity.Qualification = MemberEntityModel.Qualification;
newMemberEntity.TechnologyID = MemberEntityModel.TechnologyID;
newMemberEntity.DateOfBirth = MemberEntityModel.DateOfBirth.Value;
newMemberEntity.Qualification = MemberEntityModel.Qualification;
newMemberEntity.YearsOfExperience = MemberEntityModel.YearsOfExperience;
_db.MemberEntities.Add(newMemberEntity);
int iResult = _db.SaveChanges();
if (iResult > 0)
{
return(new
{
Valid = true,
Message = "Member created Succesully"
});
}
else
{
return(new
{
Valid = false,
Message = "Member created Succesully"
});
}
}
else
{
memberAddEntity.MemberName = MemberEntityModel.MemberName;
memberAddEntity.Qualification = MemberEntityModel.Qualification;
memberAddEntity.TechnologyID = MemberEntityModel.TechnologyID;
memberAddEntity.DateOfBirth = MemberEntityModel.DateOfBirth.Value;
memberAddEntity.Qualification = MemberEntityModel.Qualification;
memberAddEntity.YearsOfExperience = MemberEntityModel.YearsOfExperience;
int iResult = _db.SaveChanges();
if (iResult > 0)
{
return(new
{
Valid = true,
Message = "Member updated Succesully"
});
}
else
{
return(new
{
Valid = true,
Message = "Member updated Succesully"
});
}
}
}
}
catch (Exception ex)
{
return(new
{
Valid = false,
Message = ex.Message.ToString()
});
throw ex;
}
}
