public async Task <IActionResult> Register(FamilyMemberDetails FamilyMemberDetails)
{
var userWithSameEmail = _dbContext.FamilyMemberDetails.SingleOrDefault(u => u.MembEmail == FamilyMemberDetails.MembEmail);
if (userWithSameEmail != null)
{
return(BadRequest("User with this email already exists"));
}
var FamilyMemberDetailsObj = new FamilyMemberDetails
{
FamMembID = Guid.NewGuid(),
MembType = FamilyMemberDetails.MembType,
userId = FamilyMemberDetails.userId,
MembFName = FamilyMemberDetails.MembFName,
MembLName = FamilyMemberDetails.MembLName,
MembEmail = FamilyMemberDetails.MembEmail,
MembPhone1 = FamilyMemberDetails.MembPhone1,
MembPhone2 = FamilyMemberDetails.MembPhone2,
MembBirthDate = FamilyMemberDetails.MembBirthDate,
MembAge = FamilyMemberDetails.MembAge,
ModeType = FamilyMemberDetails.ModeType,
SchoolID = FamilyMemberDetails.SchoolID,
OfficeID = FamilyMemberDetails.OfficeID,
Standard = FamilyMemberDetails.Standard,
Division = FamilyMemberDetails.Division
};
_dbContext.FamilyMemberDetails.Add(FamilyMemberDetailsObj);
await _dbContext.SaveChangesAsync();
return(StatusCode(StatusCodes.Status201Created));
}
public ActionResult Details(int id)
{
var model = new FamilyMemberDetails {
FamilyMember = _dbContext.FamilyMemebers.Include(_ => _.CompletedChores).Include(_ => _.Redeptions).Single(_ => _.Id == id),
Chores = _dbContext.Chores.ToList()
};
model.PointsBalance = model.Chores.Sum(_ => _.PointValue) - model.Redeptions?.Sum(_ => _.Value) ?? 0;
return(View(model));
}
public ActionResult RemoveCompletion(int id, int memberId)
{
var familyMemeber = _dbContext.FamilyMemebers.Include(_ => _.CompletedChores).Single(_ => _.Id == memberId);
var choreToRemove = familyMemeber.CompletedChores.Single(cc => cc.Id == id);
familyMemeber.CompletedChores.Remove(choreToRemove);
_dbContext.SaveChanges();
var model = new FamilyMemberDetails {
FamilyMember = _dbContext.FamilyMemebers.Single(_ => _.Id == memberId),
Chores = _dbContext.Chores.ToList()
};
return(View("Details", model));
}
public ActionResult MarkChoreComplete(FamilyMemberDetails memberDetails)
{
var familyMemeber = _dbContext.FamilyMemebers.Include(_ => _.CompletedChores).Single(_ => _.Id == memberDetails.FamilyMember.Id);
var choreToMark = _dbContext.Chores.Single(_ => _.Id == memberDetails.SelectedChoreId);
if (familyMemeber.CompletedChores == null)
{
familyMemeber.CompletedChores = new List <CompletedChore>();
}
familyMemeber.CompletedChores.Add(new CompletedChore {
DateEntered = DateTimeOffset.Now,
PointsEarned = choreToMark.PointValue,
Chore = choreToMark
});
_dbContext.SaveChanges();
var model = new FamilyMemberDetails {
FamilyMember = _dbContext.FamilyMemebers.Single(_ => _.Id == memberDetails.FamilyMember.Id),
Chores = _dbContext.Chores.ToList()
};
return(View("Details", model));
}
public FamilyMemberDetailsBuilder()
{
birthDetails = new FamilyMemberDetails();
}
public static MemberDetailsDynamicField GetMemberDtlWithDynamicFeild(string grpuserID, string grpID)
{
try
{
MySqlParameter[] param = new MySqlParameter[2];
param[0] = new MySqlParameter("@profileId", grpuserID);
param[1] = new MySqlParameter("@GrpID", grpID);
DataSet result = MySqlHelper.ExecuteDataset(GlobalVar.strAppConn, CommandType.StoredProcedure, "V6_USPGetMemberDetailsDistrict", param);
DataTable dtMember = result.Tables[0];
DataTable dtAddress = result.Tables[3];
//DataTable dtFamilyMember = result.Tables[4];
DataTable dtSettings = result.Tables[4];
DataTable dtDynamicFields = result.Tables[5];
List <MemberDetailsDynamicField> Memberdtls = new List <MemberDetailsDynamicField>();
if (dtMember.Rows.Count > 0)
{
Memberdtls = GlobalFuns.DataTableToList <MemberDetailsDynamicField>(dtMember);
foreach (MemberDetailsDynamicField mem in Memberdtls)
{
if (!string.IsNullOrEmpty(mem.profilePic))
{
string ImageName = mem.profilePic.ToString();
string path = ConfigurationManager.AppSettings["imgPath"] + "Documents/directory/";
mem.profilePic = path + ImageName;
}
if (!string.IsNullOrEmpty(mem.familyPic))
{
string ImageName = mem.familyPic.ToString();
string path = ConfigurationManager.AppSettings["imgPath"] + "Documents/directory/";
mem.familyPic = path + ImageName;
}
}
//=============================== Get Personal Fields ===========================================
DataTable dtPersonal = new DataTable();
dtPersonal.Columns.Add("fieldID");
dtPersonal.Columns.Add("Key");
dtPersonal.Columns.Add("Value");
dtPersonal.Columns.Add("ColType");
dtPersonal.Columns.Add("Uniquekey");
dtPersonal.Columns.Add("isEditable");
dtPersonal.Columns.Add("isVisible");
for (int i = 0; i < result.Tables[1].Rows.Count; i++)
{
for (int j = 0; j < result.Tables[1].Columns.Count; j++)
{
string colName = result.Tables[1].Columns[j].ColumnName;
string isVisible = (from e in dtSettings.AsEnumerable()
where e.Field <string>("DBColName") == colName &&
e.Field <string>("fieldType") == "P"
select e.Field <string>("isVisible")).SingleOrDefault();
DataRow dr = dtPersonal.NewRow();
dr["fieldID"] = "0";
dr["Uniquekey"] = colName;
dr["isEditable"] = "1";
if (colName == "isBOD")
{
dr["isVisible"] = "n";
}
else
{
dr["isVisible"] = "y";
}
string key = (from e in dtSettings.AsEnumerable()
where e.Field <string>("DBColName") == colName &&
e.Field <string>("fieldType") == "P"
select e.Field <string>("DisplayName")).SingleOrDefault();
string colType = (from e in dtSettings.AsEnumerable()
where e.Field <string>("DBColName") == colName &&
e.Field <string>("fieldType") == "P"
select e.Field <string>("ColType")).SingleOrDefault();
dr["key"] = key;
dr["colType"] = colType;
dr["Value"] = result.Tables[1].Rows[i][j].ToString();
dtPersonal.Rows.Add(dr);
}
}
//=============================== Get Buisness Fields ===========================================
DataTable dtBuisness = new DataTable();
dtBuisness.Columns.Add("fieldID");
dtBuisness.Columns.Add("Uniquekey");
dtBuisness.Columns.Add("Value");
dtBuisness.Columns.Add("ColType");
dtBuisness.Columns.Add("key");
dtBuisness.Columns.Add("isEditable");
dtBuisness.Columns.Add("isVisible");
for (int i = 0; i < result.Tables[2].Rows.Count; i++)
{
for (int j = 0; j < result.Tables[2].Columns.Count; j++)
{
string colName = result.Tables[2].Columns[j].ColumnName;
DataRow dr = dtBuisness.NewRow();
string isVisible = (from e in dtSettings.AsEnumerable()
where e.Field <string>("DBColName") == colName &&
e.Field <string>("fieldType") == "B"
select e.Field <string>("isVisible")).SingleOrDefault();
if (isVisible == "y")
{
dr["fieldID"] = "0";
dr["Uniquekey"] = colName;
dr["isEditable"] = "1";
dr["isVisible"] = isVisible;
string query = (from lookup in dtSettings.AsEnumerable()
where lookup.Field <string>("DBColName") == colName &&
lookup.Field <string>("fieldType") == "B"
select lookup.Field <string>("DisplayName")).SingleOrDefault();
string colType = (from e in dtSettings.AsEnumerable()
where e.Field <string>("DBColName") == colName &&
e.Field <string>("fieldType") == "B"
select e.Field <string>("ColType")).SingleOrDefault();
dr["key"] = query;
dr["colType"] = colType;
dr["Value"] = result.Tables[2].Rows[i][j].ToString();
dtBuisness.Rows.Add(dr);
}
}
}
//=============================== Get Dynamic Fields ===========================================
if (dtDynamicFields != null)
{
if (dtDynamicFields.Rows.Count > 0)
{
for (int i = 0; i < dtDynamicFields.Rows.Count; i++)
{
if (dtDynamicFields.Rows[i]["FieldCategory"].ToString() == "P")
{
DataRow dr = dtPersonal.NewRow();
dr["fieldID"] = dtDynamicFields.Rows[i]["pk_fieldID"].ToString();
dr["Uniquekey"] = dtDynamicFields.Rows[i]["DisplayName"].ToString();
dr["key"] = dtDynamicFields.Rows[i]["DisplayName"].ToString();
dr["colType"] = dtDynamicFields.Rows[i]["fieldType"].ToString();
dr["Value"] = dtDynamicFields.Rows[i]["FieldValue"].ToString();
dr["isEditable"] = dtDynamicFields.Rows[i]["IsEditableByMember"].ToString();
dtPersonal.Rows.Add(dr);
}
else
{
DataRow dr = dtBuisness.NewRow();
dr["fieldID"] = dtDynamicFields.Rows[i]["pk_fieldID"].ToString();
dr["Uniquekey"] = dtDynamicFields.Rows[i]["DisplayName"].ToString();
dr["key"] = dtDynamicFields.Rows[i]["DisplayName"].ToString();
dr["colType"] = dtDynamicFields.Rows[i]["fieldType"].ToString();
dr["Value"] = dtDynamicFields.Rows[i]["FieldValue"].ToString();
dr["isEditable"] = dtDynamicFields.Rows[i]["IsEditableByMember"].ToString();
dr["isVisible"] = "y";
dtBuisness.Rows.Add(dr);
}
}
}
}
Memberdtls[0].personalMemberDetails = new List <PersonalMemberDetil>(0);
if (dtPersonal.Rows.Count > 0)
{
List <PersonalMemberDetil> personalMemberDetail = GlobalFuns.DataTableToList <PersonalMemberDetil>(dtPersonal);
Memberdtls[0].personalMemberDetails = personalMemberDetail;
}
Memberdtls[0].businessMemberDetails = new List <BusinessMemberDetail>(0);
if (dtBuisness.Rows.Count > 0)
{
List <BusinessMemberDetail> BusinessMemberDetail = GlobalFuns.DataTableToList <BusinessMemberDetail>(dtBuisness);
Memberdtls[0].businessMemberDetails = BusinessMemberDetail;
}
//=============================== Get Address Fields ===========================================
AddressList memberAddress = new AddressList();
List <AddressResult> addressList = new List <AddressResult>(0);
memberAddress.isResidanceAddrVisible = "n";
//memberAddress.isResidanceAddrVisible = (from e in dtSettings.AsEnumerable()
// where e.Field<string>("DBColName") == "Residance_Address"
// && e.Field<string>("fieldType") == "P"
// select e.Field<string>("isVisible")).SingleOrDefault();
memberAddress.isBusinessAddrVisible = (from e in dtSettings.AsEnumerable()
where e.Field <string>("DBColName") == "Business_Address" &&
e.Field <string>("fieldType") == "B"
select e.Field <string>("isVisible")).SingleOrDefault();
if (dtAddress.Rows.Count > 0)
{
addressList = GlobalFuns.DataTableToList <AddressResult>(dtAddress);
}
memberAddress.addressResult = addressList;
Memberdtls[0].addressDetails = memberAddress;
//=============================== Get Family Fields ===========================================
FamilyMemberDetails familyDtl = new FamilyMemberDetails();
List <FamilyMemberDetail> FamilyMemberlist = new List <FamilyMemberDetail>(0);
familyDtl.isVisible = "n";
familyDtl.familyMemberDetail = FamilyMemberlist;
Memberdtls[0].familyMemberDetails = familyDtl;
//familyDtl.isVisible = (from e in dtSettings.AsEnumerable()
// where e.Field<string>("DBColName") == "member_name"
// && e.Field<string>("fieldType") == "F"
// select e.Field<string>("isVisible")).SingleOrDefault();
//if (familyDtl.isVisible == "y")
//{
// FamilyMemberlist = GlobalFuns.DataTableToList<FamilyMemberDetail>(dtFamilyMember);
//}
//familyDtl.familyMemberDetail = FamilyMemberlist;
//Memberdtls[0].familyMemberDetails = familyDtl;
}
return(Memberdtls[0]);
}
catch
{
throw;
}
}
