public string SaveReferences(ReferencesModel model)
{
ResultHelper _resultHelper = new ResultHelper();
using (var db = new nasccoEntities())
{
using (DbContextTransaction dbTran = db.Database.BeginTransaction())
{
try
{
var data = db.references.Create();
data.full_name = model.ReferencesFullName;
data.relation = model.ReferencesRelation;
data.address = model.ReferencesAddress;
data.contact_number = model.ReferencesContactNumber;
data.member_id = model.ReferencesMemberId;
data.created_by_user_id = model.ReferencesCreatedByUserId;
data.date_created = DateTime.Now;
db.references.Add(data);
db.SaveChanges();
//Save if no issues
dbTran.Commit();
return(_resultHelper.Success());
}
catch (Exception ex)
{
dbTran.Rollback();
return(ex.Message);
}
}
}
}
public ActionResult GetReferencesDetail(int Id)
{
ReferencesModel model = new ReferencesModel();
model = _memberManager.GetReferencesDetail(Id);
model.ReferencesIsEditMode = true;
return(PartialView("~/Views/Member/CreateReferences.cshtml", model));
}
public ActionResult CreateReferences(int?id)
{
int Id_ = NullIdProcessor(id);
var model = new ReferencesModel();
model.ReferencesMemberId = Id_;
return(PartialView("~/Views/Member/CreateReferences.cshtml", model));
}
public ActionResult Show2(long sourceId, long sourceTypeId, int sourceVersion)
{
ReferencesModel model = new ReferencesModel();
EntityReferenceHelper helper = new EntityReferenceHelper();
model.Selected = helper.GetSimpleReferenceModel(sourceId, sourceTypeId, sourceVersion);
model.TargetReferences = helper.GetTargetReferences(sourceId, sourceTypeId, sourceVersion);
model.SourceReferences = helper.GetSourceReferences(sourceId, sourceTypeId, sourceVersion);
model.HasEditRights = hasUserRights(sourceId, RightType.Write);
return(View("Show", model));
}
public ReferencesModel GetReferencesDetail(int id)
{
nasccoEntities db = new nasccoEntities();
ReferencesModel model = new ReferencesModel();
var c = db.references.FirstOrDefault(x => x.id == id);
if (c != null)
{
model.ReferencesId = c.id;
model.ReferencesFullName = c.full_name;
model.ReferencesRelation = c.relation;
model.ReferencesAddress = c.address;
model.ReferencesContactNumber = c.contact_number;
}
return(model);
}
public ActionResult UpdateReferences(ReferencesModel model)
{
var message = "message";
var result = "result";
result = _memberManager.UpdateReferences(model);
if (model != null && ModelState.IsValid)
{
message = result;
}
else
{
message = ModelState.ModelErrors();
}
return(Json(new { message = message, result = result }));
}
public ActionResult SaveReferences(ReferencesModel model)
{
var message = "message";
var result = "result";
model.ReferencesCreatedByUserId = ActiveUser.UserId;
result = _memberManager.SaveReferences(model);
if (model != null && ModelState.IsValid)
{
message = result;
}
else
{
message = ModelState.ModelErrors();
}
return(Json(new { message = message, result = result }));
}
public string UpdateReferences(ReferencesModel model)
{
ResultHelper _resultHelper = new ResultHelper();
using (var db = new nasccoEntities())
{
try
{
var data = db.references.FirstOrDefault(x => x.id == model.ReferencesId);
data.full_name = model.ReferencesFullName;
data.relation = model.ReferencesRelation;
data.address = model.ReferencesAddress;
data.contact_number = model.ReferencesContactNumber;
db.SaveChanges();
return(_resultHelper.Success());
}
catch (Exception ex)
{
return(ex.Message);
}
}
}
