public ResultEntity <GroupAdministratorEntity> Update(GroupAdministratorEntity groupadministratorEntity)
{
var validationResult = new ResultEntity <GroupAdministratorEntity>();
using (var groupadministratorDA = new GroupAdministratorDA())
{
var groupList = groupadministratorDA.GetByGroupName(groupadministratorEntity.GroupName);
var linq = (from x in groupList
where x.ID != groupadministratorEntity.ID
select x).ToList <GroupAdministratorEntity>();
if (linq.Count() > 0)
{
validationResult.Warning.Add("Groupname " + groupadministratorEntity.GroupName + " already exist");
return(validationResult);
}
groupadministratorEntity.ModifiedDate = DateTime.Now;
var resultUpdate = groupadministratorDA.Update(groupadministratorEntity);
if (resultUpdate <= 0)
{
validationResult.Warning.Add("Failed Updating GroupAdministrator!");
return(validationResult);
}
validationResult.Value = groupadministratorEntity;
}
return(validationResult);
}
public JsonResultEntity Create([FromBody] GroupAdministratorEntity groupadministratorEntity)
{
GroupAdministratorBL groupadministratorBL = new GroupAdministratorBL();
JsonResultEntity response = new JsonResultEntity();
try
{
groupadministratorEntity.CreatedBy = GetUserID();
groupadministratorEntity.CreatedDate = DateTime.Now;
var result = groupadministratorBL.Create(groupadministratorEntity);
if (result.HasWarning())
{
response.Message = String.Join(",", result.Warning);
return(response);
}
response.Success = true;
response.Data = result.Value;
}
catch (Exception ex)
{
response.Message = ex.Message;
LoggerHelper.Error(ex);
}
return(response);
}
public GroupAdministratorEntity Create(GroupAdministratorEntity groupadministratorEntity)
{
var query = @"INSERT INTO ""GroupAdministrator""(""GroupName"",""Description"",""CreatedBy"",""CreatedDate"") VALUES(@GroupName,@Description,@CreatedBy,@CreatedDate) RETURNING ""ID"";";
int id = DbConnection.Query <int>(query, groupadministratorEntity).Single();
groupadministratorEntity.ID = id;
return(groupadministratorEntity);
}
public int Update(GroupAdministratorEntity groupadministratorEntity)
{
int affectedRows = 0;
if (IsHaveId <GroupAdministratorEntity>(groupadministratorEntity) == false)
{
var query = @"UPDATE ""GroupAdministrator"" SET ""GroupName""=@GroupName,""Description""=@Description,""ModifiedBy""=@ModifiedBy,""ModifiedDate""=@ModifiedDate WHERE ""ID""=@ID";
affectedRows = DbConnection.Execute(query, groupadministratorEntity);
}
return(affectedRows);
}
public ResultEntity <GroupAdministratorEntity> Create(GroupAdministratorEntity groupadministratorEntity)
{
var validationResult = new ResultEntity <GroupAdministratorEntity>();
using (var groupadministratorDA = new GroupAdministratorDA())
{
var groupList = groupadministratorDA.GetByGroupName(groupadministratorEntity.GroupName);
if (groupList.Count() > 0)
{
validationResult.Warning.Add("Groupname " + groupadministratorEntity.GroupName + " already exist");
return(validationResult);
}
groupadministratorEntity.CreatedDate = DateTime.Now;
validationResult.Value = groupadministratorDA.Create(groupadministratorEntity);
}
return(validationResult);
}
