public static ProjKeyValueViewModel ToViewModel(this ProjKeyValue entity)
{
return(new ProjKeyValueViewModel
{
VarId = entity.VarId,
EntityId = entity.EntityId,
ProjectId = entity.ProjectId,
EnvironmentId = entity.EnvironmentId,
VarName = entity.VarName,
VarValue = entity.VarValue,
CreatedBy = entity.CreatedBy,
CreatedDate = entity.CreatedDate,
UpdatedBy = entity.UpdatedBy,
UpdatedDate = entity.UpdatedDate
});
}
public async Task <bool> UpdateProjKeyValuePair(ProjKeyValue ProjKeyValue, int varId)
{
IDbConnection dbConnection = _connectionFactory.GetConnection();
try
{
dbConnection.Open();
// var users = await dbConnection.QueryAsync<User>("Update tblUsers set email = '" + user.Email + "' where userid = " + user.UserId);
string updateQuery = @"update tblprojkeyvalues set entityid = @entityid, projectid = @projectid, environmentid = @environmentid,
varname = @varname,varvalue = @varvalue, createdby = @createdby, createddate = @createddate, updatedby = @updatedby, updateddate = @updateddate
where varid = @varid";
var result = await dbConnection.ExecuteAsync(updateQuery, new
{
ProjKeyValue.EntityId,
ProjKeyValue.ProjectId,
ProjKeyValue.EnvironmentId,
ProjKeyValue.VarName,
ProjKeyValue.VarValue,
ProjKeyValue.CreatedBy,
ProjKeyValue.CreatedDate,
ProjKeyValue.UpdatedBy,
ProjKeyValue.UpdatedDate,
varid = varId
});
return(Convert.ToBoolean(result));
}
catch (Exception ex)
{
throw ex;
}
finally
{
dbConnection.Close();
dbConnection.Dispose();
}
//return true;
//}
}
public async Task <bool> CreateKeyValuePair(ProjKeyValue ProjKeyValue)
{
IDbConnection dbConnection = _connectionFactory.GetConnection();
try
{
dbConnection.Open();
// var users = await dbConnection.QueryAsync<User>("Update tblUsers set email = '" + user.Email + "' where userid = " + user.UserId);
// string updateQuery = @"Update tblUsers set email = @email where userid =@userid";
string createQuery = @"insert into tblprojkeyvalues(varid, entityid, projectid, environmentid, varname, varvalue, createdby, createddate,updatedby, updateddate)
values(@varid, @entityid, @projectid, @environmentid,@varname, @varvalue, @createdby, @createddate, @updatedby, @updateddate)";
var result = await dbConnection.ExecuteAsync(createQuery, new
{
ProjKeyValue.VarId,
ProjKeyValue.EntityId,
ProjKeyValue.ProjectId,
ProjKeyValue.EnvironmentId,
ProjKeyValue.VarName,
ProjKeyValue.VarValue,
ProjKeyValue.CreatedBy,
ProjKeyValue.CreatedDate,
ProjKeyValue.UpdatedBy,
ProjKeyValue.UpdatedDate
});
return(Convert.ToBoolean(result));
}
catch (Exception ex)
{
throw ex;
}
finally
{
dbConnection.Close();
}
}
