public JsonResult Update(CommitteMember committeMember)
{
var data = _db.CommitteMembers.FirstOrDefault(x => x.MemberID == committeMember.MemberID);
if (data != null)
{
data.Name = committeMember.Name;
data.Address = committeMember.Address;
data.ContactNo = committeMember.ContactNo;
data.Age = committeMember.Age;
_db.SaveChanges();
}
return(Json(JsonRequestBehavior.AllowGet));
}
public ActionResult <object> Save([FromBody] CommitteMemberForm committeMemberForm)
{
try
{
Init();
StringBuilder sbError = new StringBuilder("");
if (!ModelState.IsValid)
{
Response.StatusCode = 400;
return("Failed getting committe Member id");
}
else
{
CommitteMember committeMember = new CommitteMember();
committeMember.SchoolID = _user.SchoolID;
committeMember.Fullname = committeMemberForm.Fullname;
committeMember.Phone = committeMemberForm.Phone;
committeMember.Email = committeMemberForm.Email;
committeMember.Title = committeMemberForm.Title;
var isSaved = _committeMemberService.Save(committeMember, ref sbError);
if (isSaved == null)
{
Response.StatusCode = 400;
return("committeMember save failed " + sbError.ToString());
}
else
{
return(Ok(new { id = isSaved.CommitteMemberID }));
}
}
}
catch (Exception er)
{
return(Error(er));
}
}
public CommitteMember Save(CommitteMember committeMember, ref StringBuilder sbError)
{
if (committeMember == null)
{
sbError.Append("fill in all fields");
}
if (committeMember.CommitteMemberID == null)
{
committeMember.SchoolID = _user.SchoolID;
}
if (string.IsNullOrEmpty(committeMember.Title))
{
sbError.Append("Commitee member title does not exist");
}
if (string.IsNullOrEmpty(committeMember.Fullname))
{
sbError.Append("Commitee member Fullname is required");
}
if (!string.IsNullOrEmpty(committeMember.Phone))
{
if (!committeMember.Phone.IsPhoneValid(ref sbError))
{
sbError.Append("Phone not valid");
}
}
if (!string.IsNullOrEmpty(committeMember.Email))
{
if (!committeMember.Email.IsValidEmail())
{
sbError.Append("Email is not valid");
}
}
bool dbFlag = false;
if (committeMember.CommitteMemberID != null && committeMember.CommitteMemberID != Guid.Empty)
{
var isExist = _uofRepository.CommitteMemberRepository.GetCommitteMemberByID((Guid)committeMember.CommitteMemberID, ref dbFlag);
if (isExist == null)
{
sbError.Append("Commitee Member does not exist");
}
else
{
if (_user.SchoolID != isExist.SchoolID)
{
sbError.Append("Commitee Member does not belong to school");
}
}
}
if (!string.IsNullOrEmpty(sbError.ToString()))
{
return(null);
}
var isSaved = _uofRepository.CommitteMemberRepository.Save(committeMember, _user.Username, ref dbFlag);
return(isSaved);
}
public CommitteMember Save(CommitteMember objCommiteMember, string modifiedBy, ref bool dbError)
{
try
{
using (var connection = GetConnection())
{
if (objCommiteMember.CommitteMemberID == null)
{
objCommiteMember.CommitteMemberID = Guid.NewGuid();
var update = @"
INSERT INTO CommitteMember
(
CommitteMemberID
,SchoolID
,Title
,Fullname
,Phone
,Email
,LastModifiedBy
)
VALUES
(
@id
,@schoolID
,@title
,@Fullname
,@phone
,@email
,@modifiedBy
)
";
var id = connection.Execute(update,
new
{
id = objCommiteMember.CommitteMemberID,
schoolID = objCommiteMember.SchoolID,
title = objCommiteMember.Title,
fullname = objCommiteMember.Fullname,
phone = objCommiteMember.Phone,
email = objCommiteMember.Email,
modifiedBy = modifiedBy
});
}
else
{
var update = @"
UPDATE CommitteMember
SET Title = @title
, Fullname = @fullname
, Phone = @phone
, Email = @email
,LastModifiedBy = @modifiedBy
WHERE CommitteMemberID = @committeMemberID
AND ISDeleted IS NULL
";
var id = connection.Execute(update,
new
{
committeMemberID = objCommiteMember.CommitteMemberID,
schoolID = objCommiteMember.SchoolID,
title = objCommiteMember.Title,
fullname = objCommiteMember.Fullname,
phone = objCommiteMember.Phone,
email = objCommiteMember.Email,
modifiedBy = modifiedBy
});
}
return(objCommiteMember);
}
}
catch (Exception er)
{
dbError = true;
DbLog.Error(er);
return(null);
}
}
public JsonResult Add(CommitteMember committeMember)
{
_db.CommitteMembers.Add(committeMember);
_db.SaveChanges();
return(Json(JsonRequestBehavior.AllowGet));
}
